ado.net beginners question

[James J. Foster]

You'll get that error if the sql statement is empty/blank (in your case,
strCallLog). What is the value of strCallLog when you get that error? You
may want to add in a test for when strCallLog is equal to String.Empty.

--
James J. Foster, DotNetCoders
[url]http://www.dotnetcoders.com[/url]


"Mike P" <mrp@telcoelectronics.co.uk> wrote in message
news:OPS6630VDHA.2168@TK2MSFTNGP09.phx.gbl...

> Can anybody tell me what is wrong with this code? The error I get is
> 'CommandText property has not been initialized'.
>
> void BindData(string strCallLog)
> {
> SqlConnection objConnection = new
> SqlConnection(ConfigurationSettings.AppSettings["strConnectTransitTest"]
> );
> SqlDataAdapter objDataAdapter = new SqlDataAdapter(strCallLog,
> objConnection);
>
> DataTable objDataTable = new DataTable();
> objDataAdapter.Fill(objDataTable);
>
> Session["LogData"] = objDataTable;
> dgLog.DataSource = objDataTable;
> dgLog.DataBind();
> }
>
>
> Cheers,
>
> Mike
>
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Mike P]

Thanks for your help. I've found that I was losing the string value on
postback, so I changed the string to a Session variable and it seems to
work fine.


Cheers,

Mike



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!