Scribd
Upload
23 views1 page

How To Add To Database

Uploaded by

Altaf Hussain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
23 views1 page

How To Add To Database

Uploaded by

Altaf Hussain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

//1.

Address of SQL server and Database

string ConnectionString = @"Data Source=(LocalDB)\


MSSQLLocalDB;AttachDbFilename=C:\Users\A R F T\OneDrive\Desktop\MY DATABASE\
[Link];Integrated Security=True;Connect Timeout=30";

//2. Estabish Connection

SqlConnection con = new SqlConnection(ConnectionString);

//3. Open Connection

[Link]();

//4. Prepare Query


string FirstName=[Link];
string SecondName=[Link];
string Query = "INSERT INTO Names(FirstName,SecondName) VALUES
('"+FirstName+"','"+SecondName+"')";

//5. Execute Query

SqlCommand cmd = new SqlCommand(Query, con);


[Link]();

//6. Close Connection


[Link]();

[Link]("Data Has Been Saved!");


[Link] = "";
[Link] = "";
[Link] = "";

You might also like