reena12

Hi, try this ds1.Merge(ds2); dataGridView1.DataSource = ds1.Tables[0]; dataGridView1.DataBind();

Hi, imports System.Data.OleDb Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DATABASE PATH") con.Open() If solved please mark as solved

Hi, Private Sub frmDesigner_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Me.KeyPress If Asc(e.KeyChar) = Keys.Enter Then SendKeys.Send("{TAB}") End If End Sub

''' <summary> ''' FUNCTION TO CALCULATE SUM OF TWO TIME VALUES ''' PASS TWO DATE VALUES AS STRING ''' </summary> Function GetTimeSum(ByVal dt1 As String, ByVal dt2 As String) As String Dim ReturnStr As String = "" If dt1 = "" And dt2 <> "" Then Return dt2 ElseIf dt1 …

hi, fetch your leave start date and end date startdate = stdt enddate = nddt if currentdate >= stdt AND currentdate <= nddt { msgbox (".....") }

Hi, [B]dataGrid.DataBind()[/B] statement is missing. dataGrid = new DataGridView(); this.Controls.Add(dataGrid); dataGrid.DataSource = dataSet.Tables["Vertexes"]; [B] dataGrid.DataBind();[/B]

hi you can do this using TreeView

Hi, [B]oConn.open() [/B] statement is missing (Data Source=NAWINSQL050;Initial Catalog=AlbatrossDB; Integrated Security=true) [B]oConn.open()[/B] objFormatOut = FormatDepartment.Format.FormatSelectById(m_intOutputFormat, oConn) If m_intOutputFormat = 218 Then oDS = oDataAccess.ExecuteDataset(oConn, "Stored Procedure", m_intProcYear, m_shtProcMonth, m_strSupplierId, m_strDistId, m_strDestinationCd) Else oDS = oDataAccess.ExecuteDataset(oConn, "Stored procedure", m_lngSourceOutputId, m_strSupplierId, m_strDistId, m_strDestinationCd) End If

Dim con as new OledbConnection con = new OledbConnection (constring) con.open() Dim cmd as new OledbCommand cmd = new OledbCommand("Delete Query") cmd.ExecuteNonQuery() cmd.Dispose() con.close()

Hi, Dim con as new Oledbconnection con = new Oledbconnection(constring) con.open() Dim cmd1 as new OledbCommand cmd1 = new OledbCommand("Insert Query",con) cmd1.executenonquery() cmd1 = new OledbCommand("Update Query 1",con) cmd1.executenonquery() cmd1 = new OledbCommand("Update Query 2",con) cmd1.executenonquery() con.close()

Hi, dim con as new DqlConnection con = new Sqlconnection(constr) con.open() dim objSqlCommand as new SqlCommand dim objdr as SqlDataReader objSqlCommand = new SqlCommand ("YOUR QUERY") objdr = objSqlCommand.ExecuteReader() while objdr.Read() combobox1.Items.add(objdr(0)) end while

Hi, I want to Convert 1. HTML file into PDF file and 2. PDF file into HTML file through code in vb.net or c#.net without using third party component

Hi, private void button1_Click(object sender, EventArgs e) { txt1 = textBox1.Text; txt2 = textBox2.Text; String connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Userinfo.accdb"; OleDbConnection connection = new OleDbConnection(connectionString); connection.Open(); OleDbCommand command = new OleDbCommand("INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)"; command.ExecuteNonQuery(); connection.Close(); }

Hi, open Project -> "Project name" Properties open application tab from left select form name from startup form dropdown list

hi, I think messagebox will not work in ASP.NET. you can solve it through JAVA SCRIPT

Try Dim ObjSqlDataAdapter As SqlDataAdapter Dim ObjDataSet As New DataSet ObjSqlConnection = New SqlConnection(ConnectionString) If ObjSqlConnection.State <> ConnectionState.Open Then ObjSqlConnection.Open() End If ObjSqlDataAdapter = New SqlDataAdapter(CommandText, ObjSqlConnection) ObjDataSet = New DataSet() ObjSqlDataAdapter.Fill(ObjDataSet) Gridview1.DataSource = ObjDataSet.Tables(0) Catch ex As Exception Throw New Exception(ex.Message) Finally ObjSqlConnection.Close() ObjSqlConnection.Dispose() End Try if solved pls …

Hi SqlConnection ObjConn = new SqlConnection(ConnectionString); if (ObjConn.State != ConnectionState.Open) { ObjConn.Open(); } SqlDataAdapter ObjSqlDataAdapter = new SqlDataAdapter(CommandText, ObjConn); Ds = new DataSet(); ObjSqlDataAdapter.Fill(Ds); if (ObjDs.Tables[0].Rows.Count > 0) { label1.Text = ObjDs.Tables[0].Rows[rowindex][columnname].toString(); - - } ObjDs.Dispose(); ObjConn.Close(); ObjConn.Dispose();

Hi, CrystalReportViewer1.ReportSource = Nothing If ur problem solved ,pls marked Solved

Hi, try this Dim conn As OleDbConnection Try conn = New OleDbConnection(My.Settings.ConnectionString) conn.Open() Dim asql As String = "Select * From IDM_IDEA_DATA Where TEAM_NAME='" & cboTeam.Text.Trim & "' Order By DATE_SUBMITTED Desc" ' AND IDEA_ID='" & cboID.Text & "'" Dim i As Integer = 0 Dim cmd As New OleDbCommand(asql, …

using System; using System.Data; using System.Data.SqlClient; string sConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost;"; SqlConnection objConn = new SqlConnection(sConnectionString); objConn.Open(); string sSQL = "INSERT INTO Users (uname,upwd) VALUES ('" + textbox1.Text + "','" + textbox2.Text + "')"; SqlCommand objCmd = new SqlCommand(sSQL,objConn); objCmd.ExecuteNonQuery();

using System; using System.Data; using System.Data.SqlClient; string sConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost;"; SqlConnection objConn = new SqlConnection(sConnectionString); objConn.Open(); string sSQL = "SELECT MAX tableid FROM tablename"; SqlCommand objCmd = new SqlCommand(sSQL,objConn); SqlDatareader objDr; objDr = objCmd.ExecuteReader(); objDr.read(); int nextid = objDr[0]; if (nextid == 0) { nextid = 1; …