Cannot implicitly convert type sring to string[]...

keshu keshvala

error ----Cannot implicitly convert type sring to string[]...

Hi,
I am getting above error .
my code is...

string [] fksprd_id;

cmd = new sqlcommand("select id from table1 where name = ' "+txt.text+" ' ",con);
da = new SqlDataAdapter(cmd);
                ds = new DataSet();
                da.Fill(ds);
                cmd.Dispose();

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    fksprd_id =ds.Tables[0].Rows[i][0].ToString();
                }

i just want to store id in this array but iot shows error like

Cannot implicitly convert type sring to string[]...

..
Thanks in advance..

2 Replies

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

Sam Hobbs16y ago
I think you just have to change:

fksprd_id =ds.Tables[0].Rows[i][0].ToString();

to:

fksprd_id[i] =ds.Tables[0].Rows[i][0].ToString();

Suthish Nair16y ago

instead of using a string array use a collection object.. refer an example..

        StringCollection fksprd_id = new StringCollection();
        DataTable dt = new DataTable();
        dt.Columns.Add("Name");
        dt.Rows.Add("Hello");
        dt.Rows.Add("Testing");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            fksprd_id.Insert(i,dt.Rows[i][0].ToString());
            //or, fksprd_id.add(dt.Rows[i][0].ToString()); 
        }