Data type mismatch in criteria expression.

Posted Date: 04 Nov 2009 Posted By: net Member Level: Silver Points: 1 Responses: 1

hi,
i am doing project in asp.net with c# in windows applications with backend ms access,
i am select the values for this i am using this class file:

public OleDbDataReader GetDataBase(string Commt)
{
try
{

OleDbConnection ConnObj = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\Finance.mdb");
OleDbCommand Commtobj = new OleDbCommand(Commt, ConnObj);
if (ConnObj.State == ConnectionState.Closed)
{
ConnObj.Open();
}
OleDbDataReader Reader = Commtobj.ExecuteReader();
return Reader;
}
catch (OleDbException ex)
{

throw ex;

}

}

my coding:

string s1 = "Select AccountNo,UserName from LendersInformation where AccountNo='" + dd_userid.Text + "'";
OleDbDataReader dr = con.GetDataBase(s1);
while (dr.Read())
{
lbl_username.Text = dr[1].ToString();

}
dr.Close();
my error:
Data type mismatch in criteria expression.

Responses

Author: Nikhil Gaur 04 Nov 2009

Member Level: Diamond

Rating:

Points: 3

please check that GetDatabase returns Datareder objects or not. Because this cause a problem is it doesn't return reader object.

Join this campus group
http://www.dotnetspider.com/sites/637/-ecb-aspdotnet.aspx

Thanks & Regards
NIks
My Software and Web Development Experience

Post Reply

You must Sign In to post a response.

	Next : Grid Paging Problem
	Previous : Download
	Return to Discussion Forum
	Post New Message
	Category: ASP.NET

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use