.Net connection problem

icobaniicobani Member Posts: 70
I wrote a small c# code and run in timer internal 5 second. if this program is run i cant login in navision. I have a error message

please Help me [-o<

Error Message:

The following SQL server error(s) occured while accessing the Session Table: 525,"22003",[Microsoft],[ODBC Sql server][Difference of two datetime collumns caused owerflow at runtime. 3621,01100],[Microsoft][ODBC SQL Server Driver][SQL Server]The Statement has been terminated.

SQL:
IF OBJECT_ID('[tempdb]..[#$ndo$sessions]') IS NOT NULL DROP TABLE [#$ndo$sessions]...............








private void showThis()
{
string filter="select * from [" ;//+ txtCompanyName.Text + "$Demands]";
filter+=txtCompanyName.Text.Replace(".","_") + "$Demands] where [End Demand Approval]='" + txtUserName.Text + "'";
SqlConnection con=new SqlConnection(txtConStr.Text);
con.Open();
SqlDataAdapter da=new SqlDataAdapter(filter,con);
DataSet ds=new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count>0)
{
string Message= ds.Tables[0].Rows.Count + " qty demand";
}

con.Close();
}
Ibrahim COBANI | Dynamics-NAV Developer Team Manager
I m a Consult

E-Mail: [email protected]
My BLOG

Comments

Sign In or Register to comment.