saied_hacker
چهارشنبه 17 آذر 1389, 21:51 عصر
نمی دونم مشکل از کجاست فکر نم از دیتا بیسم باشه
web.config
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="MyConn"
connectionString="Data Source=localhost;Initial Catalog=CS_Data;User ID=sa;Password=123"
providerName="System.Data.SqlClient"
/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
namespace WebApplication_MyWebSite
{
public partial class HomePage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
//string constr = "Data Source=localhost;Initial Catalog=TEST;User ID=sa;Password=123";
//Data Base Connection -------- Using DataReader
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["MyConn"].ConnectionString);
try
{
Conn.Open();
SqlCommand ConnCMD = new SqlCommand("Select * Table_1", Conn);
SqlDataReader ConnDataReader = ConnCMD.ExecuteReader();
if (ConnDataReader.HasRows)
{
Label1.Text = string.Empty;
while (ConnDataReader.Read())
{
/*ListBox1.Items.Add(ConnDataReader["ID"].ToString());
ListBox1.Items.Add(ConnDataReader["UserName"].ToString());
ListBox1.Items.Add(ConnDataReader["Password"].ToString());
ListBox1.Items.Add("----------");*/
Label1.Text +=
"<b>Username: </b>"
+ ConnDataReader["UserName"].ToString()
+ "<br>"
+ "<b>Password: </b>"
+ ConnDataReader["ID"].ToString()
+ "<hr>";
}
ConnDataReader.Close();
}
}
catch
{
}
finally
{
Conn.Close();
}
}
}
}
عکس از دیتا بیس:
http://up.iranblog.com/images/d59hm7jmczndp5saze9y.jpg
web.config
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="MyConn"
connectionString="Data Source=localhost;Initial Catalog=CS_Data;User ID=sa;Password=123"
providerName="System.Data.SqlClient"
/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
namespace WebApplication_MyWebSite
{
public partial class HomePage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
//string constr = "Data Source=localhost;Initial Catalog=TEST;User ID=sa;Password=123";
//Data Base Connection -------- Using DataReader
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["MyConn"].ConnectionString);
try
{
Conn.Open();
SqlCommand ConnCMD = new SqlCommand("Select * Table_1", Conn);
SqlDataReader ConnDataReader = ConnCMD.ExecuteReader();
if (ConnDataReader.HasRows)
{
Label1.Text = string.Empty;
while (ConnDataReader.Read())
{
/*ListBox1.Items.Add(ConnDataReader["ID"].ToString());
ListBox1.Items.Add(ConnDataReader["UserName"].ToString());
ListBox1.Items.Add(ConnDataReader["Password"].ToString());
ListBox1.Items.Add("----------");*/
Label1.Text +=
"<b>Username: </b>"
+ ConnDataReader["UserName"].ToString()
+ "<br>"
+ "<b>Password: </b>"
+ ConnDataReader["ID"].ToString()
+ "<hr>";
}
ConnDataReader.Close();
}
}
catch
{
}
finally
{
Conn.Close();
}
}
}
}
عکس از دیتا بیس:
http://up.iranblog.com/images/d59hm7jmczndp5saze9y.jpg