Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Data.Odbc;
- using System.Configuration;
- using System.Data;
- public partial class website1 : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- OdbcConnection con = new OdbcConnection(
- ConfigurationManager.ConnectionStrings["Connname"].ConnectionString);
- con.Open();
- String sname, rollno;
- sname = TextBox1.Text;
- rollno = TextBox2.Text;
- String query1 = "insert into students values('"+sname+"','"+rollno+"')";
- OdbcCommand command1 = new OdbcCommand(query1, con);
- String query = "select * from students";
- OdbcCommand command = new OdbcCommand(query, con);
- OdbcDataReader reader = command.ExecuteReader();
- if (reader.HasRows)
- {
- DataTable dt = new DataTable();
- dt.Load(reader);
- foreach (DataRow row in dt.Rows)
- {
- String name = row[0].ToString();
- String no = row[1].ToString();
- Response.Write("<h1>" + name +" "+no+ "</h1>");
- }
- }
- }
- }
Add Comment
Please, Sign In to add comment