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

Question

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])
);