Hi Arun ,
This is not a process of database programming with C#.
I will explain you briefly
Suppose you have below information to be save in database.
1) Full Name of user
2) Mobile number of user
3) Location of user
Then Create this table into sql server
Create table registration
(
regid uniqueidentifier, fullname nvarchar(255),Mobile nvarchar(50),Location nvarchar(50)
)
then create this procedure
CREATE PROCEDURE Saveregistration
(
@Full NVARCHAR(50),
@Mobile NVARCHAR(50),
@Location NVARCHAR(50)
)
AS
BEGIN
INSERT INTO registration
select newid(), @Full,@Mobile,@Location
END
then use below code to call this procedure
SqlConnection con ;
con=new SqlConnection("Data Source=;initial catalog=Northwind;User Id=;Password= '");
con.open();
SqlCommand command = new SqlCommand("Saveregistration ",con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Full",SqlDbType.NVARCHAR,50,txtfullname.text));
command.Parameters.Add(new SqlParameter("@Mobile ",SqlDbType.NVARCHAR,50,txtMobile.txt));
command.Parameters.Add(new SqlParameter("@Location ",SqlDbType.NVARCHAR,50,txtLocation.txt));
int i=command.ExecuteNonQuery();
Hope this helps if yes then accept and vote the answer otherwise revert back with your queries
--Rahul D.