在ASP.NET + Access中的大小写区分问题。
在ASP.NET + Access中的大小写区分问题。
(SELECT * FROM [mytable] WHERE [mycol]='abc'运行正常。)
SELECT * FROM [mytable] WHERE LOWER([mycol])='abc' 这行语句出现问题,请高手帮我看看。
(SELECT * FROM [mytable] WHERE [mycol]='abc'运行正常。)
SELECT * FROM [mytable] WHERE LOWER([mycol])='abc' 这行语句出现问题,请高手帮我看看。
...全文
请发表友善的回复…
发表回复
DBXP 2003-09-21
- 打赏
- 举报
没有人知道吗?
DBXP 2003-08-20
- 打赏
- 举报
各位兄弟姐妹,救命啊!
DBXP 2003-08-20
- 打赏
- 举报
private System.String UserConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + "\\a.mdb";
System.Data.OleDb.OleDbConnection MyConn = new System.Data.OleDb.OleDbConnection( this.UserConnectionString );
try
{
MyConn.Open();
}
catch( System.InvalidOperationException )
{
}
catch
{
throw;
}
try
{
System.Data.OleDb.OleDbCommand odc = new System.Data.OleDb.OleDbCommand();
odc.Connection = MyConn;
odc.CommandText = "SELECT * FROM [tab] WHERE LOWER([name]) = 'abc'";
System.Data.OleDb.OleDbDataAdapter odda = new System.Data.OleDb.OleDbDataAdapter( odc );
System.Data.DataSet ds = new System.Data.DataSet();
try
{
odda.Fill( ds, "LoginSystemLogConfig" );
}
catch
{
throw;
}
System.Data.DataRowCollection drc = ds.Tables["LoginSystemLogConfig"].Rows;
if( drc.Count > 0 )
{
MessageBox.Show(drc[0]["name"].ToString() + "," + drc[0]["value"].ToString());
}
else
{
MessageBox.Show(drc.Count.ToString());
}
}
catch(System.Exception e )
{MessageBox.Show(e.ToString());}
finally
{
MyConn.Close();
}
System.Data.OleDb.OleDbConnection MyConn = new System.Data.OleDb.OleDbConnection( this.UserConnectionString );
try
{
MyConn.Open();
}
catch( System.InvalidOperationException )
{
}
catch
{
throw;
}
try
{
System.Data.OleDb.OleDbCommand odc = new System.Data.OleDb.OleDbCommand();
odc.Connection = MyConn;
odc.CommandText = "SELECT * FROM [tab] WHERE LOWER([name]) = 'abc'";
System.Data.OleDb.OleDbDataAdapter odda = new System.Data.OleDb.OleDbDataAdapter( odc );
System.Data.DataSet ds = new System.Data.DataSet();
try
{
odda.Fill( ds, "LoginSystemLogConfig" );
}
catch
{
throw;
}
System.Data.DataRowCollection drc = ds.Tables["LoginSystemLogConfig"].Rows;
if( drc.Count > 0 )
{
MessageBox.Show(drc[0]["name"].ToString() + "," + drc[0]["value"].ToString());
}
else
{
MessageBox.Show(drc.Count.ToString());
}
}
catch(System.Exception e )
{MessageBox.Show(e.ToString());}
finally
{
MyConn.Close();
}
acewang 2003-08-20
- 打赏
- 举报
完整代码