Making the two function either it is user define e.g private sub button1_click(byval sender as system.objects , byval e as system.eventargs)handles button1.click and Change the Name Of Second Function and replace the Handeler name Button2 Please try it

cn.Open() cmd.Connection = cn cmd.CommandText = "select max(EMP_CODE)+1 as last from EMP_DETAILS where PLACE='" & ComboBox1.Text & "'" dr=cmd.executeREADER While dr.Read TextBox1.Text = dr.Item("last") End While cn.Close() Now Check it

Please Check It cboKeyWord.Items.Add( new ListItem("<-Select KeyWord>-", "0"));

Dear Used Minimum,Temporary table, Minmum Joins, It will be optimize ur query

Hi You can used the Threading and Give the interval

I think when u change the Tab Button then u Fill the The Combo with DataBase, So u lost urs Current Status/View State

in First line U Call the this.items.clear()

Dim ds As DataSet = New DataSet ds.ReadXml("FileName Here") Dim btn As New DataGridViewButtonColumn btn.Text = "Add New" DataGridView1.column.add(btn) BEST LUCK

I Think Ur Code is Correct if u have any confusion then please review this Code thanks Dim cn As New SqlClient.SqlConnection cn.ConnectionString = "Data Source=ssi-SIQBAL;Initial Catalog=Dummy;integrated Security=SSPI" cn.Open() Dim cmd As New SqlClient.SqlCommand Dim str As String str = "ALTER TABLE TBL1 ADD HOME varchar(500)" cmd.Connection = cn cmd.CommandText = str cmd.ExecuteNonQuery()

No difference. in first case u give the exact refernce when u dont import ADODB namespace/Class in other case u import the ADODB and now used recordset

RichTextBox1.Lines.Length

Hi i m software engineer. Microsoft Technologies like Asp.net,Vb.net,c#,Sql server 2005, now a days i m working on Microsoft Notification services. i want a good friend for discussion and friend ship Thanks

Dear i it is not necassry to CAST the value if u have int type Value. Query gives the result. if u send me Table structure thean i will solve you clearliry. Thanks and Have a Nice day

Dear Just Convert the Value Into string in Presentation or coding. and if you used a stored procedure then parameter data type set is nvarchar. then it is working

Enter the IP Address where u Write the Server name. and give the some information .

Dear Used The Stored Procedure or View For Multiple Tables Data In One RecordSet

Dear Used Thsi Event of Tree View Control private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { textBox1.Text = e.Node.Text; }

Dear it is very simple when you used the Wizard. if you add the combobox Then Used follwing Code DataGridViewComboBoxColumn dgCombo = new DataGridViewComboBoxColumn(); dgCombo.DataSource = ""; dgCombo.DisplayMember=""; dgCombo.ValueMember = ""; dataGridView1.Columns.Add(dgCombo);