Member Avatar for prathmanu

Hello,
Anybody help me to develop a web page for online registration with asp.net and sql server...plz

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by mail2saion
Member Avatar for mail2saion

What type of help required? Do you know how to write code.

Few steps you can follow:

Open vs. Go to file-->new-->website.
Then you found a default.aspx page.
now from tool box add some labels & textbox + a button to save data.

Now run the project will prompt you to create web.config file.

in the web.config file remove the <connectionstring/> line & paste the below code:

<connectionStrings>
<add name="TestConnection" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=TESTDB;Trusted_Connection=yes;"
      providerName="System.Data.SqlClient" />
</connectionStrings>

Just modify the database name by removing the TESTDB.

under button click event:
Write the insert statement to insert data in the below way.

String sConstr=ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString;
SqlConnection conn = new SqlConnection(sConstr);
SqlCommand comm = new SqlCommand("INSERT INTO TABLE(col1,col2) VALUES(TextBox1.Text,TextBox2.Text)", conn);
// If data type varchar then pad single quotation after & before the TextBox value.
conn.Open();
comm.ExecuteNonQuery();

Let me know if you need further information.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.