Software Applications Programming Errors and solutions.

Show parent child node value at runtime and populate treeview in asp.net. This program is use to populate treeview at runtime using asp.net. you can try this code. Imports System.Data Imports System.Configuration Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Imports System.Data.SqlClient Imports System.Web.UI.WebControls.TreeNode Partial Class Bibliography Inherits System.Web.UI.Page Dim clscmn1 As New clsCommon Dim cn As New clsConnection Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then PopulateRootLevel() Else Exit Sub End If End Sub Private Sub PopulateRootLevel() Dim dt1 As New DataTable() Dim objCommand As New SqlCommand("select PRODUCT_CATEGORY_CD,PRODUCT_CATEGORY,(select count(*) FROM PRODUCT_CATEGORY ...

Add items to menu at runtime using asp.net Dim str, str1 As String str = "select distinct PRODUCT_CATEGORY,PARENT_CATEGORY_CD,PRODUCT_CATEGORY_CD from PRODUCT_CATEGORY where PARENT_CATEGORY_CD is NULL" Dim adp As New SqlDataAdapter(str, cn.openDb()) adp.Fill(ds) cn.closeDb() If (ds.Tables(0).Rows.Count > 0) Then For Each dr In ds.Tables(0).Rows Dim mu As MenuItem = New MenuItem mu.Text = dr("PRODUCT_CATEGORY").ToString mu.Value = dr("PRODUCT_CATEGORY_CD").ToString BrowsebyCategory.Items.Add(mu) Next End If This code is to Add items to menu at runtime using asp.net code you can use code to backend side Simple Display message using asp.net Simple Display message using asp.net. Just use following code. Dim myStringVariable As String = String.Empty myStringVariable = "Message" ClientScript.RegisterStartupScript(Me.[GetType](), "myalert", "alert('" & myStringVariab...

Daynamics Axapta Coverage and help materials for developper using language x++: Fill combo box using axapta x++ code  

New challenges of Globalization Globalization, the point is frequently overlooked that it is an ancient phenomenon. In the modern world, it began to gather strength at the end of the 15th century and strengthened in the 16th and 17th centuries with the maritime exploration of the Portuguese and Spanish and later the English, French, the Dutch, who put Europe in contact with the rest of the world. In the 20th century, especially after World War II, Europe lost its global hegemony, and was devastated, along with Japan. Two non-European countries, the United States and the Soviet Union, then became the dominant powers and their ideological, economic, and military rivalry divided the world into two opposing blocs. This was the beginning of the Cold War, which kept the world suspended in an “equilibrium of terror”. In parallel, in the 50’s and 60’s, the process of decolonization led to the emergence of the Movement of the Non-Aligned Countries and later the Third World movement. Mean...

You should have original content. Content is the key factor of any excellent Web site. The ability to take a common subject and give it some interest and originality is a rare talent,but necessary to keep visitors coming back. You should update the content twice in a month. After that you should have great graphics in your website. If your graphics are correctly used they can greatly improve a web site and it's content. If you overuse or they will take a lot of time to load, you will drive visitors away before they even see the content. You don't need expensive programs or graphics you just need simple and decent graphics. Third, you need a good presentation. Good Web sites do not keep the user guessing. They make their purpose immediately evident and present an easy to follow navigation system. The content and graphics blend in perfectly with the presentation and following it is a simple matter. You will never find hyperbole or confusion caused by overuse of animated gr...

It is important for you to be prepared for a telephone interview. Always keep your resume in a place where you can easily view it. You will be asked questions during the interview that you may need to answer with the information you have on your resume. You should always have a pen and paper ready. You may be required to write down important information, and you won't have time to go look for these things. Missing the interview will kill your chances of being hired immediately. Before the interview starts, you will need to make sure you are in a quiet place. Noisy distractions such as pets, children, and loud noises must be stopped before the interview starts. While conducting a telephone interview may sound easy, it is more difficult than you think. It is best to practice the telephone interview. You can do this with your family or friends. While speaking properly is important in a standard interview, it is crucial on the telephone. The interviewer will place an em...

Most of the people in today's world are going crazy about personal development .Mostly those individuals who wish to be successful in their career can often be seen joining personal development courses.But many of them are unaware of the fact that personal development can't just be achieved by joining a course or by being extra ordinary as far as studies are concerned.The main purpose of personal development is to analyze your own self and figure out the weakness within you.Then try to work on it because ignoring it can cause serious harm to you in future. How do work for personal development: Here are a few points,considering them any individual can work on personal development and achieve success. - Try to develop a healthy life style.Healthy body and healthy mind are the per-requisites for personal development.Do do not get careless about your diet,exercise and sleep.Also work on your looks and try to improve on it,because good look can boost up your confidence and ca...

Most of the Top Universities like MIT, Stanford, Wharton, UC Berkeley, Washington, NOVA etc., are offering online video courses. You can find below attachment the links to more than 110 free online video courses from those Top Universities on various Subjects. These are class room recorded videos. You will also find several PPT Presentations. The best part is that to access them you don’t need to login and No fee is required. So make the best use of them Computer Science & Programming (31) 1. Introductory Programming [University of Washington] 2. Understanding Computers and the Internet [Harvard University] 3. Computer System Engineering 4. Freshman Computer Science Seminar 5. Data Structures 6. Graduate Computer Architecture 7. Introduction to Algorithms 8. Introduction to Computers 9. Machine Structures 10. Computer Language Engineering 11. Data Structures, Algorithms and Applications in Java 12. Introduction to Copy Right Law 13. Operating Systems and System...

Java Code Menu And Menu Items import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.event.*; import java.io.*; import javax.swing.SwingUtilities; import javax.swing.undo.*; class MyMenu1 implements ActionListener { JFrame f; JMenuBar menubar; JMenu menu,submenu; JMenuItem menuitem; JRadioButtonMenuItem rbmt; JCheckBoxMenuItem cbmt; JTextArea ta; DataInputStream dis; JFileChooser fc,fc1; String record=null; JScrollPane sp; protected UndoManager undo; MyMenu1() { f=new JFrame("my notepad"); f.setBounds(0,0,1200,1000); menubar=new JMenuBar(); ta=new JTextArea(); ta.setEditable(true); int v=JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED;int h=JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED; sp=new JScrollPane(ta,v,h); sp.setVerticalScrollBarPolicy(v); sp.setHorizontalScrollBarPolicy(h); sp.setBounds(0,30,1130,750); sp.setVisible(true); f.add(sp); undo=new UndoManager(); //file menu menu=new JMenu("File"); m...

How To Get Targeted Visitors To Your Site Are you interested in driving killer targeted website traffic? Are you confused as to what to do to get traffic rushing and swimming all over your site? Your site is finally ready, now all you need to do is drive crazy traffic rushing into your site to make all the sales and money you have ever dreamed of. If you want to drive tons of visitors to your site interested in purchasing your products and services, make sure you apply these 4 steps every single day in your internet marketing plan. These 4 steps gets me around 1000 visitors to my site every single month absolutely FREE. Step 1 - Email Marketing. Step 2 - Social Networking. Step 3 - Forum Marketing. Step 4 - Article Marketing. The purpose of this article is to show you the exact steps that I am personally using to market my website and drive killer targeted website traffic. Lets get down into dirty internet marketing tactics... Step 1 - Email Marketing. If you...

function validPwd() uname = frm.logid.value if uname = "" then msgbox "Enter Your Login ID" frm.logid.focus() else if not Isnumeric(uname) then msgbox "Enter Proper Value for Login ID" frm.logid.focus() else matcholdpwd() end if end if end function function matcholdpwd() oldpwd = frm.pawd.value if oldpwd = "" then msgbox "Please Enter YourPassword" frm.pawd.focus() else submitForm() end if end function function submitForm() frm.submit() end function function changepwd() window.location = "changepwd.asp" end function function ForgetPass() document.frm.action ="ForgetPass.asp" document.frm.method ="post" document.frm.submit() end function

// Prototypes void DisplayMenu(); int GetSelection(); // The main() function. int main() { // Display the menu. DisplayMenu(); // Get the menu selection. int selection; selection = GetSelection(); // Select the matching process. if (selection == 1) std::cout << "Processing Receivables" << std::endl; else if (selection == 2) std::cout << "Processing Payables" << std::endl; else if (selection == 3) std::cout << "Quitting" << std::endl; else std::cout << "\aInvalid selection" << std::endl; return 0; } void DisplayMenu() { std::cout << "--- Menu ---" << std::endl; std::cout << "1=Receivables" << std::endl; std::cout << "2=Payables" << std::endl; std::cout << "3=Quit" << std::endl; } int GetSelection() { int selection; std::cou...

class ListEntry { char* listvalue; ListEntry* preventry; public: ListEntry(char*); ~ListEntry() { delete [] listvalue; } ListEntry* PrevEntry() const { return preventry; }; void display() const { std::cout << std::endl << listvalue; } // Use the 'this' pointer to chain the list. void AddEntry(ListEntry& le) { le.preventry = this; } }; // The constructor definition. ListEntry::ListEntry(char* s) { listvalue = new char[std::strlen(s)+1]; std::strcpy(listvalue, s); preventry = 0; } int main() { ListEntry* prev = 0; // Read in some names. while (1) { std::cout << std::endl << "Enter a name ('end' when done): "; char name[25]; std::cin >> name; if (std::strncmp(name, "end", 3) == 0) break; // Make a list entry of the name. ListEntry* list = new ListEntry(name); // Add the entry to the linked list. if (prev != 0) ...

Trim string from sentence in excel Public Function trimtwo(ByVal r As Range) As String Dim str As String str = r(1, 1) Dim Flag As Boolean Flag = False Dim indexof As Integer indexof = InStr(str, "Shri") If indexof Then str = Mid(str, indexof + 4, Len(str)) Flag = True End If indexof = InStr(str, "SHRI") If indexof Then str = Mid(str, indexof + 4, Len(str)) Flag = True End If indexof = InStr(str, "Smt.") If indexof Then 'str = Mid(str, 1, 1) & Mid(str, indexof + 5, Len(str)) str = Mid(str, indexof + 5, Len(str)) Flag = True End If indexof = InStr(str, ",") If indexof Then str = Mid(str, 1, indexof - 1) End If str = Trim(str) If Flag Then indexof = InStr(str, " ") If indexof Then str = Mid(str, 1, indexof - 1) & Mid(str, indexof + 1, Len(str)) End If End If trimtwo = str End Function Public Function trimone(ByVal r As...

Vlookup in excel to get value from other sheet and use of instr function Vlookup example =IF(ISERROR(VLOOKUP(J5,Designation!$B$2:Designation!$D$130,3,FALSE)),"",VLOOKUP(J5,Designation!$B$2:Designation!$D$130,3,FALSE)) =IF(ISERROR(VLOOKUP(G6,EmployeeDetails!$E$2:$F$18,2,FALSE)),"",VLOOKUP(G6,EmployeeDetails!$E$2:$F$18,2,FALSE)) Public Function scut(ctxt As String) As String Dim ind As Integer ind = InStr(ctxt, "0") Dim rstr As String rstr = Mid(ctxt, 1, ind - 1) scut = rstr End Function This is simple example of Vlookup. How to use vlookup in Excel worksheet. =trims(C2) =IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$E$2:$J$470,6,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$F$2:$J$470,5,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$G$2:$J$470,4,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$H$2:$J$470,3,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$I$2:$J$470,2,FALSE)),"",VLOOKUP(TRIM(B2),EInfo!$I$2:$J$470,2,FALSE)),VLOOKUP(TRIM(B...

Option Explicit '32-bit API declarations 'Test the code: 'Click Tools --> Macro --> Macros... 'Select CombineFiles and press Run. Declare Function SHGetPathFromIDList Lib "shell32.dll" _ Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal _ pszpath As String) As Long Declare Function SHBrowseForFolder Lib "shell32.dll" _ Alias "SHBrowseForFolderA" (lpBrowseInfo As BrowseInfo) _ As Long Public Type BrowseInfo hOwner As Long pIDLRoot As Long pszDisplayName As String lpszTitle As String ulFlags As Long lpfn As Long lParam As Long iImage As Long End Type Function GetDirectory(Optional msg) As String On Error Resume Next Dim bInfo As BrowseInfo Dim path As String Dim r As Long, x As Long, pos As Integer 'Root folder = Desktop bInfo.pIDLRoot = 0& 'Title in the dialog If IsMissing(msg) Then bInfo.lpszTitle = "Please sel...

Option Explicit 'Copy a range/column after the last column with data 'Note: This example use the function LastCol 'This example copy column A from each sheet after the last column with data on the DestSh. 'I use A:A to copy the whole column but you can also use a range like A1:A10 'Use A:C if you want to copy more columns. 'Change it here ''Fill in the column(s) that you want to copy 'Set CopyRng = sh.Range("A:A") 'Remember that Excel 97-2003 have only 256 columns. 'Excel 2007 has 16384 columns. 'When you run one of the examples it will first delete the summary worksheet 'named DBMergeSheet if it exists and then adds a new one to the workbook.'This ensures that the data is always up to date after you run the code. Sub AppendDataAfterLastColumn() Dim sh As Worksheet Dim DestSh As Worksheet Dim Last As Long Dim CopyRng As Range With Application .ScreenUpdating = False .EnableE...

If you want to convert any number to letter then you can use this micro. Its easy to implement just you create new micro and paste this code then in any cell you can call that function. Function ConvertToLetter(iCol As Integer) As String ' Dim iAlpha As Integer ' Dim iRemainder As Integer ' iAlpha = Int(iCol / 27) ' iRemainder = iCol - (iAlpha * 26) ' If iAlpha > 0 Then ' ConvertToLetter = Chr(iAlpha + 64) ' End If ' If iRemainder > 0 Then ' ConvertToLetter = ConvertToLetter & Chr(iRemainder + 64) ' End If Dim columnName As String Dim modulo As Integer While iCol > 0 modulo = (iCol - 1) Mod 26 columnName = Chr(65 + modulo) + columnName iCol = Int((iCol - modulo) / 26) Wend ConvertToLetter = columnName End Function

If you have two column data one is for Id and other is for name then you can get Id base on name data. You can paste this code in your excel micro editor and need to change variable as per your requirement. Sub orange(ByVal Target As Range) For i = 7 To LastRow("_RegistrationDetails_1-1") If Target.Address = ("$O$" & i) Then Dim rng As Range 'set Village ID range [P] Set rng = Worksheets("_RegistrationDetails_1-1").Range("$P$" & i) If Target(1, 1) = "" Then 'clear Village Id [P] rng(1, 1).Value = "" Else 'Village Id [P] Lookup from Taluka name [M] & Village name [O] rng(1, 1).Value = secondarySVlookup("_RegistrationDetails_1-1", "$M$" & i, "$O$" & i, "Village") End If i = LastRow("_RegistrationDetails_1-1") End If Next i End Sub

If you want to use switch case in Excel micro then you can see following example. Its mentioned clearly how to use switch  as per value of cell. Sub configs(ByVal Target As Range) Dim Indexof As Integer Dim strT As String Indexof = InStrRev(Target.Address, "$") strT = Mid(Target.Address, 1, Indexof) Select Case strT Case "$D$" Call drange(Target) 'drange --> generate Crop Id [D],Crop Variety DropDown [E] from Crop Name [C] Case "$E$" Call erange(Target) 'erange --> generate Crop Variety Id [F] from Crop Variety Name [E] Case "$K$" Call krange(Target) 'krange --> generate District Id [L] ,Taluka DropDown [M] from District Name [K] Case "$M$" Call mrange(Target) 'mrange --> generate Taluka Id [N], Village DropDown [O] from Taluka Name [M] Case "$O$" Call orange(Target) 'orange --> generate Village Id [P] from Village Name [O] End Select End...

Set parent child sheet distribution in excel If you want to set excel worksheet as per parent and child sheet then you can try this example. This is simple example to set parent child sheet distribution in excel. Sub Distribution(ByVal destflnm As String, ByVal srcflnm As String, ByVal ParentColumn As String, ByVal ChildColumn As String) 'Clear Destination Sheet Dim RgClear As Range Set RgClear = Worksheets(destflnm).Range("$A$1:$" & LastCol(destflnm) & "$" & LastRow(destflnm)) RgClear.Clear 'Set Parent Range Dim RgParent As Range Set RgParent = Worksheets(srcflnm).Range(ColumnRange(srcflnm, ParentColumn)) 'Set Child Range Dim RgChild As Range Set RgChild = Worksheets(srcflnm).Range(ColumnRange(srcflnm, ChildColumn)) 'Set Search Count Dim i As Integer i = RgParent.Count 'Set Column index for Destination Sheet Dim ci As Integer ci = 1 'Set row index for Destination Sheet ...

Macro code to check duplicate in excel column This is simple Macro code example to check duplicate in excel column. If you have very long list data in single column and have lot of duplicate or redundant data then its headache to find duplicate value. By using following code tricks you can find it easily in excel. Function LastRow(ByVal Filename As String) As Long Dim ix As Long ix = Worksheets(Filename).UsedRange.Row - 1 + Worksheets(Filename).UsedRange.Rows.Count ' ix = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.Count LastRow = ix End Function Function LastCol(ByVal Filename As String) As String Dim ix As Integer ix = Worksheets(Filename).UsedRange.Column - 1 + Worksheets(Filename).UsedRange.Columns.Count LastCol = ConvertToLetter(ix) End Function Function ConvertToLetter(iCol As Integer) As String ' Dim iAlpha As Integer ' Dim iRemainder As Integer ' iAlpha = Int(iCol / 27) ' iRemainder = iCol...

Excel 2007 Formulas Name Of BooK: Excel 2007 Formulas Author: John Walkenbach aka Mr. Spreadsheet Publisher: Wiley ISBN: 0470044020 Size: 804 pages, 44.3 Mb Format: CHM DOWNLOAD LINK http://www.blogger.com/goog_1660913896 http://w17.easy-share.com/1701026754.html

This is example of Stored Procedure to get Grand Total of columns using select query in sql. You can try for your database table too. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[CALC_TOTAL1] ( @NO CHAR(15), @AMTNUMERIC1(9,2)=NULL, @TAX NUMERIC1(9,2)=NULL, @DISCNUMERIC1(9,2)=NULL, @G_TOTAL NUMERIC1(9,2)=NULL ) AS SELECT @TOT_AMOUNT=SUM(AMOUNT) FROM TRANS WHERE TNO=@CNO SELECT @TAX=ISNULL(SUM(TAX_A),0) FROM TAX WHERE NO=@TCNO SELECT @TOT_DISC_A=ISNULL(SUM(DISC_A),0) FROM DISCOUNT WHERE NO=@CNO SET @G_TOTAL = (@AMT- @TOT_DISC_A) + @TAX UPDATE FOOT SET SUBTOTAL=@TOT_AMOUNT,TAX=@TAX,DISCOUNT=@TOT_DISC_A,G_TOTAL=@G_TOTAL WHERE CNO=@CNO

Visual basic dot Net Code to get DataSet This is example of Vb.Net Code to get DataSet and second example is how to use execute scalar to return single value like count record, sum of columns etc. Vb.Net Code to get DataSet Declare all variable globally. Public Function GetDataset(ByVal str As String, ByVal Table As String) As DataSet Dim cmd As New SqlCommand(str, objCn.OpenDB()) cmd.CommandType = CommandType.Text Try Dim ds As New DataSet Dim adp As New SqlDataAdapter(cmd) adp.Fill(ds, Table) Return ds Catch ex As Exception MsgBox("clsCommon::FetchData::Error occured.", MsgBoxStyle.Critical, "XyZ") Finally objCn.CloseDB() cmd.Dispose() End Try End Function 'Excecute Scalar: Public Function Exe_Scalar(ByVal str As String, ByVal table As String) As String Dim cd As String Dim cmd As New SqlCommand(str, objCn.OpenDB()) cmd.CommandType = CommandType.Text Try cd = cmd.ExecuteScalar() Return c...

Sometimes we require to write code to check whether table exist in database or not. This is simple Vb dot Net Code to check table exist or not in sql or any other database. Public Function CheckTempUserTbl(ByVal strSpNm As String) As String Dim cmd As SqlCommand Dim strCd As String cmd = New SqlCommand(strSpNm, objCn.OpenDB()) cmd.CommandType = CommandType.StoredProcedure Try cmd.Parameters.Add(New SqlParameter("@TBLNM", SqlDbType.VarChar, 30, ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Proposed, _Table)) If Not IsDBNull(cmd.ExecuteScalar()) Then strCd = cmd.ExecuteScalar() End If Return strCd Catch ex As Exception MsgBox("clsCommon::CreateTempUserTbl::Error occured.", MsgBoxStyle.Critical, "TEST") MsgBox(ex.Message.ToString) Finally objCn.CloseDB() cmd.Dispose() End Try End Function By this stored procedure you can pass any table name at runtime.

This is a simple example to learn how to create table in sql with different data types and columns. You can see also how to add foreign key in table in create syntax. create table Authors ( AuthorNumber number primary key, RefNumber varchar2(10), LastName varchar2(40), FirstName varchar2(40) null, Organization varchar2(50) null, city varchar2(50) null, State varchar2(30) null, Country varchar2(40) null, Address varchar2(200) null, email varchar2(50) null, Phone varchar2(50) null, Fax varchar2(50) null, foreign key(RefNumber) references papermst(RefNumber) );

Song: Hai mera dil film: Josh Legend for the notes: s = sa = C r1 = ri 1 = C# r2 = ri 2 = D g2 = ga 2 = D# g3 = ga 3 = E m1 = ma 1 = F m2 = ma 2 = F# p = pa = G d1 = da 1 = G# d2 = da 2 = A n2 = ni 2 = A# n3 = ni 3 = B S = sa = C [next octave; higher "sa"] R1 ... Notes: s Itna Pyaara Hai Yeh Pyaar, Pyaara Pyaara sss g2 g2 p g2 m1 g2 r2 g2r2s CCC D# D# G D# F D# D D#DC Hua Hai Pehli Baar, Hota Hai Ek Baar p S n2 d1 p d1 m1n2 d1 pm1 p G C+ A# G# G G# FA# G# GF G Phir Na Hoga....Yeh Dubaara... p m1 p S g2 r2g2r2s G F G C+ D# DD#DC Hai Mera Dil, Churake Le Gaya g2m1 p d1 p m2 p S p m1m1 D#F G G# G F# G C+ G FF Churane Wala, p p S pm1m1 pd1pm1 G G C+ GFF GG#GF Mera Katil... g2m1 g2r2s D#F D#DC Hai Mera Dil, Churake Le Gayi, g2m1 p d1 p m2 p S p m1m1 D#F G G# G F# G C+ G FF Churane Wali, p p S pm1m1 pd1pm1 G G C+ GFF GG#GF Meri Katil... g2m1 g2r2s D#F D#DC Yeh Dil Tujhpe Aaya Hai, Aate Aa...