Please help me for changing data table row value from dictionary

Cenk Isik

14y5.7k.NET

I have a dictionary I want to read this as for that my data table row value. I'm reading dictionary and data table row value but i cant change row value that coming dictionary value

exception is =Input string was not in a correct format.Couldn't store in IL Column. Expected type is Int16.

I fill data table from database and IL column type smallint i dont want to change column type nvarchar or anything else . How i can solve this problem .

My Code Here;

public DataTable getData(string komut)

{

DataTable dt = new DataTable();

cnn = connect.GetConnection();

sorgu = komut;

cmd = new SqlCommand(sorgu, cnn);

adap = new SqlDataAdapter(cmd);

adap.Fill(dt);

for (int i = 0; i < dt.Rows.Count; i++)

{

if (dt.Columns["IL"].ColumnName == "IL")

{

string tmpSehir;

iller.TryGetValue(dt.Rows[i]["IL"].ToString(), out tmpSehir);

dt.Rows[i]["IL"] = tmpSehir;

}

return dt;

}

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cenk Isik14y ago
I used it another event that gridview_RowDataBound and its worked I didt do another variance
Cenk Isik14y ago
thanks for your helps if i solved this problem i'm going to tell you :)
Vulpes14y ago
Well, you could change the column type in the database from smallint to nvarchar, but you said in your opening post that you didn't want to do that. It would in any case upset any integers which you already have in there.

Another possibility would be store your city names using an integer code - if there are only a limited number of them you could define a Dictionary or an enum to help with this.
Cenk Isik14y ago
then there is one way that changing column type in the databases right?
Vulpes14y ago
Yes, but those values are all textual strings.

There's no way they can converted to integers which is why Int16.TryParse is returning zero for them.
Cenk Isik14y ago
While i set tmpSehir getting data from dictionary but dictionary working very well and some tmpSehir value is "Eskisehir","Istanbul",Antalya
Vulpes14y ago
Can you give me some examples of what tmpSehir does contain then?
Cenk Isik14y ago
tmpSehir doesn't contain empty string,Certainly there is another way to solve this problem i trying 2 days many another way but the result always same
Vulpes14y ago
If it's adding 0 then, unless tmpSehir happens to be "0", that means that whatever tmpSehir contains can't be parsed to an Int16 (i.e. a small integer between plus or minus 64K).

Possible reasons include it being an empty string, containing a decimal point or thousand separator or being out of range.

I'd try printing out some values of tmpSehir to see what it actually contains.
Cenk Isik14y ago
I tried your advice but the code add 0 to my row i want to add tmpsehir value as string please help me
Vulpes14y ago
Try instead:

string tmpSehir;
iller.TryGetValue(dt.Rows[i]["IL"].ToString(), out tmpSehir);
short tmpShort;
Int16.TryParse(tmpSehir, out tmpShort);
dt.Rows[i]["IL"] = tmpShort;