1。SQLSERVER不存在或访问被拒绝的错
把你的服务重起一下
2。给你一个例子
<html>
<head> <script language="VB" runat="server"> Sub Page_Load(sender As Object, e As EventArgs) Dim numrows As Integer
Dim numcells As Integer
Dim i As Integer = 0
Dim j As Integer = 0
Dim Row As Integer = 0
Dim r As HtmlTableRow
Dim c As HtmlTableCell
' Generate rows and cells
numrows = CInt(Select1.Value)
numcells = CInt(Select2.Value)
For j = 0 To numrows-1
r = new HtmlTableRow()
If (row Mod 2 <> 0) Then
r.BgColor = "Gainsboro"
End If
row += 1
For i = 0 To numcells-1
c = new HtmlTableCell()
c.Controls.Add(new LiteralControl("row " & j & ", cell " & i))
r.Cells.Add(c)
Next i
Table1.Rows.Add(r)
Next j
End Sub </script></head>
<body> <h3><font face="Verdana">HtmlTable Example</font></h3> <form runat=server>
<font face="Verdana" size="-1">
<p> <table id="Table1" CellPadding=5 CellSpacing=0 Border="1" runat="server" />
<p>
Table rows:
<select id="Select1" runat="server">
<option Value="1">1</option>
<option Value="2">2</option>
<option Value="3">3</option>
<option Value="4">4</option>
<option Value="5">5</option>
</select> <br>
Table cells:
<select id="Select2" runat="server">
<option Value="1">1</option>
<option Value="2">2</option>
<option Value="3">3</option>
<option Value="4">4</option>
<option Value="5">5</option>
</select>
<input type="submit" value="Generate Table" runat="server"> </font>
</form></body>
</html>
把你的服务重起一下
2。给你一个例子
<html>
<head> <script language="VB" runat="server"> Sub Page_Load(sender As Object, e As EventArgs) Dim numrows As Integer
Dim numcells As Integer
Dim i As Integer = 0
Dim j As Integer = 0
Dim Row As Integer = 0
Dim r As HtmlTableRow
Dim c As HtmlTableCell
' Generate rows and cells
numrows = CInt(Select1.Value)
numcells = CInt(Select2.Value)
For j = 0 To numrows-1
r = new HtmlTableRow()
If (row Mod 2 <> 0) Then
r.BgColor = "Gainsboro"
End If
row += 1
For i = 0 To numcells-1
c = new HtmlTableCell()
c.Controls.Add(new LiteralControl("row " & j & ", cell " & i))
r.Cells.Add(c)
Next i
Table1.Rows.Add(r)
Next j
End Sub </script></head>
<body> <h3><font face="Verdana">HtmlTable Example</font></h3> <form runat=server>
<font face="Verdana" size="-1">
<p> <table id="Table1" CellPadding=5 CellSpacing=0 Border="1" runat="server" />
<p>
Table rows:
<select id="Select1" runat="server">
<option Value="1">1</option>
<option Value="2">2</option>
<option Value="3">3</option>
<option Value="4">4</option>
<option Value="5">5</option>
</select> <br>
Table cells:
<select id="Select2" runat="server">
<option Value="1">1</option>
<option Value="2">2</option>
<option Value="3">3</option>
<option Value="4">4</option>
<option Value="5">5</option>
</select>
<input type="submit" value="Generate Table" runat="server"> </font>
</form></body>
</html>
//加入验证控件
if (dt.Rows[i].ItemArray[cellCtr+11].ToString()=="int")
{
System.Web.UI.WebControls.RangeValidator rvValidate = new RangeValidator();
rvValidate.ID="rv"+i+","+cellCtr;
rvValidate.Type=ValidationDataType.Integer;
rvValidate.ControlToValidate=textbox.ID;//指定需要验证的控件的ID。这个控件是在代码页中动态生成的。
rvValidate.MaximumValue="10";
rvValidate.MinimumValue="1";
rvValidate.ErrorMessage="aaaa";
rvValidate.Display=ValidatorDisplay.Dynamic;
tCell1.Controls.Add(rvValidate);
}
TextBox tbAllocate = new TextBox();
tbAllocate.DataBinding += new EventHandler(this.BindDataAllocate);
tbAllocate.ID = strAllColumn;
tbAllocate.Width=70;
tbAllocate.BackColor=Color.LightGreen; Table Display=new Table();
//add a row
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.Controls.Add(tbTarget);
tr.Controls.Add(td);
Display.Controls.Add(tr); container.Controls.Add(Display);
RangeValidator cvTarget=new RangeValidator();
cvTarget.Text="请输入数字(0-100000000)!";
cvTarget.Type=ValidationDataType.Integer;
cvTarget.MinimumValue="0";
cvTarget.MaximumValue ="100000000";
cvTarget.ControlToValidate=tbTarget.ID;
cvTarget.Display=ValidatorDisplay.None;
cvTarget.ErrorMessage="请输入数字(0-100000000)!";
container.Controls.Add(cvTarget);
TextBox tbTarget = new TextBox();
tbTarget.DataBinding += new EventHandler(this.BindDataTarget);
tbTarget.ID = strTargertColumn;
tbTarget.Width=70;
tbTarget.BackColor=Color.LightPink;
2、生成控件的容器Display并装入tbTarget。
Table Display=new Table();
//add a row
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.Controls.Add(tbTarget);
tr.Controls.Add(td);
Display.Controls.Add(tr);
3、生成tbTarget的验证控件cvTarget并装入Display。(Control container)
container.Controls.Add(Display); //关键
RangeValidator cvTarget=new RangeValidator();
cvTarget.Text="请输入数字(0-100000000)!";
cvTarget.Type=ValidationDataType.Integer;
cvTarget.MinimumValue="0";
cvTarget.MaximumValue ="100000000";
cvTarget.ControlToValidate=tbTarget.ID;
cvTarget.Display=ValidatorDisplay.None;
cvTarget.ErrorMessage="请输入数字(0-100000000)!";
container.Controls.Add(cvTarget);
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace SaleSys.Web.baseInfo
{
/// <summary>
/// ValidateEditItem 的摘要说明。
/// </summary>
public class ValidateEditItem : ITemplate
{
private string strTargertColumn;
private string strAllColumn;
public ValidateEditItem(string column1,string column2)
{
this.strTargertColumn=column1;
this.strAllColumn=column2;
} public void InstantiateIn(Control container)
{
TextBox tbTarget = new TextBox();
tbTarget.DataBinding += new EventHandler(this.BindDataTarget);
tbTarget.ID = strTargertColumn;
tbTarget.Width=70;
tbTarget.BackColor=Color.LightPink; TextBox tbAllocate = new TextBox();
tbAllocate.DataBinding += new EventHandler(this.BindDataAllocate);
tbAllocate.ID = strAllColumn;
tbAllocate.Width=70;
tbAllocate.BackColor=Color.LightGreen; Table Display=new Table();
//add a row
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.Controls.Add(tbTarget);
tr.Controls.Add(td);
Display.Controls.Add(tr);
//add a row
tr=new TableRow();
td = new TableCell();
td.Controls.Add(tbAllocate);
tr.Controls.Add(td);
Display.Controls.Add(tr); container.Controls.Add(Display);
//**********************************************************20030807 wxl**********
// CompareValidator cvTarget=new CompareValidator();
// cvTarget.Text="请输入数字!";
// cvTarget.Operator=ValidationCompareOperator.DataTypeCheck;
// cvTarget.Type=ValidationDataType.Integer;
// cvTarget.ControlToValidate=tbTarget.ID;
// cvTarget.Display=ValidatorDisplay.None;
// cvTarget.ErrorMessage="请输入数字!";
RangeValidator cvTarget=new RangeValidator();
cvTarget.Text="请输入数字(0-100000000)!";
cvTarget.Type=ValidationDataType.Integer;
cvTarget.MinimumValue="0";
cvTarget.MaximumValue ="100000000";
cvTarget.ControlToValidate=tbTarget.ID;
cvTarget.Display=ValidatorDisplay.None;
cvTarget.ErrorMessage="请输入数字(0-100000000)!";
container.Controls.Add(cvTarget);// CompareValidator cvAllocate=new CompareValidator();
// cvAllocate.Text="请输入数字!";
// cvAllocate.Operator=ValidationCompareOperator.DataTypeCheck;
// cvAllocate.Type=ValidationDataType.Integer;
// cvAllocate.ControlToValidate=tbAllocate.ID;
// cvAllocate.Display=ValidatorDisplay.None;
// cvAllocate.ErrorMessage="请输入数字!";
RangeValidator cvAllocate=new RangeValidator();
cvAllocate.Text="请输入数字(0-100000000)!";
cvAllocate.Type=ValidationDataType.Integer;
cvAllocate.MinimumValue="0";
cvAllocate.MaximumValue="100000000";
cvAllocate.ControlToValidate=tbAllocate.ID;
cvAllocate.Display=ValidatorDisplay.None;
cvAllocate.ErrorMessage="请输入数字(0-100000000)!";
//**********************************************************************
container.Controls.Add(cvAllocate); } public void BindDataTarget(object sender, EventArgs e)
{
TextBox tbTarget = (TextBox) sender;
DataGridItem container = (DataGridItem)tbTarget.NamingContainer;
tbTarget.Text = ((DataRowView) container.DataItem)[strTargertColumn].ToString();
} public void BindDataAllocate(object sender, EventArgs e)
{
TextBox tbAllocate = (TextBox) sender;
DataGridItem container = (DataGridItem)tbAllocate.NamingContainer;
tbAllocate.Text = ((DataRowView) container.DataItem)[strAllColumn].ToString();
}
}}
System.Web.UI.WebControls.TextBox textbox = new TextBox();
textbox.ID=i+","+cellCtr;
textbox.Width=55;
tCell1.Controls.Add(textbox);
//加入验证控件
if (dt.Rows[i].ItemArray[cellCtr+11].ToString()=="int")
{
Control container=new Control();
container.Controls.Add(textbox);
System.Web.UI.WebControls.RangeValidator rvValidate = new RangeValidator();
rvValidate.Type=ValidationDataType.Integer;
rvValidate.ControlToValidate=textbox.ID;
rvValidate.MaximumValue="100000000";
rvValidate.MinimumValue="0";
rvValidate.Display=ValidatorDisplay.Dynamic;
rvValidate.ErrorMessage="请输入数字(0-100000000)!";
container.Controls.Add(rvValidate);
}