Member Avatar for Robins Antony

hi all pls help

Input string is not in a correct format.

string selectsql = ("select title,convert(varchar,date,106)as date,description,cast(status as bit)as status from event_tbl where i_eid=" + Convert.ToInt32(id2) + "");

Regards

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

Of course we can see what the error is, here is something to help you rather than just tell you.

After assigning your sql statement, do this.

System.Diagnostics.Debug.WriteLine(selectsql);

Then you will be able to tell where the error is at.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.