using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace test
{
public partial class WebForm1 : System.Web.UI.Page
{
static string strconn = "Data Source=localhost;database=BOOKS;integrated security=SSPI";
static SqlConnection conn = new SqlConnection(strconn);
static SqlCommand sqlcmd;
static SqlDataReader SqlReader;
protected void Page_Load(object sender, EventArgs e)
{
sqlcmd = conn.CreateCommand();
conn.Open();
sqlcmd.CommandText = "SELECT * FROM ip";
SqlDataAdapter ad = new SqlDataAdapter(sqlcmd);
DataSet set = new DataSet();
ad.Fill(set, "ip");
DataTable tb = set.Tables["ip"];
Response.Write("<Table Border='1'><Tr align='Center'>");
for (int i = 0; i < tb.Columns.Count; i++)
{
Response.Write("<Td>" + tb.Columns[i] + "</Td>");
}
Response.Write("</Tr>");
for (int i = 0; i < tb.Rows.Count; i++)
{
Response.Write("<Tr>");
for (int j = 0; j < tb.Columns.Count; j++)
{
Response.Write("<Td>" + tb.Rows[i][j] + "</Td>");
}
Response.Write("</Tr>");
}
Response.Write("</Table>");
}
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace test
{
public partial class WebForm1 : System.Web.UI.Page
{
static string strconn = "Data Source=localhost;database=BOOKS;integrated security=SSPI";
static SqlConnection conn = new SqlConnection(strconn);
static SqlCommand sqlcmd;
static SqlDataReader SqlReader;
protected void Page_Load(object sender, EventArgs e)
{
sqlcmd = conn.CreateCommand();
conn.Open();
sqlcmd.CommandText = "SELECT * FROM ip";
SqlDataAdapter ad = new SqlDataAdapter(sqlcmd);
DataSet set = new DataSet();
ad.Fill(set, "ip");
DataTable tb = set.Tables["ip"];
Response.Write("<Table Border='1'><Tr align='Center'>");
for (int i = 0; i < tb.Columns.Count; i++)
{
Response.Write("<Td>" + tb.Columns[i] + "</Td>");
}
Response.Write("</Tr>");
for (int i = 0; i < tb.Rows.Count; i++)
{
Response.Write("<Tr>");
for (int j = 0; j < tb.Columns.Count; j++)
{
Response.Write("<Td>" + tb.Rows[i][j] + "</Td>");
}
Response.Write("</Tr>");
}
Response.Write("</Table>");
}
}
}