sql query是什么意思 VB.NET用ExecuteNonQuery向SQL數(shù)據(jù)庫(kù)中插入數(shù)據(jù)的問(wèn)題?
VB.NET用ExecuteNonQuery向SQL數(shù)據(jù)庫(kù)中插入數(shù)據(jù)的問(wèn)題?給你i個(gè)例子:Dim in u m As New SqlCommand in u m.Connection=sql u co
VB.NET用ExecuteNonQuery向SQL數(shù)據(jù)庫(kù)中插入數(shù)據(jù)的問(wèn)題?
給你i個(gè)例子:
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)以百萬(wàn)計(jì)。參數(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)以百萬(wàn)計(jì)。參數(shù).AddWithValue(“@dd”,tu d)sql_連接打開(kāi)()在.ExecuteNonQuery()sql中_關(guān)閉連接()