sql query是什么意思 VB.NET用ExecuteNonQuery向SQL數(shù)據(jù)庫中插入數(shù)據(jù)的問題?
VB.NET用ExecuteNonQuery向SQL數(shù)據(jù)庫中插入數(shù)據(jù)的問題?給你i個例子:Dim in u m As New SqlCommand in u m.Connection=sql u co
VB.NET用ExecuteNonQuery向SQL數(shù)據(jù)庫中插入數(shù)據(jù)的問題?
給你i個例子:
Dim in u m As New SqlCommand in u m.Connection=sql u conn in u m.CommandText=“插入ryb(uname,bmfz,upass,lv,ishead,isadmin,dd,bm0)值(@uname,@bmfz,@upass,@lv,@ishead,@isadmin,@dd,@bm0)”in u m。參數(shù).AddWithValue(“@uname”,tu)以百萬計。參數(shù).AddWithValue(“@bmfz”,tu b)單位為米。參數(shù).AddWithValue(“@bm0”,tu bm0)單位為米。參數(shù).AddWithValue(“@upass”,“1”)單位為米。參數(shù).AddWithValue(“@lv”,2)單位為米。參數(shù).AddWithValue(“@ishead”,0)單位為米。參數(shù).AddWithValue(“@isadmin”,0)以百萬計。參數(shù).AddWithValue(“@dd”,tu d)sql_連接打開()在.ExecuteNonQuery()sql中_關閉連接()