How can I save my Textbox content in a database? Textbox is programmed in HTML and CSS

Question

I have a fully finished Frontend of my Web Application, now I have to save the textbox content in my Database(SQL) which I created in Visual Studio.

My ConnectionString is already programmed Image I coded my textbox as following:

My Code

How do I have to integrate my C# in my HTML code so it saves my content?

Thanks for your time

What exactly do you need to know? Have you created a table in the database to store those values? Would you want to use Entity Framework or ADO? In order to help, I think we need more content from your question — Pedro G. Dias
– Pedro G. Dias, Commented May 18, 2016 at 11:40
How to store my Data in the Database. It should save it as soon as i press a "next" button". What i also want to know is how i have to set this all up in my html code — Alessandro Minneci
– Alessandro Minneci, Commented May 18, 2016 at 11:53

Community · Accepted Answer · 2017-05-23 12:08:39Z

1

Use this in whichever event you want it to execute in:

string con = //your connection string here
string yourTextValue = Passnummer.Text; //This will extract the text from your textbox and store it in a variable
using (string con = new SqlConnection()) {
con.Open();

var command =
    new SqlCommand("INSERT INTO yourTable(columnname) VALUES (@textValue);", con);
command.Parameters.AddWithValue("@textValue", yourTextValue);

command.ExecuteNonQuery();
con.Close();
}

See Here

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered May 18, 2016 at 12:04

BoogaWooga

1087 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alessandro Minneci Over a year ago

Thank you for your anwer. Do you know any way on how i can save my textbox value, in a variable?

BoogaWooga Over a year ago

string yourTextValue is your variable in this case So what you do is take say: string yourTextValue = yourtextboxname.Text; this will take what is in your textbox and store it in the variable (as soon as your event is fired) So say you want to do this in a button click, you insert the code above in to the button click method, as soon as you click your button it will look at your textbox and store whatever is currently in there to the variable

Collectives™ on Stack Overflow

How can I save my Textbox content in a database? Textbox is programmed in HTML and CSS

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related