去官网下载freetextbox
增加第三方选项卡 添加引用
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1.WebForm1" %>
<%@ Register assembly="FreeTextBox" namespace="FreeTextBoxControls" tagprefix="FTB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<FTB:FreeTextBox ID="FreeTextBox1" runat="server">
</FTB:FreeTextBox>
<br />
<asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="Button" />
<asp:Button ID="Button2" runat="server" οnclick="Button2_Click" Text="Button" />
<asp:Button ID="Button3" runat="server" οnclick="Button3_Click" Text="调取"
Width="67px" />
</div>
</form>
</body>
</html>
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.Data;
namespace WebApplication1
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str = "data source=****B2s";
SqlConnection myConnection = new SqlConnection(str);
myConnection.Open();
SqlCommand myCommand = new SqlCommand("select * from t001", myConnection);
SqlDataAdapter Adapter = new SqlDataAdapter();
Adapter.SelectCommand = myCommand;
DataSet myDs = new DataSet();
Adapter.Fill(myDs);
Response.Write("<h3>用使用DataSet显示CustomerInfo数据表内容</h3>");
Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
DataTable myTable = myDs.Tables[0];
Response.Write("<tr bgcolor=yellow>");
foreach (DataColumn myColumn in myTable.Columns)
{
Response.Write("<td>" + myColumn.ColumnName + "</td>");
}
Response.Write("</tr>");
foreach (DataRow myRow in myTable.Rows)
{
Response.Write("<tr>");
foreach (DataColumn myColumn in myTable.Columns)
{
Response.Write("<td>" + myRow[myColumn] + "</td>");
}
Response.Write("</tr>");
}
Response.Write("</table>");
myConnection.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = FreeTextBox1.Text;
Response.Write(str);
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection myConn = new SqlConnection("data source=218.*");
SqlCommand myCmd = new SqlCommand("insert into t000(text) values('" + FreeTextBox1.Text + "')", myConn);
myConn.Open();
myCmd.ExecuteNonQuery();
myConn.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection myConn = new SqlConnection("data source=218*");
SqlCommand myCmd = new SqlCommand("select * from t000", myConn);
myConn.Open();
SqlDataReader sdr = myCmd.ExecuteReader();
while (sdr.Read())
{ FreeTextBox1.Text += sdr["text"].ToString(); }
sdr.Close();
myConn.Close();
}
}
}