teymoorei
دوشنبه 22 فروردین 1390, 13:31 عصر
سلام دوستای گل یکی به من بگه این کد چه مشکلی داره ؟
عجله دارم
Connection.Open()
da = New SqlDataAdapter("select * from EtelaatedDoreh3", Connection)
ds = New DataSet()
da.Fill(ds, "EtelaatedDoreh3")
Dim dr As DataRow
dr = ds.Tables("EtelaatedDoreh3").NewRow()
dr("coddor") = TextBox1.Text 'dr[1]=""
dr("timst") = TextBox2.Text 'dr[2]=""
dr("timed") = TextBox3.Text 'dr[1]=""
dr("timdte") = MaskedTextBox1.Text 'dr[2]=""
dr("eddor") = MaskedTextBox2.Text 'dr[1]=""
dr("sex") = CmbSex.Text 'dr[2]=""
dr("shift") = cmbShift.Text 'dr[1]=""
dr("staname") = TextBox4.Text 'dr[2]=""
dr("timtor") = TextBox7.Text 'dr[1]=""
dr("timaml") = TextBox8.Text 'dr[2]=""
dr("codstaamz") = TextBox9.Text 'dr[1]=""
dr("timtot") = TextBox10.Text 'dr[2]=""
dr("sly") = Masked1.Text 'dr[1]=""
dr("tchrname") = TextBox5.Text 'dr[2]=""
dr("tchrfamily") = TextBox11.Text 'dr[1]=""
dr("numcrdtche") = TextBox13.Text 'dr[2]=""
TextBox4.Visible = True
TextBox5.Visible = True
fill()
If TextBox5.Text <> "" And TextBox2.Text <> "" Then
TextBox10.Text = TextBox7.Text.ToString + TextBox8.ToString
End If
ds.Tables("EtelaatedDoreh3").Rows.Add(dr) 'ds.Tables["table1"].Rows.Add(dr)
Dim cb As New SqlCommandBuilder(da)
da = cb.DataAdapter
da.Update(ds, "EtelaatedDoreh3")
ds.Clear()
da.Fill(ds, "EtelaatedDoreh3")
DataGridView1.DataSource = ds.Tables("EtelaatedDoreh3")
Command.ExecuteNonQuery()
'Connection.Close()
عجله دارم
Connection.Open()
da = New SqlDataAdapter("select * from EtelaatedDoreh3", Connection)
ds = New DataSet()
da.Fill(ds, "EtelaatedDoreh3")
Dim dr As DataRow
dr = ds.Tables("EtelaatedDoreh3").NewRow()
dr("coddor") = TextBox1.Text 'dr[1]=""
dr("timst") = TextBox2.Text 'dr[2]=""
dr("timed") = TextBox3.Text 'dr[1]=""
dr("timdte") = MaskedTextBox1.Text 'dr[2]=""
dr("eddor") = MaskedTextBox2.Text 'dr[1]=""
dr("sex") = CmbSex.Text 'dr[2]=""
dr("shift") = cmbShift.Text 'dr[1]=""
dr("staname") = TextBox4.Text 'dr[2]=""
dr("timtor") = TextBox7.Text 'dr[1]=""
dr("timaml") = TextBox8.Text 'dr[2]=""
dr("codstaamz") = TextBox9.Text 'dr[1]=""
dr("timtot") = TextBox10.Text 'dr[2]=""
dr("sly") = Masked1.Text 'dr[1]=""
dr("tchrname") = TextBox5.Text 'dr[2]=""
dr("tchrfamily") = TextBox11.Text 'dr[1]=""
dr("numcrdtche") = TextBox13.Text 'dr[2]=""
TextBox4.Visible = True
TextBox5.Visible = True
fill()
If TextBox5.Text <> "" And TextBox2.Text <> "" Then
TextBox10.Text = TextBox7.Text.ToString + TextBox8.ToString
End If
ds.Tables("EtelaatedDoreh3").Rows.Add(dr) 'ds.Tables["table1"].Rows.Add(dr)
Dim cb As New SqlCommandBuilder(da)
da = cb.DataAdapter
da.Update(ds, "EtelaatedDoreh3")
ds.Clear()
da.Fill(ds, "EtelaatedDoreh3")
DataGridView1.DataSource = ds.Tables("EtelaatedDoreh3")
Command.ExecuteNonQuery()
'Connection.Close()