110,569
社区成员
发帖
与我相关
我的任务
分享AAAAAAAAAAAAAAAAAAAAAAAAA?????????????????????
代码
<%@ Page language="c#" Codebehind="WebForm3.aspx.cs" AutoEventWireup="false" Inherits="Web9.WebForm3" %>
<%@import namespace="web9.class2"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm3</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
请输入国家名称
<asp:TextBox ID="txt_country" Runat="server"></asp:TextBox>
<asp:Button ID="btn" Runat="server" Text="search" OnClick="brn_Click"></asp:Button>
<asp:DataGrid ID="DataGrid1" Runat="server" BorderColor="Tan" BorderWidth="1px" BackColor="LightGoldenrodYellow"
CellPadding="2" GridLines="None" ForeColor="Black" Width="350px">
<SelectedItemStyle ForeColor="GhostWhite" BackColor="DarkSlateBlue"></SelectedItemStyle>
<AlternatingItemStyle BackColor="PaleGoldenrod"></AlternatingItemStyle>
<HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle>
<FooterStyle BackColor="Tan"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="CustomerID" HeaderText="客户编号"></asp:BoundColumn>
<asp:BoundColumn DataField="Address" HeaderText="地址"></asp:BoundColumn>
<asp:BoundColumn DataField="Companyname" HeaderText="公司名称"></asp:BoundColumn>
<asp:BoundColumn DataField="phone" HeaderText="电话"></asp:BoundColumn>
<asp:BoundColumn DataField="country" HeaderText="国家"></asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="DarkSlateBlue" BackColor="PaleGoldenrod"></PagerStyle>
</asp:DataGrid>
</form>
</body>
后台代码：
namespace Web9
{
/// <summary>
/// WebForm3 的摘要说明。
/// </summary>
public class WebForm3 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txt_country;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button btn;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btn.Click += new System.EventHandler(this.btn_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
目标就是要引用下成的文件class2.cs请问怎么写这个btn_Click
private void btn_Click(object sender, System.EventArgs e)
{
string Data=new Web9.Class2("server=localhost;User ID=sa; DataBase=Northwind;Password=vcdvcd");//???
string sqlstring="Select * from Customers where Country='"+txt_country.Text+"'";//?????????????
System.Data.DataTable dt=Data.data(sqlstring,"Customers");??????????
Data.bind(DataGrid1,"Customers");//???????????????
}
}
}
这是组件文件：我把它编译成DLL
using System;
using System.Data.SqlClient;
using System.Data;
namespace Web9
{
/// <summary>
/// Class2 的摘要说明。
/// </summary>
public class Class2
{
public SqlConnection conn;
public SqlCommand cmd;
public SqlDataAdapter ad;
public DataSet ds;
public DataTable tablename;
public System.Web.UI.WebControls.DataGrid DataGrid1;
public void New()
{
SqlConnection conn=new SqlConnection("server=localhost;User ID=sa; DataBase=Northwind;Password=vcdvcd");
conn.Open();
cmd.Connection=conn;
cmd.CommandText="";
ad.SelectCommand=cmd;
}
public void data()
{
ad.Fill(ds,"tablename");
DataGrid1.DataSource=ds.Tables["tablename"];
}
public void bind()
{
DataGrid1.DataSource=ds.Tables["tablename"];
DataGrid1.DataBind();
}
}
}
</HTML>
<%@ Page language="c#" Codebehind="WebForm3.aspx.cs" AutoEventWireup="false" Inherits="Web9.WebForm3" %>
<%@import namespace="web9.class2"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm3</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
请输入国家名称
<asp:TextBox ID="txt_country" Runat="server"></asp:TextBox>
<asp:Button ID="btn" Runat="server" Text="search" OnClick="brn_Click"></asp:Button>
<asp:DataGrid ID="DataGrid1" Runat="server" BorderColor="Tan" BorderWidth="1px" BackColor="LightGoldenrodYellow"
CellPadding="2" GridLines="None" ForeColor="Black" Width="350px">
<SelectedItemStyle ForeColor="GhostWhite" BackColor="DarkSlateBlue"></SelectedItemStyle>
<AlternatingItemStyle BackColor="PaleGoldenrod"></AlternatingItemStyle>
<HeaderStyle Font-Bold="True" BackColor="Tan"></HeaderStyle>
<FooterStyle BackColor="Tan"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="CustomerID" HeaderText="客户编号"></asp:BoundColumn>
<asp:BoundColumn DataField="Address" HeaderText="地址"></asp:BoundColumn>
<asp:BoundColumn DataField="Companyname" HeaderText="公司名称"></asp:BoundColumn>
<asp:BoundColumn DataField="phone" HeaderText="电话"></asp:BoundColumn>
<asp:BoundColumn DataField="country" HeaderText="国家"></asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="DarkSlateBlue" BackColor="PaleGoldenrod"></PagerStyle>
</asp:DataGrid>
</form>
</body>
后台代码：
namespace Web9
{
/// <summary>
/// WebForm3 的摘要说明。
/// </summary>
public class WebForm3 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txt_country;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button btn;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btn.Click += new System.EventHandler(this.btn_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
目标就是要引用下成的文件class2.cs请问怎么写这个btn_Click
private void btn_Click(object sender, System.EventArgs e)
{
string Data=new Web9.Class2("server=localhost;User ID=sa; DataBase=Northwind;Password=vcdvcd");//???
string sqlstring="Select * from Customers where Country='"+txt_country.Text+"'";//?????????????
System.Data.DataTable dt=Data.data(sqlstring,"Customers");??????????
Data.bind(DataGrid1,"Customers");//???????????????
}
}
}
这是组件文件：我把它编译成DLL
using System;
using System.Data.SqlClient;
using System.Data;
namespace Web9
{
/// <summary>
/// Class2 的摘要说明。
/// </summary>
public class Class2
{
public SqlConnection conn;
public SqlCommand cmd;
public SqlDataAdapter ad;
public DataSet ds;
public DataTable tablename;
public System.Web.UI.WebControls.DataGrid DataGrid1;
public void New()
{
SqlConnection conn=new SqlConnection("server=localhost;User ID=sa; DataBase=Northwind;Password=vcdvcd");
conn.Open();
cmd.Connection=conn;
cmd.CommandText="";
ad.SelectCommand=cmd;
}
public void data()
{
ad.Fill(ds,"tablename");
DataGrid1.DataSource=ds.Tables["tablename"];
}
public void bind()
{
DataGrid1.DataSource=ds.Tables["tablename"];
DataGrid1.DataBind();
}
}
}
</HTML>
...全文
请发表友善的回复…
发表回复
Firestone2003 2006-07-09
- 打赏
- 举报
Web9.Class2这个是自己定义的，看错了
Firestone2003 2006-07-09
- 打赏
- 举报
你看得是别人写的代码吧
Data应该属于自己定义的类，DotNet没有的
Data应该属于自己定义的类，DotNet没有的
feifeiyaqi 2006-07-09
- 打赏
- 举报
private void btn_Click(object sender, System.EventArgs e)
{
string Data=new Web9.Class2("server=localhost;User ID=sa; DataBase=Northwind;Password=vcdvcd");//???
string sqlstring="Select * from Customers where Country='"+txt_country.Text+"'";//?????????????
System.Data.DataTable dt=Data.data(sqlstring,"Customers");??????????
Data.bind(DataGrid1,"Customers");//???????????????
}
这怎 么写啊
{
string Data=new Web9.Class2("server=localhost;User ID=sa; DataBase=Northwind;Password=vcdvcd");//???
string sqlstring="Select * from Customers where Country='"+txt_country.Text+"'";//?????????????
System.Data.DataTable dt=Data.data(sqlstring,"Customers");??????????
Data.bind(DataGrid1,"Customers");//???????????????
}
这怎 么写啊
