bahar1370
جمعه 14 بهمن 1390, 23:12 عصر
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace WebApplication6
{
public class sd1
{
private string con1;
private SqlConnection con;
private SqlDataAdapter da;
private DataSet ds;
public sd1(string con)
{
con1 = con;
}
public DataSet get()
{
con = new SqlConnection(con1);
da = new SqlDataAdapter("select _id_user,_name_user from _user", con);
ds = new DataSet();
ds = new DataSet();
da.Fill(ds);
return ds;
}
}
}
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1">
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="get"
TypeName="WebApplication6.sd1" onobjectcreating="ObjectDataSource1_ObjectCreating"
></asp:ObjectDataSource>
protected void ObjectDataSource1_ObjectCreating(object sender, ObjectDataSourceEventArgs e)
{
e.ObjectInstance = new WebApplication6.sd1("Data Source=.;Initial Catalog=_social_network_db;Integrated Security=True");
}