如何发布网络小说,好看的玄幻小说,遮天

復(fù)制代碼代碼如下:

 
using System; 
using System.Data.OleDb; 
namespace ConsoleApplication1 
{ 
class Program 
{ 
static void Main(string[] args) 
{ 
Console.WriteLine(GetUserId("dnawo")); 
Console.ReadKey(); 
} 
/// summary> 
/// 獲取用戶Id 
/// /summary> 
/// param name="name">/param> 
/// returns>/returns> 
static int GetUserId(string name) 
{ 
using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\db1.mdb")) 
{ 
conn.Open(); 
using (OleDbCommand cmd = new OleDbCommand()) 
{ 
cmd.Connection = conn; 
cmd.CommandText = "select Id from UserTB where UserName='" + name + "'"; 
object val = cmd.ExecuteScalar(); 
if (val != null) 
return int.Parse(val.ToString()); 
else 
{ 
cmd.CommandText = string.Format("insert into UserTB(UserName) values('{0}')", name); 
cmd.ExecuteNonQuery(); 
return GetUserId(name); 
} 
} 
conn.Close(); 
} 
} 
} 
} 

經(jīng)測(cè)試，當(dāng)用戶不存在時(shí)，執(zhí)行上邊代碼后Access表中總會(huì)新增兩條一樣的記錄：

改用SQL Server數(shù)據(jù)庫(kù)不會(huì)有上述問(wèn)題，經(jīng)多次測(cè)試又發(fā)現(xiàn)，若在"return GetUserId(name);"處設(shè)置斷點(diǎn)，稍停一會(huì)也不會(huì)出現(xiàn)上述問(wèn)題。最終代碼修改如下運(yùn)行正常：

復(fù)制代碼代碼如下:

 
using System; 
using System.Data.OleDb; 
namespace ConsoleApplication1 
{ 
class Program 
{ 
static void Main(string[] args) 
{ 
Console.WriteLine(GetUserId("dnawo")); 
Console.ReadKey(); 
} 
/// summary> 
/// 獲取用戶Id 
/// /summary> 
/// param name="name">/param> 
/// returns>/returns> 
static int GetUserId(string name) 
{ 
int id = 0; 
using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\db1.mdb")) 
{ 
conn.Open(); 
using (OleDbCommand cmd = new OleDbCommand()) 
{ 
cmd.Connection = conn; 
cmd.CommandText = "select Id from UserTB where UserName='" + name + "'"; 
object val = cmd.ExecuteScalar(); 
if (val != null) 
id = int.Parse(val.ToString()); 
else 
{ 
cmd.CommandText = string.Format("insert into UserTB(UserName) values('{0}')", name); 
cmd.ExecuteNonQuery(); 
} 
} 
conn.Close(); 
} 
return id == 0 ? GetUserId(name) : id; 
} 
} 
} 

您可能感興趣的文章:

asp.net中獲取新增加記錄的ID Access版

標(biāo)簽：孝感自貢萊蕪朔州西雙版納常州信陽(yáng) 許昌

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《.NET中獲取Access新增記錄Id怪現(xiàn)象解決方法》，本文關(guān)鍵詞 .NET,中,獲取,Access,新增,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。

濮阳杆衣贸易有限公司

.NET中獲取Access新增記錄Id怪現(xiàn)象解決方法