Dynamic Controls with Dynamically Create Table &SP
private void
insert_Click(object
sender, EventArgs
e) {
SqlCommand oSqlCommand1
= new
SqlCommand("create table " + cbBikeno.SelectedItem.ToString()
+ "(service_no int identity(1,1),service_date datetime,status
varchar(50))", oSqlCon);
oSqlCon.Open();
oSqlCommand1.ExecuteNonQuery();
oSqlCon.Close();
SqlCommand osqlcmd
= new
SqlCommand("create procedure sp" + cbBikeno.SelectedItem.ToString()
+ " @service_date datetime,@status varchar(10) as
" + "insert into
" + cbBikeno.SelectedItem.ToString() +
" values(@service_date,@status)",
oSqlCon);
oSqlCon.Open();
osqlcmd.ExecuteNonQuery();
oSqlCon.Close();
TextBox tb =
new
TextBox();
DateTime s;
foreach (Control ctl in groupBox2.Controls)
{
if
(ctl is
TextBox)
{
s = Convert.ToDateTime(((TextBox)ctl).Text);
osqlcmd =
new
SqlCommand("sp" + cbBikeno.SelectedItem.ToString() +
" " + "'" + s + "','
0 '",
oSqlCon);
oSqlCon.Open();
osqlcmd.ExecuteNonQuery();
oSqlCon.Close();
}
}
}
public void
dtp_ValueChanged(object
sender, EventArgs
e) {
DateTimePicker
dp = new
DateTimePicker();
dp = (DateTimePicker)sender;
TextBox txt =
new
TextBox();
string ctlname
= "tb" + dp.Name.Substring(3,
(dp.Name.Length) - 3).ToString(); ;
for (int i = 0; i <= groupBox2.Controls.Count
- 1; i++)
{
if
(groupBox2.Controls[i].Name == ctlname)
{
txt = (TextBox)groupBox2.Controls[i];
txt.Text = dp.Value.ToString("dd/MMM/yy");
}
} }
private void
generatectls_Click(object
sender, EventArgs
e) {
groupBox2.Controls.Clear();
for (int loop = 1; loop <=
Convert.ToInt16(txtNo.Text);
loop++)
{
DateTimePicker
dtp = new
DateTimePicker();
TextBox
tb = new
TextBox();
tb.Name =
"tb" + loop;
tb.Left = 30;
tb.Top = 10 + loop * 25;
groupBox2.Controls.Add(tb);
dtp.Name =
"dtp" + loop;
dtp.Left = 170;
dtp.Top = 10 + loop * 25;
groupBox2.Controls.Add(dtp);
dtp.ValueChanged += new
EventHandler(dtp_ValueChanged);
}
}
private void
getvalue_Click(object
sender, EventArgs
e) {
string s =
string.Empty;
foreach (Control ctl in groupBox2.Controls)
{
if
(ctl is
TextBox)
{
if
(s.Equals(string.Empty))
s = ((TextBox)ctl).Text;
else
s = s
+ "," + ((TextBox)ctl).Text;
}
}
MessageBox.Show(s); }