string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=******.mdb";
string strSQL = "SELECT * FROM ***** where username=textbox1.text";
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
objAdapter.Fill(objDataSet, 表名);
if objDataSet.******=0 (如果objDataSet里数据集个数为0,对不起,我忘了怎么写这句话了) then response.write("没有这条记录")
else
。
end if
strConnection += @"Data Source=******.mdb";
string strSQL = "SELECT * FROM ***** where username=textbox1.text";
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
objAdapter.Fill(objDataSet, 表名);
if objDataSet.******=0 (如果objDataSet里数据集个数为0,对不起,我忘了怎么写这句话了) then response.write("没有这条记录")
else
。
end if
cmdSQL.Commandtext = "Select * From login,addbook where login.userid=addbook.addno and userid='" & txtUserid.text & "' And password='" & txtPassword.text & "'"
Dim drdReader As SqlDataReader = cmdSQL.ExecuteReader()
if(drdReader.Read()=true) then
textbox.text=drdReader["usertype"].ToString()
end if
end sub
strConnection += "Data Source=******.mdb";
string strSQL = "SELECT * FROM ***** where username=textbox1.Text.Replace("'","''")";
OleDbDataReader reader;
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand comm=new OleDbCommand(strSql,objConnection);
try{
objConnection.Open();
reader=comm.ExecuteReader();
if(reader.Read())
//已经有该帐号
else
//可以注册
reader.Close();
}
catch(OleDbException e)
{ //process the error
}
finally
{objConnection.Close();
}
textbox.text=drdReader["usertype"].ToString()
else
textbox.text="没有这条记录"
end if
@id Varchar(50)
as
decalre @tmp varchar(50)
select @tmp=name from table1 where id=@id
if @@ROWCOUNT>=1
select '没有记录'
else
select @tmp
你编程几个月了?