关于datagrid

2003-08-18 04:32:19 123 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

DataGrid嵌套DataGrid DataGrid嵌套DataGrid ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 开发工具与关键技术： VS和C# 作者：李建杰撰写时间：2019年08月04日设置好页面： <GridGrid.Row="2"> &... 阅读详情

如何建立数据源(SQL)，数据绑定？
比如我datagrid的id是mygrid,SQL Server的名称是dn,database是js，表名是login

请问应该怎么写？请详细一点，谢谢各位了。

...全文

vs2010ActiveX使用DataGrid 1.在工具->选择工具箱->Com组件->选择->C:\Windows\System32\MSDATGRD.OCX打开。工具箱里就有DataGrid组件了，Microsoft DataGrid Control 6.0(SP6)(OLEDB) 2.在电脑上注册，点击电脑开始，输入cmd（或者附件->命令提示符），输入regsvr32 c:\Windows\System32\MSDATGRD.OCX 阅读详情

loveno1

.NET社区 62,272 成员 668,968 内容

+ 关注 + 加入社区

切换为时间正序

guoyan19811021 2003-08-18

打赏
举报

function DataSet GetDataset()

Dim myConn As String = "server=dn;database=js;uid=sa;pwd=sa;"
Dim conn As SqlConnection = New SqlConnection(myConn)

Dim SelectSql As String = "Select * From login"
Dim da As SqlDataAdapter = New SqlDataAdapter(SelectSql, conn)

Dim ds As DataSet = New DataSet()
da.Fill(ds, "MyTable")
Return ds
End Function

mygrid.DataSource=GetDataSet();
mygrid.DataBind();

loveno1 2003-08-18

打赏
举报

请问楼上几位是不是都是c#的？

loveno1 2003-08-18

打赏
举报

wayneliu(暴风骤雨)

你发的是C#的吧，请问VB应该修改哪些地方？

liq2025 2003-08-18

打赏
举报

prviate DataSet GetDataset()
{
public static string myConn = "server=服务器名称;database=js;uid=sa;pwd=sa;";
SqlConnection conn = new SqlConnection(myConn);
string SelectSql = "Select * From login";
SqlDataAdapter da = new SqlDataAdapter(SelectSql,conn);
DataSet ds = new DataSet();
da.Fill(ds,"MyTable");
return ds;
}

mygrid.DataSource=GetDataSet();
mygrid.DataBind();

chnking 2003-08-18

打赏
举报

public void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
string connstr = "server=dn;uid=sa;pwd=;database=js";
string sqlstr = "select * from login";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(sqlstr,connstr);
DataSet myDataSet = new DataSet();
mySqlDataAdapter.Fill(myDataSet,"table1");
mygrid.DataSource = myDataSet.Tables["table1"];
mygrid.DataBind();
}
}

chnking 2003-08-18

打赏
举报

loveno1 2003-08-18

打赏
举报

这段代码应该写在什么位置？

wayneliu 2003-08-18

打赏
举报

我这有个例子，你看看吧，很简单
html

<asp:datagrid id="MyDataGrid" style="Z-INDEX: 104; LEFT: 78px; POSITION: absolute; TOP: 30px" PageSize="5" runat="server" Width="545px" HeaderStyle-BackColor="#aaaadd" Font-Names="宋体" CellPadding="3" BorderWidth="1px" CssClass="td" AllowPaging="True" AutoGenerateColumns="False" DataKeyField="FirstName" AllowSorting="True" HorizontalAlign="Center" BackColor="#F0F0E8" BorderColor="Black" Font-Size="10pt" Height="226px">
<AlternatingItemStyle BackColor="LightCyan"></AlternatingItemStyle>
<ItemStyle Height="30px" BorderColor="LightGray" BackColor="WhiteSmoke"></ItemStyle>
<HeaderStyle Font-Bold="True" Height="30px" ForeColor="White" BorderColor="White" BackColor="#C04000"></HeaderStyle>
<FooterStyle Height="30px"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="LastName" HeaderText="LastName"></asp:BoundColumn>
<asp:BoundColumn DataField="FirstName" HeaderText="FirstName"></asp:BoundColumn>

</asp:datagrid>

cs

private void Page_Load(object sender, System.EventArgs e)
{

// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack )
{

BindGrid();

//SqlCommand scmd=null;

}
}
private DataSet GetProductData()
{
SqlConnection myConn = new SqlConnection("server=wayne;uid=sa;pwd=;database=Northwind");
string strSQL1="select LastName,FirstName from Employees";
//string strSQL2="select CategoryName,Description from Categories";
SqlDataAdapter Adapter1= new SqlDataAdapter(strSQL1, myConn);
//SqlDataAdapter Adapter2 = new SqlDataAdapter(strSQL2, myConn);
DataSet ds = new DataSet();
Adapter1.Fill(ds,"Employees");
//Adapter2.Fill(ds,"Categories");
return ds;
}

protected void BindGrid()
{
MyDataGrid.DataSource=GetProductData().Tables["Employees"].DefaultView;
//YourDataGrid.DataSource=GetProductData().Tables["Categories"].DefaultView;
MyDataGrid.DataBind();
//YourDataGrid.DataBind();

}

你改一改就行了

seesea125 2003-08-18

打赏
举报

public class myconnclass
{
public static readonly string connString = "data source=.;initial catalog=telrc;uid=sa;pwd=67890;";
public SqlDataReader ExecuteReader(string varsql)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand cmd = new SqlCommand(varsql,conn);
SqlDataReader myrd=cmd.ExecuteReader();
return myrd;
}
}

关于datagrid

相关推荐