fakhravari
جمعه 10 شهریور 1391, 21:41 عصر
سوال عجیبی کردین ولی فکر کنم همچین چیزی بخواهین.
ALTER PROCEDURE Link_GetList
AS
begin
select * from Link
end
public DataTable GetList()
{
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("Link_GetList", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.Add("@LinkID", SqlDbType.Int).Value = LinkID;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
this.Name = dt.Rows[0]["Name"].ToString();
this.Address = dt.Rows[0]["Address"].ToString();
this.AcceptLink = Convert.ToBoolean(dt.Rows[0]["AcceptLink"]);
this.LinkID = Int32.Parse(dt.Rows[0]["LinkID"].ToString());
}
else
{
lasteror = "موردی یافت نشد";
}
return dt;
}
با استفا ده از دیتاسورس
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="LinkID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="LinkID" HeaderText="LinkID" InsertVisible="False"
ReadOnly="True" SortExpression="LinkID" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Address" HeaderText="Address"
SortExpression="Address" />
<asp:CheckBoxField DataField="AcceptLink" HeaderText="AcceptLink"
SortExpression="AcceptLink" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DBCenter %>"
SelectCommand="Link_GetList" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
با دیتاتیبل
public DataTable GetList()
{
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("select * from Link ", con);
cmd.CommandType = CommandType.Text;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
this.Name = dt.Rows[0]["Name"].ToString();
this.Address = dt.Rows[0]["Address"].ToString();
this.AcceptLink = Convert.ToBoolean(dt.Rows[0]["AcceptLink"]);
this.LinkID = Int32.Parse(dt.Rows[0]["LinkID"].ToString());
}
else
{
lasteror = "موردی یافت نشد";
}
return dt;
}
GridView1.DataSource = GetList();
GridView1.DataBind();