第一个问题
Dim oConn As New OracleConnection(G_strKF)
Dim oRd As OracleDataReader
Dim oCmd As New OracleCommand
If Me.oConn.State = ConnectionState.Closed Then
Me.oConn.Open()
End If oCmd.Connection = Me.oConn
oCmd.CommandText = "select * from your_table"
oRd = oCmd.ExecuteReader
While oRd.Read()
要赋值的内容= oRd.Item(0)
End While
oRd.Close()
oCmd.Dispose()
oConn.Close()
oConn.Dispose()
Dim oConn As New OracleConnection(G_strKF)
Dim oRd As OracleDataReader
Dim oCmd As New OracleCommand
If Me.oConn.State = ConnectionState.Closed Then
Me.oConn.Open()
End If oCmd.Connection = Me.oConn
oCmd.CommandText = "select * from your_table"
oRd = oCmd.ExecuteReader
While oRd.Read()
要赋值的内容= oRd.Item(0)
End While
oRd.Close()
oCmd.Dispose()
oConn.Close()
oConn.Dispose()
判断如果用户没有输入密码,不执行保存数据库操作就是
给出提示:
Dim strScript As String
strScript = "<script language='javascript'>alert(""密码不能为空"");</script>"
response.write (strScript)
我不懂c# 不过你说的可以用验证控件
requiredfieldvalidator 判断不为空
validationsummary 弹出对话框显示错误
比如
Dim oConn As New OracleConnection(G_strKF)
改为
OracleConnection oConn=New OracleConnection(G_strKF)
其它的你参照一下吧.
string sConn = "数据库联军字符串";
SqlConnection conn = new SqlConnection(sConn);
SqlCommand cmd = new SqlCommand("Select * From TableName",conn);
try
{
SqlDataReader dr = cmd.ExecuteReader();
while(dr.read())
{
string sValue = dr["字段名"].toString();
this.RegisterStartupScript("jsShowValue","<script language=javascript>alert('" + sValue + "')</script>");
}
dr.close();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.close();
}
{
this.RegisterStartupScript("jsNote","<script language=javascript>alert('用户名和密码不能为空!')</script>");
return;
}
this.RegisterStartupScript("jsShowValue","<script language=javascript>alert('" + sValue + "')</script>");,,,,上面这个不懂!