nefrat
شنبه 13 فروردین 1390, 20:13 عصر
سلام...
دارم یه برنامه مینویسم که خیلی جزیی هست مال بیمارستانه...میخوام اگه میشه کمکم کنید...
از فرم بیمار شروع کنم : که کل برنامهایی که نوشتم اینه
Imports System.Data '' baraye ADO.Net
Imports System.Data.SqlClient '' SQLSERVER
Public Class Bimaran
Dim constr As String = " Data Source=.\SQLEXPRESS;AttachDbFilename=N:\Hospital\s hafagh.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
Dim con As New SqlConnection(constr)
Dim da As SqlDataAdapter
Dim ds As New DataSet
Private Sub Bimaran_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'ShafaghDataSet.Bimar' table. You can move, or remove it, as needed.
Me.BimarTableAdapter.Fill(Me.ShafaghDataSet.Bimar)
Try
con.Open()
Dim cmdstr As String = "select * from Bimar"
da = New SqlDataAdapter(cmdstr, con)
da.Fill(ds, "Paz_bakhsh")
Tfname.DataBindings.Add(New Binding("text", ds, "Bimar.Fname"))
Tlname.DataBindings.Add(New Binding("text", ds, "Bimar.LName"))
Tsex.DataBindings.Add(New Binding("text", ds, "Bimar.Sex"))
Tshsh.DataBindings.Add(New Binding("text", ds, "Bimar.SHSH"))
Tmeli.DataBindings.Add(New Binding("text", ds, "Bimar.Meli_code"))
Tadd1.DataBindings.Add(New Binding("text", ds, "Bimar.Add1"))
Tadd2.DataBindings.Add(New Binding("text", ds, "Bimar.Add2"))
Tmo.DataBindings.Add(New Binding("text", ds, "Bimar.B_Date_Mo"))
Tye.DataBindings.Add(New Binding("text", ds, "Bimar.B_Date_Ye"))
Tda.DataBindings.Add(New Binding("text", ds, "Bimar.B_Date_Da"))
Tbime.DataBindings.Add(New Binding("text", ds, "Bimar.Bime"))
Tcodbime.DataBindings.Add(New Binding("text", ds, "Bimar.Bbimecod"))
TFathername.DataBindings.Add(New Binding("text", ds, "Bimar.Father_name"))
Tphon.DataBindings.Add(New Binding("text", ds, "Bimar.Phone"))
Tmob.DataBindings.Add(New Binding("text", ds, "Bimar.Mobile"))
Tbakhshn.DataBindings.Add(New Binding("text", ds, "Bimar.bakhsh"))
Tdocnam.DataBindings.Add(New Binding("text", ds, "Bimar.Dr_name"))
Tsharh.DataBindings.Add(New Binding("text", ds, "Bimar.sharh"))
Tpazye.DataBindings.Add(New Binding("text", ds, "Bimar.paz_date_ye"))
Tpazmo.DataBindings.Add(New Binding("text", ds, "Bimar.paz_date_mo"))
Tpazda.DataBindings.Add(New Binding("text", ds, "Bimar.paz_date_da"))
TshshS.DataBindings.Add(New Binding("text", ds, "Bimar.shsh"))
Tsabeghe.DataBindings.Add(New Binding("text", ds, "Bimar.sabeghe"))
lblID.DataBindings.Add(New Binding("text", ds, "Bimar.ID"))
lblDB.Text = "بانک متصل است"
Catch ex As Exception
lblcon.Text = ex.Message
Finally
con.Close()
End Try
End Sub
Private Sub Button17_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmd.Click
Dim cmd As New SqlCommand("insert into Bimar(ID,FName,LName,Father_name,SHSH,Meli_code,B_ Date_Mo,B_Date_Ye,B_Date_Da,Sex,Add1,Add2,Phone,Mo bile,Bime,Bbimecod,Sabeghe,r_name,sharh,paz_date_y e,paz_date_mo,paz_date_da,bakhsh)Values(@ID,@FName ,@LName,@Father_name,@SHSH,@Meli_code,@B_Date_Mo,@ B_Date_Ye,@B_Date_Da,@Sex,@Add1,@Add2,@Phone,@Mobi le,@Bime,@Bbimecod,@Sabeghe,@Dr_name,@sharh,@paz_d ate_ye,@paz_date_mo,@paz_date_da,@bakhsh)", con)
Try
con.Open()
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = lblID.Text
cmd.Parameters.Add("@FName", SqlDbType.NVarChar).Value = Tfname.Text
cmd.Parameters.Add("@LName", SqlDbType.NVarChar).Value = Tlname.Text
cmd.Parameters.Add("@Father_name", SqlDbType.NVarChar).Value = TFathername.Text
cmd.Parameters.Add("@SHSH", SqlDbType.NVarChar).Value = Tshsh.Text
cmd.Parameters.Add("@SHSH", SqlDbType.NVarChar).Value = TshshS.Text
cmd.Parameters.Add("@Meli_code", SqlDbType.NVarChar).Value = Tmeli.Text
cmd.Parameters.Add("@B_Date_Mo", SqlDbType.Int).Value = Tmo.Text
cmd.Parameters.Add("@B_Date_Ye", SqlDbType.Int).Value = Tye.Text
cmd.Parameters.Add("@B_Date_Da", SqlDbType.Int).Value = Tda.Text
cmd.Parameters.Add("@Sex", SqlDbType.NChar).Value = Tsex.Text
cmd.Parameters.Add("@Add1", SqlDbType.NVarChar).Value = Tadd1.Text
cmd.Parameters.Add("@Add2", SqlDbType.NVarChar).Value = Tadd2.Text
cmd.Parameters.Add("@Phone", SqlDbType.Int).Value = Tphon.Text
cmd.Parameters.Add("@Mobile", SqlDbType.Int).Value = Tmob.Text
cmd.Parameters.Add("@Bime", SqlDbType.NVarChar).Value = Tbime.Text
cmd.Parameters.Add("@Bbimecod", SqlDbType.Int).Value = Tcodbime.Text
cmd.Parameters.Add("@Sabeghe", SqlDbType.NVarChar).Value = Tsabeghe.Text
cmd.Parameters.Add("@Dr_name", SqlDbType.NVarChar).Value = Tdocnam.Text
cmd.Parameters.Add("@sharh", SqlDbType.NVarChar).Value = Tsharh.Text
cmd.Parameters.Add("@paz_date_ye", SqlDbType.Int).Value = Tpazye.Text
cmd.Parameters.Add("@paz_date_mo", SqlDbType.Int).Value = Tpazmo.Text
cmd.Parameters.Add("@paz_date_da", SqlDbType.Int).Value = Tpazda.Text
cmd.Parameters.Add("@bakhsh", SqlDbType.NVarChar).Value = Tbakhshn.Text
cmd.ExecuteNonQuery()
ds.Clear()
da.Fill(ds, "Bimar")
da.Update(ds, "Bimar")
lblDB.Text = "بانک متصل است"
Catch ex As Exception
lblcon.Text = ex.Message
Finally
con.Close()
End Try
End Sub
End ClassEnd Class
اما وقتی show میکنم به جای اتصال برقراره ( بانک وصله) میگه :
child list for field Bimar cannot be created
میشه بگید چی کار کنم ؟
و وقتی که دکمه ثبت و میزنم میگه :
failed to convert parameter value from a string to a int 32
دارم یه برنامه مینویسم که خیلی جزیی هست مال بیمارستانه...میخوام اگه میشه کمکم کنید...
از فرم بیمار شروع کنم : که کل برنامهایی که نوشتم اینه
Imports System.Data '' baraye ADO.Net
Imports System.Data.SqlClient '' SQLSERVER
Public Class Bimaran
Dim constr As String = " Data Source=.\SQLEXPRESS;AttachDbFilename=N:\Hospital\s hafagh.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
Dim con As New SqlConnection(constr)
Dim da As SqlDataAdapter
Dim ds As New DataSet
Private Sub Bimaran_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'ShafaghDataSet.Bimar' table. You can move, or remove it, as needed.
Me.BimarTableAdapter.Fill(Me.ShafaghDataSet.Bimar)
Try
con.Open()
Dim cmdstr As String = "select * from Bimar"
da = New SqlDataAdapter(cmdstr, con)
da.Fill(ds, "Paz_bakhsh")
Tfname.DataBindings.Add(New Binding("text", ds, "Bimar.Fname"))
Tlname.DataBindings.Add(New Binding("text", ds, "Bimar.LName"))
Tsex.DataBindings.Add(New Binding("text", ds, "Bimar.Sex"))
Tshsh.DataBindings.Add(New Binding("text", ds, "Bimar.SHSH"))
Tmeli.DataBindings.Add(New Binding("text", ds, "Bimar.Meli_code"))
Tadd1.DataBindings.Add(New Binding("text", ds, "Bimar.Add1"))
Tadd2.DataBindings.Add(New Binding("text", ds, "Bimar.Add2"))
Tmo.DataBindings.Add(New Binding("text", ds, "Bimar.B_Date_Mo"))
Tye.DataBindings.Add(New Binding("text", ds, "Bimar.B_Date_Ye"))
Tda.DataBindings.Add(New Binding("text", ds, "Bimar.B_Date_Da"))
Tbime.DataBindings.Add(New Binding("text", ds, "Bimar.Bime"))
Tcodbime.DataBindings.Add(New Binding("text", ds, "Bimar.Bbimecod"))
TFathername.DataBindings.Add(New Binding("text", ds, "Bimar.Father_name"))
Tphon.DataBindings.Add(New Binding("text", ds, "Bimar.Phone"))
Tmob.DataBindings.Add(New Binding("text", ds, "Bimar.Mobile"))
Tbakhshn.DataBindings.Add(New Binding("text", ds, "Bimar.bakhsh"))
Tdocnam.DataBindings.Add(New Binding("text", ds, "Bimar.Dr_name"))
Tsharh.DataBindings.Add(New Binding("text", ds, "Bimar.sharh"))
Tpazye.DataBindings.Add(New Binding("text", ds, "Bimar.paz_date_ye"))
Tpazmo.DataBindings.Add(New Binding("text", ds, "Bimar.paz_date_mo"))
Tpazda.DataBindings.Add(New Binding("text", ds, "Bimar.paz_date_da"))
TshshS.DataBindings.Add(New Binding("text", ds, "Bimar.shsh"))
Tsabeghe.DataBindings.Add(New Binding("text", ds, "Bimar.sabeghe"))
lblID.DataBindings.Add(New Binding("text", ds, "Bimar.ID"))
lblDB.Text = "بانک متصل است"
Catch ex As Exception
lblcon.Text = ex.Message
Finally
con.Close()
End Try
End Sub
Private Sub Button17_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmd.Click
Dim cmd As New SqlCommand("insert into Bimar(ID,FName,LName,Father_name,SHSH,Meli_code,B_ Date_Mo,B_Date_Ye,B_Date_Da,Sex,Add1,Add2,Phone,Mo bile,Bime,Bbimecod,Sabeghe,r_name,sharh,paz_date_y e,paz_date_mo,paz_date_da,bakhsh)Values(@ID,@FName ,@LName,@Father_name,@SHSH,@Meli_code,@B_Date_Mo,@ B_Date_Ye,@B_Date_Da,@Sex,@Add1,@Add2,@Phone,@Mobi le,@Bime,@Bbimecod,@Sabeghe,@Dr_name,@sharh,@paz_d ate_ye,@paz_date_mo,@paz_date_da,@bakhsh)", con)
Try
con.Open()
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = lblID.Text
cmd.Parameters.Add("@FName", SqlDbType.NVarChar).Value = Tfname.Text
cmd.Parameters.Add("@LName", SqlDbType.NVarChar).Value = Tlname.Text
cmd.Parameters.Add("@Father_name", SqlDbType.NVarChar).Value = TFathername.Text
cmd.Parameters.Add("@SHSH", SqlDbType.NVarChar).Value = Tshsh.Text
cmd.Parameters.Add("@SHSH", SqlDbType.NVarChar).Value = TshshS.Text
cmd.Parameters.Add("@Meli_code", SqlDbType.NVarChar).Value = Tmeli.Text
cmd.Parameters.Add("@B_Date_Mo", SqlDbType.Int).Value = Tmo.Text
cmd.Parameters.Add("@B_Date_Ye", SqlDbType.Int).Value = Tye.Text
cmd.Parameters.Add("@B_Date_Da", SqlDbType.Int).Value = Tda.Text
cmd.Parameters.Add("@Sex", SqlDbType.NChar).Value = Tsex.Text
cmd.Parameters.Add("@Add1", SqlDbType.NVarChar).Value = Tadd1.Text
cmd.Parameters.Add("@Add2", SqlDbType.NVarChar).Value = Tadd2.Text
cmd.Parameters.Add("@Phone", SqlDbType.Int).Value = Tphon.Text
cmd.Parameters.Add("@Mobile", SqlDbType.Int).Value = Tmob.Text
cmd.Parameters.Add("@Bime", SqlDbType.NVarChar).Value = Tbime.Text
cmd.Parameters.Add("@Bbimecod", SqlDbType.Int).Value = Tcodbime.Text
cmd.Parameters.Add("@Sabeghe", SqlDbType.NVarChar).Value = Tsabeghe.Text
cmd.Parameters.Add("@Dr_name", SqlDbType.NVarChar).Value = Tdocnam.Text
cmd.Parameters.Add("@sharh", SqlDbType.NVarChar).Value = Tsharh.Text
cmd.Parameters.Add("@paz_date_ye", SqlDbType.Int).Value = Tpazye.Text
cmd.Parameters.Add("@paz_date_mo", SqlDbType.Int).Value = Tpazmo.Text
cmd.Parameters.Add("@paz_date_da", SqlDbType.Int).Value = Tpazda.Text
cmd.Parameters.Add("@bakhsh", SqlDbType.NVarChar).Value = Tbakhshn.Text
cmd.ExecuteNonQuery()
ds.Clear()
da.Fill(ds, "Bimar")
da.Update(ds, "Bimar")
lblDB.Text = "بانک متصل است"
Catch ex As Exception
lblcon.Text = ex.Message
Finally
con.Close()
End Try
End Sub
End ClassEnd Class
اما وقتی show میکنم به جای اتصال برقراره ( بانک وصله) میگه :
child list for field Bimar cannot be created
میشه بگید چی کار کنم ؟
و وقتی که دکمه ثبت و میزنم میگه :
failed to convert parameter value from a string to a int 32