这是我以前写的一个,仅供参考 Dim MyConnection As SqlConnection = New SqlConnection("server=czy;database=TimeManager;Trusted_Connection=yes") Dim MyCommand As SqlCommand = New SqlCommand("select * from TimeMain",MyConnection) MyCommand.CommandType=CommandType.StoredProcedure MyCommand.CommandText="sp_AddTopic" MyCommand.Parameters.Add(New SqlParameter("@Topic",SqlDbType.NVarChar,50)) MyCommand.Parameters("@Topic").Value=strTopic.Value MyCommand.Parameters.Add(New SqlParameter("@UserId",SqlDbType.Char,5)) MyCommand.Parameters("@UserId").Value=strUserId.Value MyCommand.Parameters.Add(New SqlParameter("@Description",SqlDbType.NVarChar,120)) MyCommand.Parameters("@Description").Value=strDescription.Value
MyCommand.Connection.Open() Try MyCommand.ExecuteNonQuery() Message.InnerHtml="" catch Exp As SQLException if Exp.Number=2627 Message.InnerHtml="Can't Input the same key!" else Message.InnerHtml="no 2627" end if Message.Style("color")="red" End Try MyCommand.Connection.Close() MyConnection.Close()
我只要用asp.net操作Sql Server就可以了
SqlConnection myConnection = new SqlConnection("server=maintek29;uid=callcenter;PWD=ccenter;database=mispub");
SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
myCommand.Parameters.Add(new SqlParameter("@workid",SqlDbType.NVarChar,10));
string workid=AddWorkidTextBox.Text.ToString();
myCommand.Parameters["@workid"].Value=workid;
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
if(dr.Read())
{
.....
}
dr.Close();
myConnection.Close();
Dim MyConnection As SqlConnection = New SqlConnection("server=czy;database=TimeManager;Trusted_Connection=yes") Dim MyCommand As SqlCommand = New SqlCommand("select * from TimeMain",MyConnection)
MyCommand.CommandType=CommandType.StoredProcedure
MyCommand.CommandText="sp_AddTopic"
MyCommand.Parameters.Add(New SqlParameter("@Topic",SqlDbType.NVarChar,50))
MyCommand.Parameters("@Topic").Value=strTopic.Value
MyCommand.Parameters.Add(New SqlParameter("@UserId",SqlDbType.Char,5))
MyCommand.Parameters("@UserId").Value=strUserId.Value
MyCommand.Parameters.Add(New SqlParameter("@Description",SqlDbType.NVarChar,120))
MyCommand.Parameters("@Description").Value=strDescription.Value
MyCommand.Connection.Open() Try
MyCommand.ExecuteNonQuery()
Message.InnerHtml=""
catch Exp As SQLException if Exp.Number=2627
Message.InnerHtml="Can't Input the same key!"
else
Message.InnerHtml="no 2627"
end if
Message.Style("color")="red" End Try
MyCommand.Connection.Close()
MyConnection.Close()