473,796 Members | 2,628 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Record insert

5 New Member
urgent!!!!!!! kindly please anyone help me.......
actualy i am newbe to vb.net

i need data to be inserted in to my table like this...

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
tamiz palace 12/1/2007 Mason 5 900

instead my following code produces result like this..

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
12/1/2007

only updating value of last row added.i don't know y data from first set of controls are not added?????????
_______________ _______________ _______________ ______

Private Sub Badd_Click(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles Badd.Click

If ind <> 35 Then
If temp >= 30 Then
Me.Panel2.Heigh t = Me.Panel1.Heigh t + 30
End If
Select Case ind
Case 0
Dim xy As DataRow = dtbsdtab.NewRow
dtbsdtab.Rows.A dd(xy)

cbxcontrol1 = CType(CreateCon trols.MakeContr ol("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
TextControl1 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
TextControl2 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
TextControl3 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
TextControl4 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
DTPcontrol1 = CType(CreateCon trols.MakeContr ol("DateTimePic ker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Val ue), "DTP1" & ind), DateTimePicker)

cbxcontrol1.Fon t = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl1.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl2.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl3.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))

DTPcontrol1.For mat = DateTimePickerF ormat.Custom
DTPcontrol1.Cus tomFormat = "dd/MM/yyyy"

Me.Panel2.Contr ols.Add(cbxcont rol1)
Me.Panel2.Contr ols.Add(TextCon trol1)
Me.Panel2.Contr ols.Add(TextCon trol2)
Me.Panel2.Contr ols.Add(TextCon trol3)
Me.Panel2.Contr ols.Add(TextCon trol4)
Me.Panel2.Contr ols.Add(DTPcont rol1)

DTPcontrol1.Val ue = DateValue(CStr( DTPdop.Value))
TextControl4.Te xt = CBxsite.Selecte dItem.ToString

dtbsdtab.Column s("cdate").Defa ultValue = Date.Today
cbxcontrol1.Dat aBindings.Add(N ew System.Windows. Forms.Binding(" Text", dtbsdtab, "wrknm", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl2.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "nowrk", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl3.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "totwg", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl4.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "sitenm", True, DataSourceUpdat eMode.OnPropert yChanged))
DTPcontrol1.Dat aBindings.Add(N ew System.Windows. Forms.Binding(" value", dtbsdtab, "cdate", True, DataSourceUpdat eMode.OnPropert yChanged))



cbxcontrol1.Tab Index = tabi
tabi += 1
TextControl1.Ta bIndex = tabi
tabi += 1
TextControl2.Ta bIndex = tabi
tabi += 1
TextControl3.Ta bIndex = tabi
tabi += 1

Badd.TabIndex = tabi
tabi += 1
Bsub.TabIndex = tabi
tabi += 1
Bsave.TabIndex = tabi
tabi += 1
Bexit.TabIndex = tabi
tabi += 1

AddHandler cbxcontrol1.Got Focus, AddressOf cbxcon_created
AddHandler cbxcontrol1.Sel ectedValueChang ed, AddressOf cbxcon_Selindch
AddHandler TextControl2.Lo stFocus, AddressOf txtbox_lostfocu ss
AddHandler TextControl2.Te xtChanged, AddressOf txtbox_lostfocu ss
AddHandler TextControl1.Te xtChanged, AddressOf txtbox_lostfocu ss

ind = ind + 1
indi = ind
temp += 30
temp1 += 1


Case 1

Dim xyz As DataRow = dtbsdtab.NewRow
dtbsdtab.Rows.A dd(xyz)

cbxcontrol12 = CType(CreateCon trols.MakeContr ol("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
TextControl12 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
TextControl22 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
TextControl32 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
TextControl42 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
DTPcontrol12 = CType(CreateCon trols.MakeContr ol("DateTimePic ker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Val ue), "DTP1" & ind), DateTimePicker)

cbxcontrol12.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl12.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl22.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl32.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))

DTPcontrol12.Fo rmat = DateTimePickerF ormat.Custom
DTPcontrol12.Cu stomFormat = "dd/MM/yyyy"

Me.Panel2.Contr ols.Add(cbxcont rol12)
Me.Panel2.Contr ols.Add(TextCon trol12)
Me.Panel2.Contr ols.Add(TextCon trol22)
Me.Panel2.Contr ols.Add(TextCon trol32)
Me.Panel2.Contr ols.Add(TextCon trol42)
Me.Panel2.Contr ols.Add(DTPcont rol12)

dtbsdtab.Column s("cdate").Defa ultValue = Date.Today
cbxcontrol12.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "wrknm", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl22.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "nowrk", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl32.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "totwg", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl42.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "sitenm", True, DataSourceUpdat eMode.OnPropert yChanged))
DTPcontrol12.Da taBindings.Add( New System.Windows. Forms.Binding(" value", dtbsdtab, "cdate", True, DataSourceUpdat eMode.OnPropert yChanged))

DTPcontrol12.Va lue = DateValue(CStr( DTPdop.Value))
TextControl42.T ext = CBxsite.Selecte dItem.ToString

cbxcontrol12.Ta bIndex = tabi
tabi += 1
TextControl12.T abIndex = tabi
tabi += 1
TextControl22.T abIndex = tabi
tabi += 1
TextControl32.T abIndex = tabi
tabi += 1

Badd.TabIndex = tabi
tabi += 1
Bsub.TabIndex = tabi
tabi += 1
Bsave.TabIndex = tabi
tabi += 1
Bexit.TabIndex = tabi
tabi += 1

AddHandler cbxcontrol12.Go tFocus, AddressOf cbxcon_created
AddHandler cbxcontrol12.Se lectedValueChan ged, AddressOf cbxcon_Selindch
AddHandler TextControl22.L ostFocus, AddressOf txtbox_lostfocu ss
AddHandler TextControl22.T extChanged, AddressOf txtbox_lostfocu ss
AddHandler TextControl12.T extChanged, AddressOf txtbox_lostfocu ss

ind = ind + 1
indi = ind
temp += 30
temp1 += 1


End Select

Else
MessageBox.Show ("Reached maximum limit")
End If



End Sub
Dec 1 '07 #1
5 1607
raajakumars
5 New Member
urgent!!!!!!! kindly please anyone help me.......
actualy i am newbe to vb.net

i need to produce result like this.....

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
tamiz palace 12/1/2007 Mason 5 900



instead my following code produces o/p like this..

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
12/1/2007

only updating value of last row added.i don't know y data from first set of controls are not added?????????



Private Sub Badd_Click(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles Badd.Click

If ind <> 35 Then
If temp >= 30 Then
Me.Panel2.Heigh t = Me.Panel1.Heigh t + 30
End If
Select Case ind
Case 0
Dim xy As DataRow = dtbsdtab.NewRow
dtbsdtab.Rows.A dd(xy)

cbxcontrol1 = CType(CreateCon trols.MakeContr ol("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
TextControl1 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
TextControl2 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
TextControl3 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
TextControl4 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
DTPcontrol1 = CType(CreateCon trols.MakeContr ol("DateTimePic ker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Val ue), "DTP1" & ind), DateTimePicker)

cbxcontrol1.Fon t = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl1.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl2.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl3.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))

DTPcontrol1.For mat = DateTimePickerF ormat.Custom
DTPcontrol1.Cus tomFormat = "dd/MM/yyyy"

Me.Panel2.Contr ols.Add(cbxcont rol1)
Me.Panel2.Contr ols.Add(TextCon trol1)
Me.Panel2.Contr ols.Add(TextCon trol2)
Me.Panel2.Contr ols.Add(TextCon trol3)
Me.Panel2.Contr ols.Add(TextCon trol4)
Me.Panel2.Contr ols.Add(DTPcont rol1)

DTPcontrol1.Val ue = DateValue(CStr( DTPdop.Value))
TextControl4.Te xt = CBxsite.Selecte dItem.ToString

dtbsdtab.Column s("cdate").Defa ultValue = Date.Today
cbxcontrol1.Dat aBindings.Add(N ew System.Windows. Forms.Binding(" Text", dtbsdtab, "wrknm", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl2.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "nowrk", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl3.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "totwg", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl4.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "sitenm", True, DataSourceUpdat eMode.OnPropert yChanged))
DTPcontrol1.Dat aBindings.Add(N ew System.Windows. Forms.Binding(" value", dtbsdtab, "cdate", True, DataSourceUpdat eMode.OnPropert yChanged))



cbxcontrol1.Tab Index = tabi
tabi += 1
TextControl1.Ta bIndex = tabi
tabi += 1
TextControl2.Ta bIndex = tabi
tabi += 1
TextControl3.Ta bIndex = tabi
tabi += 1

Badd.TabIndex = tabi
tabi += 1
Bsub.TabIndex = tabi
tabi += 1
Bsave.TabIndex = tabi
tabi += 1
Bexit.TabIndex = tabi
tabi += 1

AddHandler cbxcontrol1.Got Focus, AddressOf cbxcon_created
AddHandler cbxcontrol1.Sel ectedValueChang ed, AddressOf cbxcon_Selindch
AddHandler TextControl2.Lo stFocus, AddressOf txtbox_lostfocu ss
AddHandler TextControl2.Te xtChanged, AddressOf txtbox_lostfocu ss
AddHandler TextControl1.Te xtChanged, AddressOf txtbox_lostfocu ss

ind = ind + 1
indi = ind
temp += 30
temp1 += 1


Case 1

Dim xyz As DataRow = dtbsdtab.NewRow
dtbsdtab.Rows.A dd(xyz)

cbxcontrol12 = CType(CreateCon trols.MakeContr ol("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
TextControl12 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
TextControl22 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
TextControl32 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
TextControl42 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
DTPcontrol12 = CType(CreateCon trols.MakeContr ol("DateTimePic ker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Val ue), "DTP1" & ind), DateTimePicker)

cbxcontrol12.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl12.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl22.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl32.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))

DTPcontrol12.Fo rmat = DateTimePickerF ormat.Custom
DTPcontrol12.Cu stomFormat = "dd/MM/yyyy"

Me.Panel2.Contr ols.Add(cbxcont rol12)
Me.Panel2.Contr ols.Add(TextCon trol12)
Me.Panel2.Contr ols.Add(TextCon trol22)
Me.Panel2.Contr ols.Add(TextCon trol32)
Me.Panel2.Contr ols.Add(TextCon trol42)
Me.Panel2.Contr ols.Add(DTPcont rol12)

dtbsdtab.Column s("cdate").Defa ultValue = Date.Today
cbxcontrol12.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "wrknm", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl22.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "nowrk", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl32.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "totwg", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl42.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "sitenm", True, DataSourceUpdat eMode.OnPropert yChanged))
DTPcontrol12.Da taBindings.Add( New System.Windows. Forms.Binding(" value", dtbsdtab, "cdate", True, DataSourceUpdat eMode.OnPropert yChanged))

DTPcontrol12.Va lue = DateValue(CStr( DTPdop.Value))
TextControl42.T ext = CBxsite.Selecte dItem.ToString

cbxcontrol12.Ta bIndex = tabi
tabi += 1
TextControl12.T abIndex = tabi
tabi += 1
TextControl22.T abIndex = tabi
tabi += 1
TextControl32.T abIndex = tabi
tabi += 1

Badd.TabIndex = tabi
tabi += 1
Bsub.TabIndex = tabi
tabi += 1
Bsave.TabIndex = tabi
tabi += 1
Bexit.TabIndex = tabi
tabi += 1

AddHandler cbxcontrol12.Go tFocus, AddressOf cbxcon_created
AddHandler cbxcontrol12.Se lectedValueChan ged, AddressOf cbxcon_Selindch
AddHandler TextControl22.L ostFocus, AddressOf txtbox_lostfocu ss
AddHandler TextControl22.T extChanged, AddressOf txtbox_lostfocu ss
AddHandler TextControl12.T extChanged, AddressOf txtbox_lostfocu ss

ind = ind + 1
indi = ind
temp += 30
temp1 += 1


End Select

Else
MessageBox.Show ("Reached maximum limit")
End If



End Sub
Dec 1 '07 #2
raajakumars
5 New Member
urgent!!!!!!! kindly please anyone help me.......
actualy i am newbe to vb.net

i need to produce result like this.....

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
tamiz palace 12/1/2007 Mason 5 900



instead my following code producing o/p like this..

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
12/1/2007

only updating value of last row added.i don't know y data from first set of controls are not added?????????



Private Sub Badd_Click(ByVa l sender As System.Object, ByVal e As System.EventArg s) Handles Badd.Click

If ind <> 35 Then
If temp >= 30 Then
Me.Panel2.Heigh t = Me.Panel1.Heigh t + 30
End If
Select Case ind
Case 0
Dim xy As DataRow = dtbsdtab.NewRow
dtbsdtab.Rows.A dd(xy)

cbxcontrol1 = CType(CreateCon trols.MakeContr ol("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
TextControl1 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
TextControl2 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
TextControl3 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
TextControl4 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
DTPcontrol1 = CType(CreateCon trols.MakeContr ol("DateTimePic ker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Val ue), "DTP1" & ind), DateTimePicker)

cbxcontrol1.Fon t = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl1.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl2.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl3.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))

DTPcontrol1.For mat = DateTimePickerF ormat.Custom
DTPcontrol1.Cus tomFormat = "dd/MM/yyyy"

Me.Panel2.Contr ols.Add(cbxcont rol1)
Me.Panel2.Contr ols.Add(TextCon trol1)
Me.Panel2.Contr ols.Add(TextCon trol2)
Me.Panel2.Contr ols.Add(TextCon trol3)
Me.Panel2.Contr ols.Add(TextCon trol4)
Me.Panel2.Contr ols.Add(DTPcont rol1)

DTPcontrol1.Val ue = DateValue(CStr( DTPdop.Value))
TextControl4.Te xt = CBxsite.Selecte dItem.ToString

dtbsdtab.Column s("cdate").Defa ultValue = Date.Today
cbxcontrol1.Dat aBindings.Add(N ew System.Windows. Forms.Binding(" Text", dtbsdtab, "wrknm", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl2.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "nowrk", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl3.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "totwg", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl4.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "sitenm", True, DataSourceUpdat eMode.OnPropert yChanged))
DTPcontrol1.Dat aBindings.Add(N ew System.Windows. Forms.Binding(" value", dtbsdtab, "cdate", True, DataSourceUpdat eMode.OnPropert yChanged))



cbxcontrol1.Tab Index = tabi
tabi += 1
TextControl1.Ta bIndex = tabi
tabi += 1
TextControl2.Ta bIndex = tabi
tabi += 1
TextControl3.Ta bIndex = tabi
tabi += 1

Badd.TabIndex = tabi
tabi += 1
Bsub.TabIndex = tabi
tabi += 1
Bsave.TabIndex = tabi
tabi += 1
Bexit.TabIndex = tabi
tabi += 1

AddHandler cbxcontrol1.Got Focus, AddressOf cbxcon_created
AddHandler cbxcontrol1.Sel ectedValueChang ed, AddressOf cbxcon_Selindch
AddHandler TextControl2.Lo stFocus, AddressOf txtbox_lostfocu ss
AddHandler TextControl2.Te xtChanged, AddressOf txtbox_lostfocu ss
AddHandler TextControl1.Te xtChanged, AddressOf txtbox_lostfocu ss

ind = ind + 1
indi = ind
temp += 30
temp1 += 1


Case 1

Dim xyz As DataRow = dtbsdtab.NewRow
dtbsdtab.Rows.A dd(xyz)

cbxcontrol12 = CType(CreateCon trols.MakeContr ol("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
TextControl12 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
TextControl22 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
TextControl32 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
TextControl42 = CType(CreateCon trols.MakeContr ol("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
DTPcontrol12 = CType(CreateCon trols.MakeContr ol("DateTimePic ker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Val ue), "DTP1" & ind), DateTimePicker)

cbxcontrol12.Fo nt = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl12.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl22.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))
TextControl32.F ont = New System.Drawing. Font("Microsoft Sans Serif", 10.0!, System.Drawing. FontStyle.Regul ar, System.Drawing. GraphicsUnit.Po int, CType(0, Byte))

DTPcontrol12.Fo rmat = DateTimePickerF ormat.Custom
DTPcontrol12.Cu stomFormat = "dd/MM/yyyy"

Me.Panel2.Contr ols.Add(cbxcont rol12)
Me.Panel2.Contr ols.Add(TextCon trol12)
Me.Panel2.Contr ols.Add(TextCon trol22)
Me.Panel2.Contr ols.Add(TextCon trol32)
Me.Panel2.Contr ols.Add(TextCon trol42)
Me.Panel2.Contr ols.Add(DTPcont rol12)

dtbsdtab.Column s("cdate").Defa ultValue = Date.Today
cbxcontrol12.Da taBindings.Add( New System.Windows. Forms.Binding(" Text", dtbsdtab, "wrknm", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl22.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "nowrk", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl32.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "totwg", True, DataSourceUpdat eMode.OnPropert yChanged))
TextControl42.D ataBindings.Add (New System.Windows. Forms.Binding(" Text", dtbsdtab, "sitenm", True, DataSourceUpdat eMode.OnPropert yChanged))
DTPcontrol12.Da taBindings.Add( New System.Windows. Forms.Binding(" value", dtbsdtab, "cdate", True, DataSourceUpdat eMode.OnPropert yChanged))

DTPcontrol12.Va lue = DateValue(CStr( DTPdop.Value))
TextControl42.T ext = CBxsite.Selecte dItem.ToString

cbxcontrol12.Ta bIndex = tabi
tabi += 1
TextControl12.T abIndex = tabi
tabi += 1
TextControl22.T abIndex = tabi
tabi += 1
TextControl32.T abIndex = tabi
tabi += 1

Badd.TabIndex = tabi
tabi += 1
Bsub.TabIndex = tabi
tabi += 1
Bsave.TabIndex = tabi
tabi += 1
Bexit.TabIndex = tabi
tabi += 1

AddHandler cbxcontrol12.Go tFocus, AddressOf cbxcon_created
AddHandler cbxcontrol12.Se lectedValueChan ged, AddressOf cbxcon_Selindch
AddHandler TextControl22.L ostFocus, AddressOf txtbox_lostfocu ss
AddHandler TextControl22.T extChanged, AddressOf txtbox_lostfocu ss
AddHandler TextControl12.T extChanged, AddressOf txtbox_lostfocu ss

ind = ind + 1
indi = ind
temp += 30
temp1 += 1


End Select

Else
MessageBox.Show ("Reached maximum limit")
End If

End Sub
Dec 1 '07 #3
raajakumars
5 New Member
urgent!!!!!!! kindly please anyone help me.......
actualy i am newbe to vb.net

i need to produce result like this.....

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
tamiz palace 12/1/2007 Mason 5 900



instead my following code producing o/p like this..

sitenm cdate wrknm nowrk totwg
tamiz palace 12/1/2007 Electrician 34 5100
null 12/1/2007 null null null

only updating value of last row added.i don't know y data from first set of controls are not added?????????

Expand|Select|Wrap|Line Numbers
  1. Private Sub Badd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Badd.Click
  2.  
  3.         If ind <> 35 Then
  4.             If temp >= 30 Then
  5.                 Me.Panel2.Height = Me.Panel1.Height + 30
  6.             End If
  7.             Select Case ind
  8.                 Case 0
  9.                     Dim xy As DataRow = dtbsdtab.NewRow
  10.                     dtbsdtab.Rows.Add(xy)
  11.  
  12.                     cbxcontrol1 = CType(CreateControls.MakeControl("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
  13.                     TextControl1 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
  14.                     TextControl2 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
  15.                     TextControl3 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
  16.                     TextControl4 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
  17.                     DTPcontrol1 = CType(CreateControls.MakeControl("DateTimePicker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Value), "DTP1" & ind), DateTimePicker)
  18.  
  19.                     cbxcontrol1.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  20.                     TextControl1.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  21.                     TextControl2.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  22.                     TextControl3.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  23.  
  24.                     DTPcontrol1.Format = DateTimePickerFormat.Custom
  25.                     DTPcontrol1.CustomFormat = "dd/MM/yyyy"
  26.  
  27.                     Me.Panel2.Controls.Add(cbxcontrol1)
  28.                     Me.Panel2.Controls.Add(TextControl1)
  29.                     Me.Panel2.Controls.Add(TextControl2)
  30.                     Me.Panel2.Controls.Add(TextControl3)
  31.                     Me.Panel2.Controls.Add(TextControl4)
  32.                     Me.Panel2.Controls.Add(DTPcontrol1)
  33.  
  34.                     DTPcontrol1.Value = DateValue(CStr(DTPdop.Value))
  35.                     TextControl4.Text = CBxsite.SelectedItem.ToString
  36.  
  37.                     dtbsdtab.Columns("cdate").DefaultValue = Date.Today
  38.                     cbxcontrol1.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "wrknm", True, DataSourceUpdateMode.OnPropertyChanged))
  39.                     TextControl2.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "nowrk", True, DataSourceUpdateMode.OnPropertyChanged))
  40.                     TextControl3.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "totwg", True, DataSourceUpdateMode.OnPropertyChanged))
  41.                     TextControl4.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "sitenm", True, DataSourceUpdateMode.OnPropertyChanged))
  42.                     DTPcontrol1.DataBindings.Add(New System.Windows.Forms.Binding("value", dtbsdtab, "cdate", True, DataSourceUpdateMode.OnPropertyChanged))
  43.  
  44.  
  45.  
  46.                     cbxcontrol1.TabIndex = tabi
  47.                     tabi += 1
  48.                     TextControl1.TabIndex = tabi
  49.                     tabi += 1
  50.                     TextControl2.TabIndex = tabi
  51.                     tabi += 1
  52.                     TextControl3.TabIndex = tabi
  53.                     tabi += 1
  54.  
  55.                     Badd.TabIndex = tabi
  56.                     tabi += 1
  57.                     Bsub.TabIndex = tabi
  58.                     tabi += 1
  59.                     Bsave.TabIndex = tabi
  60.                     tabi += 1
  61.                     Bexit.TabIndex = tabi
  62.                     tabi += 1
  63.  
  64.                     AddHandler cbxcontrol1.GotFocus, AddressOf cbxcon_created
  65.                     AddHandler cbxcontrol1.SelectedValueChanged, AddressOf cbxcon_Selindch
  66.                     AddHandler TextControl2.LostFocus, AddressOf txtbox_lostfocuss
  67.                     AddHandler TextControl2.TextChanged, AddressOf txtbox_lostfocuss
  68.                     AddHandler TextControl1.TextChanged, AddressOf txtbox_lostfocuss
  69.  
  70.                     ind = ind + 1
  71.                     indi = ind
  72.                     temp += 30
  73.                     temp1 += 1
  74.  
  75.  
  76.                 Case 1
  77.  
  78.                     Dim xyz As DataRow = dtbsdtab.NewRow
  79.                     dtbsdtab.Rows.Add(xyz)
  80.  
  81.                     cbxcontrol12 = CType(CreateControls.MakeControl("ComboBox", 40, 175, controlLeft, controlTop + 3 + temp, "", "Cbx" & ind), ComboBox)
  82.                     TextControl12 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft + 220, controlTop + 3 + temp, "0", "TB1" & ind), TextBox)
  83.                     TextControl22 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft + 360, controlTop + 3 + temp, "0", "TB2" & ind), TextBox)
  84.                     TextControl32 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft + 490, controlTop + 3 + temp, "0", "TB3" & ind), TextBox)
  85.                     TextControl42 = CType(CreateControls.MakeControl("TextBox", 20, 60, controlLeft, controlTop + 3 + temp, "", "TB4" & ind), TextBox)
  86.                     DTPcontrol12 = CType(CreateControls.MakeControl("DateTimePicker", 20, 60, controlLeft + 220, controlTop + 3 + temp, CStr(DTPdop.Value), "DTP1" & ind), DateTimePicker)
  87.  
  88.                     cbxcontrol12.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  89.                     TextControl12.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  90.                     TextControl22.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  91.                     TextControl32.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
  92.  
  93.                     DTPcontrol12.Format = DateTimePickerFormat.Custom
  94.                     DTPcontrol12.CustomFormat = "dd/MM/yyyy"
  95.  
  96.                     Me.Panel2.Controls.Add(cbxcontrol12)
  97.                     Me.Panel2.Controls.Add(TextControl12)
  98.                     Me.Panel2.Controls.Add(TextControl22)
  99.                     Me.Panel2.Controls.Add(TextControl32)
  100.                     Me.Panel2.Controls.Add(TextControl42)
  101.                     Me.Panel2.Controls.Add(DTPcontrol12)
  102.  
  103.                     dtbsdtab.Columns("cdate").DefaultValue = Date.Today
  104.                     cbxcontrol12.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "wrknm", True, DataSourceUpdateMode.OnPropertyChanged))
  105.                     TextControl22.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "nowrk", True, DataSourceUpdateMode.OnPropertyChanged))
  106.                     TextControl32.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "totwg", True, DataSourceUpdateMode.OnPropertyChanged))
  107.                     TextControl42.DataBindings.Add(New System.Windows.Forms.Binding("Text", dtbsdtab, "sitenm", True, DataSourceUpdateMode.OnPropertyChanged))
  108.                     DTPcontrol12.DataBindings.Add(New System.Windows.Forms.Binding("value", dtbsdtab, "cdate", True, DataSourceUpdateMode.OnPropertyChanged))
  109.  
  110.                     DTPcontrol12.Value = DateValue(CStr(DTPdop.Value))
  111.                     TextControl42.Text = CBxsite.SelectedItem.ToString
  112.  
  113.                     cbxcontrol12.TabIndex = tabi
  114.                     tabi += 1
  115.                     TextControl12.TabIndex = tabi
  116.                     tabi += 1
  117.                     TextControl22.TabIndex = tabi
  118.                     tabi += 1
  119.                     TextControl32.TabIndex = tabi
  120.                     tabi += 1
  121.  
  122.                     Badd.TabIndex = tabi
  123.                     tabi += 1
  124.                     Bsub.TabIndex = tabi
  125.                     tabi += 1
  126.                     Bsave.TabIndex = tabi
  127.                     tabi += 1
  128.                     Bexit.TabIndex = tabi
  129.                     tabi += 1
  130.  
  131.                     AddHandler cbxcontrol12.GotFocus, AddressOf cbxcon_created
  132.                     AddHandler cbxcontrol12.SelectedValueChanged, AddressOf cbxcon_Selindch
  133.                     AddHandler TextControl22.LostFocus, AddressOf txtbox_lostfocuss
  134.                     AddHandler TextControl22.TextChanged, AddressOf txtbox_lostfocuss
  135.                     AddHandler TextControl12.TextChanged, AddressOf txtbox_lostfocuss
  136.  
  137.                     ind = ind + 1
  138.                     indi = ind
  139.                     temp += 30
  140.                     temp1 += 1
  141.  
  142.  
  143.             End Select
  144.  
  145.         Else
  146.             MessageBox.Show("Reached maximum limit")
  147.         End If
  148.  
  149.     End Sub
Dec 1 '07 #4
CyberSoftHari
487 Recognized Expert Contributor
We can’t do homework for you. Describe your problem detail and post the code only in problematic area. (Better avoid giving description in topic.)

where are you inserting data?
Dec 1 '07 #5
raajakumars
5 New Member
We can’t do homework for you. Describe your problem detail and post the code only in problematic area. (Better avoid giving description in topic.)

where are you inserting data?
Actually i am dynamically adding controls,after controls are added only data that contained in last set of controls are in dataset.that is my problem
Dec 5 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics
9
4926
New record saved when Refresh clicked
by: Mark | last post by:
I have a working PHP/MySQL application used for data entry. The data entry screen includes a "Save" button. The PHP code for this button looks like this: if (isset($_POST)) { if ($_POST == "") { include ("InsertRecord.inc"); // Insert new record }
PHP
10
3554
Database record disappear
by: salamol | last post by:
I has a strange question. My company is using a old system with Win NT 4.0 Server + MS SQL 7.0. The system is busy and handle a lot of SELECTs and INSERTs all the time. Sometimes, some transactions are blocked by some other transactions. For those INSERT transactions, we usually call a stored procedure and pass parameters in to do the INSERT, at the end of the INSERT stored procedure, we always check @@ERROR = 0 and retrieve the...
Microsoft SQL Server
5
4335
Creating a record in a child table using ADO
by: Ilan Sebba | last post by:
When it comes to adding records in related tables, Access is really smart. But when I try to do the same using ADO, I am really stupid. Say I have two parent tables (eg Course, Student) and one child table (StudentProgress). The course progress records how a student progresses on a course. I have one course (History) and one student called Maya. I now want to record her grade (64). If I do this in Access using a form, then the form...
Microsoft Access / VBA
7
2958
Adding a record where Primary Keys are not known
by: Ilan Sebba | last post by:
I am trying to add a record using SQL. My problem is that the primary keys are foreign keys, and these foreign keys are autonumbers. I therefore do not know the primary keys of the record I am trying to insert. I therefore do not think that I can use the sql "Insert Into" command. Here is a simplified illustration of my tables: tblFather NaturalKey1 NatuarlKey2
Microsoft Access / VBA
4
4057
GTRR; If no Related Record, Create New In 2nd Form
by: amywolfie | last post by:
I've been trying to do something for about 3 days – I get close, but not 100%. I am trying to: Open frmRevisionHistory from a button on frmFeeInput. If there is NO RELATED RECORD, then I need to create one in frmRevisionHistory, and pass the PK (PK_Fees) on frmFeeInput to FK_Fees on the 2nd form.
Microsoft Access / VBA
8
9247
SQL Server Linked Table Insert Record Problem
by: Bri | last post by:
Greetings, I'm having a very strange problem in an AC97 MDB with ODBC Linked tables to SQL Server 7. The table has an Identity field and a Timestamp field. The problem is that when a new record is entered, either from a form or from the table view of the table, when the record gets saved it immediately displays #DELETED# in all of the fields. However, if I close the form or table view and reopen the record has in fact been inserted. The...
Microsoft Access / VBA
4
1457
Help selecting the proper child record
by: CK | last post by:
Good Morning, I have a person table with personID. I have a personRate table with personID, rateID, and effectiveDate. I need to select fields from personRate, but I want the fields from the proper record. I need the one child record that has the most current date of the largest rateID. For example a person may have many rate records. I need the record that has
Microsoft SQL Server
6
3859
How to delete a SQL Server record (descending from another record of the same table) with a C# application
by: polocar | last post by:
Hi, I'm writing a program in Visual C# 2005 Professional Edition. This program connects to a SQL Server 2005 database called "Generations" (in which there is only one table, called "Generations"), and it allows the user to add, edit and delete the various records of the table. "Generations" table has the following fields: "IDPerson", NamePerson", "AgePerson" and "IDParent". A record contains the information about a person (his name, his...
C# / C Sharp
9
24681
Move record from one table to another
by: Joshua.Buss | last post by:
I am trying to move a record from one linked table to another within access, but I'm a complete beginner to VBA and don't know exactly where to begin. I have an access file that has the two linked tables, which each link to separate SQL databases using separate ODBC connections. I have a form that has a view of table1 and a set of buttons for manipulating the data in database1.
Microsoft Access / VBA
10
12720
Is it possible to determine the record ID when using INSERT INTO?
by: MLH | last post by:
Suppose, in a multi-user environment, you have append query SQL in a VBA procedure that looks like INSERT INTO MyTable... and the next line reads MyVar=DMax("","MyTable... You can never be certain that MyVar will be set to the key-field value that was created when the Append query ran. Now, there are other ways to do it - I know - that will ensure you 'nab' the correct record. But I was wondering
Microsoft Access / VBA
0
9680
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
General
0
9528
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
Windows Server
0
10455
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
C / C++
0
10006
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
General
1
7547
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
Microsoft Access / VBA
0
6788
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
C# / C Sharp
0
5441
Trying to create a lan-to-lan vpn between two differents networks
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
Networking - Hardware / Configuration
1
4116
transfer the data from one system to another through ip address
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
C# / C Sharp
2
3731
muto222
How to add payments to a PHP MySQL app.
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
PHP

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us