Insert data into multiple table in asp.net c sharp using click button

CREATE TABLE [dbo].[tblreg](
[rid] int identity(1,1) NOT NULL Primary key,
[r_name] [varchar](100) NULL,
[r_addr] [varchar](150) NULL,
);
CREATE TABLE [dbo].[tblgrp](
[gid] int identity(1,1) NOT NULL Primary key,
[g_name] [varchar](100) NULL,
[g_addr] [varchar](150) NULL,
[rid] [int] NOT NULL CONSTRAINT [FK_tblreg_tblgrp] FOREIGN KEY([rid]) REFERENCES [dbo].[tblreg]([rid])
);
CREATE TABLE [dbo].[tbldist](
[did] int identity(1,1) NOT NULL Primary key,
[d_name] [varchar](100) NULL,
[d_addr] [varchar](150) NULL,
[gid] [int] NOT NULL CONSTRAINT [FK_tblgrp_tbldist] FOREIGN KEY([gid]) REFERENCES [dbo].[tblgrp]([gid])
);
CREATE TABLE [dbo].[tblmemb](
[mid] int identity(1,1) NOT NULL Primary key ,
[sname] [varchar](50) NULL,
[fname] [varchar](50) NULL,
[gender] [varchar](50) NULL,
[status] [varchar](50) NULL,
[occupation] [varchar](50) NULL,
[designation] [varchar](50) NULL,
[m_addr] [varchar](150) NULL,
[contact] [varchar](50) NULL,
[did] [int] CONSTRAINT [FK_tbldist_tblmem] FOREIGN KEY([did]) REFERENCES [dbo].[tbldist]([did])
);

The click button is:

protected void btnSave_Click(object sender, EventArgs e)
{
string mainconn = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
SqlCommand cmd = new SqlCommand("Insert into tblreg (rid, r_name, r_addr) values(@rid, @r_name, @r_addr)", sqlconn);
cmd.Parameters.Add("@rid", SqlDbType.Int).Value = Convert.ToInt32(rid);
cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 100).Value = ddlregion.SelectedItem.Value.Trim();
cmd.Parameters.Add("@r_addr", SqlDbType.VarChar, 150).Value = txtr_addr.Text.Trim();
sqlconn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
SqlCommand cmd1 = new SqlCommand("Insert into tblgrp (gid, r_name, r_addr, rid) values(@gid, @r_name, @r_addr, @rid)", sqlconn);
cmd1.Parameters.Add("@gid", SqlDbType.Int).Value = Convert.ToInt32("gid");
cmd1.Parameters.Add("@g_name", SqlDbType.VarChar, 100).Value = ddlgroup.SelectedItem.Value.Trim();
cmd1.Parameters.Add("@g_addr", SqlDbType.VarChar, 150).Value = txtg_addr.Text.Trim();
cmd1.Parameters.Add("@rid", SqlDbType.Int).Value = Convert.ToInt32("gid"); ;
sqlconn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
SqlCommand cmd2 = new SqlCommand("Insert into tbldist (did, r_name, r_addr, gid) values(@did, @r_name, @r_addr, @gid)", sqlconn);
cmd2.Parameters.Add("@did", SqlDbType.Int).Value = Convert.ToInt32("did");
cmd2.Parameters.Add("@d_name", SqlDbType.VarChar, 100).Value = ddldistrict.SelectedItem.Value.Trim();
cmd2.Parameters.Add("@d_addr", SqlDbType.VarChar, 150).Value = txtd_addr.Text.Trim();
cmd2.Parameters.Add("@gid", SqlDbType.Int).Value = Convert.ToInt32("gid"); ;
sqlconn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
SqlCommand cmd3 = new SqlCommand("Insert into tbldist (did, r_name, r_addr, gid) values(@did, @r_name, @r_addr, @gid)", sqlconn);
cmd3.Parameters.Add("@mid", SqlDbType.Int).Value = Convert.ToInt32("mid"); ;
cmd3.Parameters.Add("@sname", SqlDbType.VarChar, 50).Value = txtsname.Text.Trim();
cmd3.Parameters.Add("@fname", SqlDbType.VarChar, 50).Value = txtfname.Text.Trim();
cmd3.Parameters.Add("@gender", SqlDbType.VarChar, 50).Value = ddlgender.SelectedItem.Value.Trim();
cmd3.Parameters.Add("@status", SqlDbType.VarChar, 50).Value = ddlstatus.SelectedItem.Value.Trim();
cmd3.Parameters.Add("@occupation", SqlDbType.VarChar, 50).Value = txtoccupation.Text.Trim();
cmd3.Parameters.Add("@designation", SqlDbType.VarChar, 50).Value = txtdesignation.Text.Trim();
cmd3.Parameters.Add("@home_addr", SqlDbType.VarChar, 150).Value = txthome_addr.Text.Trim();
cmd3.Parameters.Add("@contact", SqlDbType.Real).Value = Convert.ToInt32(txtcontact.Text.Trim());
cmd3.Parameters.Add("@did", SqlDbType.Int).Value = Convert.ToInt32("did"); ;
sqlconn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
sqlconn.Close();
Response.Write("Record inserted successfully");
ddlregion.SelectedItem.Text = "";
txtr_addr.Text = "";
ddlgroup.SelectedItem.Text = "";
txtg_addr.Text = "";
ddldistrict.SelectedItem.Text = "";
txtd_addr.Text = "";
txtsname.Text = "";
txtfname.Text = "";
ddlgender.SelectedItem.Text = "";
ddlstatus.SelectedItem.Text = "";
txtoccupation.Text = "";
txthome_addr.Text = "";
txtcontact.Text = "";
}

The four tables are:

CREATE TABLE [dbo].[tblreg](
[rid] int identity(1,1) NOT NULL Primary key,
[r_name] [varchar](100) NULL,
[r_addr] [varchar](150) NULL,
);
CREATE TABLE [dbo].[tblgrp](
[gid] int identity(1,1) NOT NULL Primary key,
[g_name] [varchar](100) NULL,
[g_addr] [varchar](150) NULL,
[rid] [int] NOT NULL CONSTRAINT [FK_tblreg_tblgrp] FOREIGN KEY([rid]) REFERENCES [dbo].[tblreg]([rid])
);
CREATE TABLE [dbo].[tbldist](
[did] int identity(1,1) NOT NULL Primary key,
[d_name] [varchar](100) NULL,
[d_addr] [varchar](150) NULL,
[gid] [int] NOT NULL CONSTRAINT [FK_tblgrp_tbldist] FOREIGN KEY([gid]) REFERENCES [dbo].[tblgrp]([gid])
);
CREATE TABLE [dbo].[tblmemb](
[mid] int identity(1,1) NOT NULL Primary key ,
[sname] [varchar](50) NULL,
[fname] [varchar](50) NULL,
[gender] [varchar](50) NULL,
[status] [varchar](50) NULL,
[occupation] [varchar](50) NULL,
[designation] [varchar](50) NULL,
[m_addr] [varchar](150) NULL,
[contact] [varchar](50) NULL,
[did] [int] CONSTRAINT [FK_tbldist_tblmem] FOREIGN KEY([did]) REFERENCES [dbo].[tbldist]([did])
);

I am a bit confused. The references are helpful but cannot specifically fix the issues. I am using webforms. I want someone to guide me to fix the sp of the four tables, tblreg, tblgrp, tbldist and tblmem. Pls I need the right code for btnInsert aspecially the foreign keys of the four table. Pls I need help. Thanks.

Pls can someone guide to correct this sp

Create procedure spInsertMembers

@r_name varchar(100),

@r_addr varchar(150),

@g_name varchar(100),

@g_addr varchar(150),

@d_name varchar(100),

@d_addr varchar(150),

@sname varchar(50),

@fname varchar(50),

@gender varchar(50),

@occupation varchar(50),

@designation varchar(50),

@home_addr varchar(150),

@contact real

Begin

Declare @rid int

Declare @gid int

Declare @did int

Declare @mid int

Select @rid = rid from tblreg where r_name = @r_name

Select @gid = gid from tblgrp where g_name = @g_name

Select @did = did from tbldist where d_name = @d_name

Select @mid = mid from tblmem where contact = @contact

If (@rid is null)

Begin

Insert into tblreg (r_name, r_addr) values(@r_name, @r_addr)

Select @rid = SCOPE_IDENTITY()

End

If (@gid is null)

Begin

Insert into tblgrp (g_name, g_addr,rid) values( @g_name, @g_addr,@rid)

Select @gid = SCOPE_IDENTITY()

End

If (@did is null)

Begin

Insert into tbldist (d_name, d_addr,gid) values(@d_name, @d_addr,@gid)

Select @did = SCOPE_IDENTITY()

End

If (@mid is null)

Begin

Insert into tblmem (sname, fname, gender, occupation, designation, home_addr, contact,did) values(@did, @sname, @fname, @gender, @occupation, @designation, @home_addr, @contact,@did)

Select @mid = SCOPE_IDENTITY()

End

Hi,

Wich ever parameter you need to return as output then you need to mark that parameter as outPut,

Please refer this link which will make you more clear on this.

https://www.aspsnippets.com/Articles/Return-Identity-value-from-Stored-Procedure-in-SQL-Server.aspx

protected void btnSave_Click(object sender, EventArgs e)
{
string mainconn = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
SqlCommand cmd = new SqlCommand("spInsertMember", sqlconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rid", SqlDbType.Int, 0);
cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 100).Value = ddlregion.SelectedItem.Value.Trim();
cmd.Parameters.Add("@r_addr", SqlDbType.VarChar, 150).Value = txtr_addr.Text.Trim();
cmd.Parameters.Add("@gid", SqlDbType.Int, 0);
cmd.Parameters.Add("@g_name", SqlDbType.VarChar, 100).Value = ddlgroup.SelectedItem.Value.Trim();
cmd.Parameters.Add("@g_addr", SqlDbType.VarChar, 150).Value = txtg_addr.Text.Trim();
cmd.Parameters.Add("@rid", SqlDbType.Int, 0);
cmd.Parameters.Add("@did", SqlDbType.Int, 0);
cmd.Parameters.Add("@d_name", SqlDbType.VarChar, 100).Value = ddldistrict.SelectedItem.Value.Trim();
cmd.Parameters.Add("@d_addr", SqlDbType.VarChar, 150).Value = txtd_addr.Text.Trim();
cmd.Parameters.Add("@gid", SqlDbType.Int, 0);
cmd.Parameters.Add("@mid", SqlDbType.Int, 0);
cmd.Parameters.Add("@sname", SqlDbType.VarChar, 50).Value = txtsname.Text.Trim();
cmd.Parameters.Add("@fname", SqlDbType.VarChar, 50).Value = txtfname.Text.Trim();
cmd.Parameters.Add("@gender", SqlDbType.VarChar, 50).Value = ddlgender.SelectedItem.Value.Trim();
cmd.Parameters.Add("@status", SqlDbType.VarChar, 50).Value = ddlstatus.SelectedItem.Value.Trim();
cmd.Parameters.Add("@occupation", SqlDbType.VarChar, 50).Value = txtoccupation.Text.Trim();
cmd.Parameters.Add("@designation", SqlDbType.VarChar, 50).Value = txtdesignation.Text.Trim();
cmd.Parameters.Add("@home_addr", SqlDbType.VarChar, 150).Value = txthome_addr.Text.Trim();
cmd.Parameters.Add("@contact", SqlDbType.Real).Value = txtcontact.Text.Trim();
cmd.Parameters.Add("@did", SqlDbType.Int, 0);
sqlconn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
sqlconn.Close();
Response.Write("Record inserted successfully");
ddlregion.SelectedItem.Text = "";
txtr_addr.Text = "";
ddlgroup.SelectedItem.Text = "";
txtg_addr.Text = "";
ddldistrict.SelectedItem.Text = "";
txtd_addr.Text = "";
txtsname.Text = "";
txtfname.Text = "";
ddlgender.SelectedItem.Text = "";
ddlstatus.SelectedItem.Text = "";
txtoccupation.Text = "";
txthome_addr.Text = "";
txtcontact.Text = "";
}

Many thanks for the links but here is what I try to do. Pls help

Create procedure spInsertMembers

@r_name varchar(100),

@r_addr varchar(150),

@g_name varchar(100),

@g_addr varchar(150),

@d_name varchar(100),

@d_addr varchar(150),

@sname varchar(50),

@fname varchar(50),

@gender varchar(50),

@occupation varchar(50),

@designation varchar(50),

@home_addr varchar(150),

@contact real

Begin

Declare @rid int

Declare @gid int

Declare @did int

Declare @mid int

Select @rid = rid from tblreg where r_name = @r_name

Select @gid = gid from tblgrp where g_name = @g_name

Select @did = did from tbldist where d_name = @d_name

Select @mid = mid from tblmem where contact = @contact

If (@rid is null)

Begin

Insert into tblreg (r_name, r_addr) values(@r_name, @r_addr)

Select @rid = SCOPE_IDENTITY()

End

If (@gid is null)

Begin

Insert into tblgrp (g_name, g_addr,rid) values( @g_name, @g_addr,@rid)

Select @gid = SCOPE_IDENTITY()

End

If (@did is null)

Begin

Insert into tbldist (d_name, d_addr,gid) values(@d_name, @d_addr,@gid)

Select @did = SCOPE_IDENTITY()

End

If (@mid is null)

Begin

Insert into tblmem (sname, fname, gender, occupation, designation, home_addr, contact,did) values(@did, @sname, @fname, @gender, @occupation, @designation, @home_addr, @contact,@did)

Select @mid = SCOPE_IDENTITY()

End

Hi Akani,

It is quite common to add record into multiple tables. First let us know which technologies are you using i.e. ado.net, entity framework or other ORM and then webforms or MVC. Then we can give you better code for reference.

Here is a sample for entity framework

https://www.aspforums.net/Threads/134214/Inserting-into-multiple-Table-using-Entity-Framework-in-ASPNet/

Regards

Rijwan

please show us what have you done so far, you can use AdO.Net or Entity Framework to insert data into database.

then if you stuck anywhere then let us know.

See this link also, https://www.codeproject.com/Articles/25457/Multiple-Ways-to-do-Multiple-Inserts https://forums.asp.net/t/2048660.aspx?Insert+data+into+multiple+tables+in+SQL+Server+from+asp+net+page

Hello,

Please go through the below link

https://www.daniweb.com/programming/web-development/threads/388712/how-to-insert-data-into-multiple-tables-using-asp-net-c-form

https://stackoverflow.com/questions/16092895/insert-some-data-into-multiple-tables-using-c-sharp

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akani Odomene5y ago
The click button is:
protected void btnSave_Click(object sender, EventArgs e)
{
    string mainconn = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
    SqlConnection sqlconn = new SqlConnection(mainconn);
    SqlCommand cmd = new SqlCommand("Insert into tblreg (rid, r_name, r_addr) values(@rid, @r_name, @r_addr)", sqlconn);
    cmd.Parameters.Add("@rid", SqlDbType.Int).Value = Convert.ToInt32(rid);
    cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 100).Value = ddlregion.SelectedItem.Value.Trim();
    cmd.Parameters.Add("@r_addr", SqlDbType.VarChar, 150).Value = txtr_addr.Text.Trim();
    sqlconn.Open();
    cmd.ExecuteNonQuery();
    cmd.Parameters.Clear();

    SqlCommand cmd1 = new SqlCommand("Insert into tblgrp (gid, r_name, r_addr, rid) values(@gid, @r_name, @r_addr, @rid)", sqlconn);
    cmd1.Parameters.Add("@gid", SqlDbType.Int).Value = Convert.ToInt32("gid");
    cmd1.Parameters.Add("@g_name", SqlDbType.VarChar, 100).Value = ddlgroup.SelectedItem.Value.Trim();
    cmd1.Parameters.Add("@g_addr", SqlDbType.VarChar, 150).Value = txtg_addr.Text.Trim();
    cmd1.Parameters.Add("@rid", SqlDbType.Int).Value = Convert.ToInt32("gid"); ;
    sqlconn.Open();
    cmd.ExecuteNonQuery();
    cmd.Parameters.Clear();

    SqlCommand cmd2 = new SqlCommand("Insert into tbldist (did, r_name, r_addr, gid) values(@did, @r_name, @r_addr, @gid)", sqlconn);
    cmd2.Parameters.Add("@did", SqlDbType.Int).Value = Convert.ToInt32("did");
    cmd2.Parameters.Add("@d_name", SqlDbType.VarChar, 100).Value = ddldistrict.SelectedItem.Value.Trim();
    cmd2.Parameters.Add("@d_addr", SqlDbType.VarChar, 150).Value = txtd_addr.Text.Trim();
    cmd2.Parameters.Add("@gid", SqlDbType.Int).Value = Convert.ToInt32("gid"); ;
    sqlconn.Open();
    cmd.ExecuteNonQuery();
    cmd.Parameters.Clear();

    SqlCommand cmd3 = new SqlCommand("Insert into tbldist (did, r_name, r_addr, gid) values(@did, @r_name, @r_addr, @gid)", sqlconn);
    cmd3.Parameters.Add("@mid", SqlDbType.Int).Value = Convert.ToInt32("mid"); ;
    cmd3.Parameters.Add("@sname", SqlDbType.VarChar, 50).Value = txtsname.Text.Trim();
    cmd3.Parameters.Add("@fname", SqlDbType.VarChar, 50).Value = txtfname.Text.Trim();
    cmd3.Parameters.Add("@gender", SqlDbType.VarChar, 50).Value = ddlgender.SelectedItem.Value.Trim();
    cmd3.Parameters.Add("@status", SqlDbType.VarChar, 50).Value = ddlstatus.SelectedItem.Value.Trim();
    cmd3.Parameters.Add("@occupation", SqlDbType.VarChar, 50).Value = txtoccupation.Text.Trim();
    cmd3.Parameters.Add("@designation", SqlDbType.VarChar, 50).Value = txtdesignation.Text.Trim();
    cmd3.Parameters.Add("@home_addr", SqlDbType.VarChar, 150).Value = txthome_addr.Text.Trim();
    cmd3.Parameters.Add("@contact", SqlDbType.Real).Value = Convert.ToInt32(txtcontact.Text.Trim());
    cmd3.Parameters.Add("@did", SqlDbType.Int).Value = Convert.ToInt32("did"); ;
    sqlconn.Open();
    cmd.ExecuteNonQuery();
    cmd.Parameters.Clear();
    sqlconn.Close();
    Response.Write("Record inserted successfully");
    ddlregion.SelectedItem.Text = "";
    txtr_addr.Text = "";
    ddlgroup.SelectedItem.Text = "";
    txtg_addr.Text = "";
    ddldistrict.SelectedItem.Text = "";
    txtd_addr.Text = "";
    txtsname.Text = "";
    txtfname.Text = "";
    ddlgender.SelectedItem.Text = "";
    ddlstatus.SelectedItem.Text = "";
    txtoccupation.Text = "";
    txthome_addr.Text = "";
    txtcontact.Text = "";
}
Akani Odomene5y ago
The four tables are:
CREATE TABLE [dbo].[tblreg](
    [rid] int identity(1,1) NOT NULL Primary key,
    [r_name] [varchar](100) NULL,
        [r_addr] [varchar](150) NULL,
);

CREATE TABLE [dbo].[tblgrp](
    [gid] int identity(1,1) NOT NULL Primary key,
    [g_name] [varchar](100) NULL,
    [g_addr] [varchar](150) NULL,
    [rid] [int] NOT NULL CONSTRAINT [FK_tblreg_tblgrp] FOREIGN KEY([rid]) REFERENCES [dbo].[tblreg]([rid])
);

CREATE TABLE [dbo].[tbldist](
    [did] int identity(1,1) NOT NULL Primary key,
    [d_name] [varchar](100) NULL,
        [d_addr] [varchar](150) NULL,
    [gid]    [int] NOT NULL CONSTRAINT [FK_tblgrp_tbldist] FOREIGN KEY([gid]) REFERENCES [dbo].[tblgrp]([gid])
);

CREATE TABLE [dbo].[tblmemb](
    [mid] int identity(1,1) NOT NULL Primary key ,
    [sname] [varchar](50) NULL,
        [fname] [varchar](50) NULL,
    [gender] [varchar](50) NULL,
        [status] [varchar](50) NULL,
    [occupation] [varchar](50) NULL,
        [designation] [varchar](50) NULL,
    [m_addr] [varchar](150) NULL,
        [contact] [varchar](50) NULL,
    [did] [int] CONSTRAINT [FK_tbldist_tblmem] FOREIGN KEY([did]) REFERENCES [dbo].[tbldist]([did])
);
Akani Odomene5y ago
I am a bit confused. The references are helpful but cannot specifically fix the issues. I am using webforms. I want someone to guide me to fix the sp of the four tables, tblreg, tblgrp, tbldist and tblmem. Pls I need the right code for btnInsert aspecially the foreign keys of the four table. Pls I need help. Thanks.
Akani Odomene5y ago
Pls can someone guide to correct this sp

Create procedure spInsertMembers
@r_name varchar(100),
@r_addr varchar(150),
@g_name varchar(100),
@g_addr varchar(150),
@d_name varchar(100),
@d_addr varchar(150),
@sname varchar(50),
@fname varchar(50),
@gender varchar(50),
@occupation varchar(50),
@designation varchar(50),
@home_addr varchar(150),
@contact real
as
Begin

Declare @rid int
Declare @gid int
Declare @did int
Declare @mid int

Select @rid = rid from tblreg where r_name = @r_name
Select @gid = gid from tblgrp where g_name = @g_name
Select @did = did from tbldist where d_name = @d_name
Select @mid = mid from tblmem where contact = @contact

If (@rid is null)
Begin
Insert into tblreg (r_name, r_addr) values(@r_name, @r_addr)
Select @rid = SCOPE_IDENTITY()
End

If (@gid is null)
Begin
Insert into tblgrp (g_name, g_addr,rid) values( @g_name, @g_addr,@rid)
Select @gid = SCOPE_IDENTITY()
End

If (@did is null)
Begin
Insert into tbldist (d_name, d_addr,gid) values(@d_name, @d_addr,@gid)
Select @did = SCOPE_IDENTITY()
End

If (@mid is null)
Begin
Insert into tblmem (sname, fname, gender, occupation, designation, home_addr, contact,did) values(@did, @sname, @fname, @gender, @occupation, @designation, @home_addr, @contact,@did)
Select @mid = SCOPE_IDENTITY()
End
Jignesh Kumar5y ago
Hi,

Wich ever parameter you need to return as output then you need to mark that parameter as outPut,
Please refer this link which will make you more clear on this.

https://www.aspsnippets.com/Articles/Return-Identity-value-from-Stored-Procedure-in-SQL-Server.aspx
Akani Odomene5y ago
1. protected void btnSave_Click(object sender, EventArgs e)
2. {
3. string mainconn = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
4. SqlConnection sqlconn = new SqlConnection(mainconn);
5. SqlCommand cmd = new SqlCommand("spInsertMember", sqlconn);
6. cmd.CommandType = CommandType.StoredProcedure;
7. cmd.Parameters.Add("@rid", SqlDbType.Int, 0);
8. cmd.Parameters.Add("@r_name", SqlDbType.VarChar, 100).Value = ddlregion.SelectedItem.Value.Trim();
9. cmd.Parameters.Add("@r_addr", SqlDbType.VarChar, 150).Value = txtr_addr.Text.Trim();
10. cmd.Parameters.Add("@gid", SqlDbType.Int, 0);
11. cmd.Parameters.Add("@g_name", SqlDbType.VarChar, 100).Value = ddlgroup.SelectedItem.Value.Trim();
12. cmd.Parameters.Add("@g_addr", SqlDbType.VarChar, 150).Value = txtg_addr.Text.Trim();
13. cmd.Parameters.Add("@rid", SqlDbType.Int, 0);
14. cmd.Parameters.Add("@did", SqlDbType.Int, 0);
15. cmd.Parameters.Add("@d_name", SqlDbType.VarChar, 100).Value = ddldistrict.SelectedItem.Value.Trim();
16. cmd.Parameters.Add("@d_addr", SqlDbType.VarChar, 150).Value = txtd_addr.Text.Trim();
17. cmd.Parameters.Add("@gid", SqlDbType.Int, 0);
18. cmd.Parameters.Add("@mid", SqlDbType.Int, 0);
19. cmd.Parameters.Add("@sname", SqlDbType.VarChar, 50).Value = txtsname.Text.Trim();
20. cmd.Parameters.Add("@fname", SqlDbType.VarChar, 50).Value = txtfname.Text.Trim();
21. cmd.Parameters.Add("@gender", SqlDbType.VarChar, 50).Value = ddlgender.SelectedItem.Value.Trim();
22. cmd.Parameters.Add("@status", SqlDbType.VarChar, 50).Value = ddlstatus.SelectedItem.Value.Trim();
23. cmd.Parameters.Add("@occupation", SqlDbType.VarChar, 50).Value = txtoccupation.Text.Trim();
24. cmd.Parameters.Add("@designation", SqlDbType.VarChar, 50).Value = txtdesignation.Text.Trim();
25. cmd.Parameters.Add("@home_addr", SqlDbType.VarChar, 150).Value = txthome_addr.Text.Trim();
26. cmd.Parameters.Add("@contact", SqlDbType.Real).Value = txtcontact.Text.Trim();
27. cmd.Parameters.Add("@did", SqlDbType.Int, 0);
28. sqlconn.Open();
29. cmd.ExecuteNonQuery();
30. cmd.Parameters.Clear();
31. sqlconn.Close();
32. Response.Write("Record inserted successfully");
33. ddlregion.SelectedItem.Text = "";
34. txtr_addr.Text = "";
35. ddlgroup.SelectedItem.Text = "";
36. txtg_addr.Text = "";
37. ddldistrict.SelectedItem.Text = "";
38. txtd_addr.Text = "";
39. txtsname.Text = "";
40. txtfname.Text = "";
41. ddlgender.SelectedItem.Text = "";
42. ddlstatus.SelectedItem.Text = "";
43. txtoccupation.Text = "";
44. txthome_addr.Text = "";
45. txtcontact.Text = "";
46. }