How can we pass sqlcommand object to sql dataadapter

Question

hi frnds i want to know can we pass sqlcommand object to sql dataadapter. please let me know Thanks aamir

sujit bista · Answer

Imports System.Data.SqlClient Public Class Form1 'Dim sq As SqlCommandBuilder Dim adp As SqlDataAdapter Function RetDataTable() As DataTable Dim dt As New DataTable Dim _Connection As New SqlConnection(Server=mac-dols;UID=sa;PWD=macdols12;Database=db1) Dim com As New SqlCommand() com.CommandType = CommandType.StoredProcedure com.CommandText = procname com.Connection = _Connection com.Parameters.AddWithValue(@count 2) adp = New SqlDataAdapter(com) ' sq = New SqlCommandBuilder(adp) adp.Fill(dt) Return dt End Function Private Sub Form1_Load(ByVal sender As System.Object ByVal e As System.EventArgs) Handles MyBase.Load DataGridView1.DataSource = RetDataTable() End Sub End Class

Satyapriya Nayak · Answer

Hi Aamir using System.Data; using System.Data.SqlClient; SqlConnection con=new SqlConnection(server=localhost;uid=sa;pwd=;database=std); SqlCommand com; SqlDataAdapter sqlda; DataSet ds; private void btnload_Click(object sender System.EventArgs e) { con.Open(); str=select * from student; com=new SqlCommand(strcon); sqlda=new SqlDataAdapter(com); ds=new DataSet(); sqlda.Fill(dsstudent); dataGrid1.DataSource=ds; dataGrid1.DataMember=(student); con.Close(); } Thanks

Pravin More · Answer

Hi aamir do it like this.......... SqlConnection con1 = new SqlConnection(Data Source=xxxx;Initial Catalog=xxxx;Persist Security Info=True;User ID=xxxxx;Password=*****); SqlCommand cmd1 = new SqlCommand(Select * from TableName con1); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); DataSet ds1 = new DataSet(); da1.Fill(ds1); ThanxHope this solve your problem. Pravin.