connect to sql server 2005 using c#

[pugalenthi]

I need to connect to sql server 2005 from c# program, so that i can store the output of the c# code into the database.

Firstly i should get connected to the sql server, secondly i should create a sql table using c# program and then finally store the output of the c# program in the sql table.

please help me in this regard.

[k3nTm]

I need to connect to sql server 2005 from c# program, so that i can store the output of the c# code into the database.

Firstly i should get connected to the sql server, secondly i should create a sql table using c# program and then finally store the output of the c# program in the sql table.

please help me in this regard.

HALO GOOD DAY

for your connection string use this code:

string ConnStrng = "Data Source=localhos t\\sqlexpress;I nitial Catalog=XXXXt; Integrated Security=SSPI;" ;

where: XXX is the name of your database.

[pugalenthi]

HALO GOOD DAY

for your connection string use this code:

string ConnStrng = "Data Source=localhos t\\sqlexpress;I nitial Catalog=XXXXt; Integrated Security=SSPI;" ;

where: XXX is the name of your database.

I have established the connection with SQL Server 2005 from my c# program. I am able to view the data in the tables using the SqlDataReader but how can i write into the database tables the output of my c# program. There isn't any class called SqlDataWriter. Please help me in this regard.

[Plater]

You would use SQL statements.
Check this article:
http://www.thescripts.com/forum/thread635615.html

[k3nTm]

just try this code

string ConnStrng = "Data Source=localhos t\\sqlexpress;I nitial Catalog=Members Account; Integrated Security=SSPI;" ;
string updateRec = "INSERT INTO TblMembers(Full Name, Iam, Email, Password, BirthMonth, BirthDay, BirthYear) VALUES (@FullName, @Iam, @Email, @Password, @BirthMonth, @BirthDay, @BirthYear)";

SqlConnection SqlConn = new SqlConnection(C onnStrng);

SqlCommand sqlCmd = new SqlCommand(upda teRec,SqlConn);

sqlCmd.Paramete rs.AddWithValue ("@FullName" , txtfullname.Tex t);
sqlCmd.Paramete rs.AddWithValue ("@Iam", txtiam.Text);
sqlCmd.Paramete rs.AddWithValue ("@Email", txtemail.Text);
sqlCmd.Paramete rs.AddWithValue ("@Password" , txtpassword.Tex t);
sqlCmd.Paramete rs.AddWithValue ("@BirthMont h", ddlmonth.Text);
sqlCmd.Paramete rs.AddWithValue ("@BirthDay" , ddlday.Text);
sqlCmd.Paramete rs.AddWithValue ("@BirthYear ", txtyear.Text);

if (Page.IsValid)
{
try
{
SqlConn.Open();
sqlCmd.ExecuteN onQuery();
lblSecMessage.T ext = "Thank you for registering.";
}
catch (Exception ex)
{
lblSecMessage.T ext = ex.Message;
}
finally
{
SqlConn.Close() ;
}
}