Please help me for changing data table row value from dictionary

Question

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 <Eskisehir> 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;

}

Cenk Isik · Answer

I used it another event that gridview_RowDataBound and its worked I didt do another variance

Cenk Isik · Answer

thanks for your helps if i solved this problem i'm going to tell you :)

Vulpes · Answer

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 Isik · Answer

then there is one way that changing column type in the databases right?

Vulpes · Answer

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 Isik · Answer

While i set tmpSehir getting data from dictionary but dictionary working very well and some tmpSehir value is EskisehirIstanbulAntalya

Vulpes · Answer

Can you give me some examples of what tmpSehir does contain then?

Cenk Isik · Answer

tmpSehir doesn't contain empty stringCertainly there is another way to solve this problem i trying 2 days many another way but the result always same

Vulpes · Answer

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 Isik · Answer

I tried your advice but the code add 0 to my row i want to add tmpsehir value as string please help me

Vulpes · Answer

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;