How do I read data from sql query and insert the result into a ListDictionary?
hi,
i have table looking this:
userid uniqueidentifier unchecked
firstname nchar(20) unchecked
lastname nchar(20) unchecked
birthdate datetime unchecked
address nvarchar(100) unchecked
mobile nchar(12) unchecked
city nchar(20) unchecked
country nchar(20) unchecked
username nchar(20) checked
i can insert data , update not fetch 1 row.
i have 1 subroutine called getuserfromdb(string user).
it supposed return listdictonary of user request. i.e 1 row of table.
the problem userid uniqueidentifier (not allowed change this) , sqldatareader not type.
when execution comes line while (reader.read()) fowwloing exception:
[system.data.sqlclient.sqlexception] = {"conversion failed when converting character string uniqueidentifier."}
how can work around problem?
here code:
using (sqlconnection mysqlconnection = new sqlconnection(connectionstring))
{
sqlcommand mysqlcommand = new sqlcommand(querystring, mysqlconnection);
mysqlcommand.connection.open();
sqldatareader reader = mysqlcommand.executereader();
listdictionary dicta = new listdictionary();
while (reader.read())
{
for (int lp = 0; lp < reader.fieldcount; lp++)
{
dicta.add(reader.getname(lp), reader.getvalue(lp));
}
}
mysqlconnection.close();
return dicta;
}
br mat
i have table looking this:
userid uniqueidentifier unchecked
firstname nchar(20) unchecked
lastname nchar(20) unchecked
birthdate datetime unchecked
address nvarchar(100) unchecked
mobile nchar(12) unchecked
city nchar(20) unchecked
country nchar(20) unchecked
username nchar(20) checked
i can insert data , update not fetch 1 row.
i have 1 subroutine called getuserfromdb(string user).
it supposed return listdictonary of user request. i.e 1 row of table.
the problem userid uniqueidentifier (not allowed change this) , sqldatareader not type.
when execution comes line while (reader.read()) fowwloing exception:
[system.data.sqlclient.sqlexception] = {"conversion failed when converting character string uniqueidentifier."}
how can work around problem?
here code:
using (sqlconnection mysqlconnection = new sqlconnection(connectionstring))
{
sqlcommand mysqlcommand = new sqlcommand(querystring, mysqlconnection);
mysqlcommand.connection.open();
sqldatareader reader = mysqlcommand.executereader();
listdictionary dicta = new listdictionary();
while (reader.read())
{
for (int lp = 0; lp < reader.fieldcount; lp++)
{
dicta.add(reader.getname(lp), reader.getvalue(lp));
}
}
mysqlconnection.close();
return dicta;
}
br mat
fault found.
connectionstring poining old db same name different data.
br mat
Visual Studio Languages , .NET Framework > Visual C#
Comments
Post a Comment