timed out error

Question

SqlConnection con = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand(sqlQuery, con); cmd.Connection.Open(); cmd.CommandTimeout = 999999999; SqlDataAdapter sqlDA = new SqlDataAdapter(cmd); sqlDA.Fill(dt); cmd.Connection.Close();

hari haran · Answer

you can try to catch (Exception E)

Nitin Sontakke · Answer

What if the following is causing an error? DataTable dtBOM_Mat = dbFunctions.getTable( "pr_FetchBOM_Material1 '" + cbItem.Text.ToString() + "'" ); Try to comment everything in try catch block and keep above call and then try.

yesubabu k · Answer

this is insert procedure CREATE proc pr_insertIndent_Order_Item_Details @ioid_vPDSNo varchar (50), @ioid_vproductName varchar (500), @ioid_vProduct_le_De varchar (55), @ioid_vBomItem varchar (50), @ioid_vDescription varchar (500), @ioid_nQty numeric (12, 2), @ioid_DeliveryDate datetime , @ioid_nperQty numeric (12, 2) as begin declare @ioid_iTransId int select @ioid_iTransId= isnull ( max (ioid_iTransId),0)+1 from Indent_Order_Item_Details insert into Indent_Order_Item_Details ( ioid_iTransId, ioid_vPDSNo, ioid_vproductName, ioid_vBomItem, ioid_vDescription, ioid_nQty, ioid_DeliveryDate, ioid_cStatus, ioid_dCreatedDt , ioid_vProduct_le_De, ioid_nperQty ) values ( @ioid_iTransId, @ioid_vPDSNo, @ioid_vproductName, @ioid_vBomItem, @ioid_vDescription, @ioid_nQty, @ioid_DeliveryDate, 'W' , getdate() , @ioid_vProduct_le_De , @ioid_nperQty ) end

yesubabu k · Answer

this is my insert code (C#) void insert_Sptype() { SqlConnection objCon = new SqlConnection(connectionstring); try { objCon.Open(); SqlCommand objCmd = new SqlCommand(); objCmd.Connection = objCon; SqlParameter param = new SqlParameter(); objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "pr_insertIndent_Order_Item_Details" ; param.ParameterName = "@ioid_vPDSNo" ; param.SqlDbType = SqlDbType.VarChar; param.Value = cbPDS.Text.Trim(); objCmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@ioid_vproductName" ; param.SqlDbType = SqlDbType.VarChar; param.Value = txtItemName.Text.ToString(); objCmd.Parameters.Add(param); //if (CbLe.Text != "") //{ // param = new SqlParameter(); // param.ParameterName = "@ioid_vProduct_le_De"; // param.SqlDbType = SqlDbType.VarChar; // param.Value = CbLe.Text.ToString(); // objCmd.Parameters.Add(param); //} //else //{ param = new SqlParameter(); param.ParameterName = "@ioid_vProduct_le_De" ; param.SqlDbType = SqlDbType.VarChar; param.Value = cbItem.Text.ToString(); objCmd.Parameters.Add(param); //} //if (CbLe.Text != "") //{ // DataTable dtBOM_Mat = dbFunctions.getTable("pr_FetchBOM_Material1BOMMaster '" + CbLe.Text.ToString() + "'"); // param = new SqlParameter(); // param.ParameterName = "@ioid_vBomItem"; // param.SqlDbType = SqlDbType.VarChar; // param.Value = dtBOM_Mat.Rows[0]["PartNo"].ToString(); // objCmd.Parameters.Add(param); // param = new SqlParameter(); // param.ParameterName = "@ioid_vDescription"; // param.SqlDbType = SqlDbType.VarChar; // param.Value = dtBOM_Mat.Rows[0]["Description"].ToString(); // objCmd.Parameters.Add(param); // param = new SqlParameter(); // param.ParameterName = "@ioid_nperQty"; // param.SqlDbType = SqlDbType.Float; // param.Value = float.Parse(dtBOM_Mat.Rows[0]["Qty"].ToString()); // objCmd.Parameters.Add(param); // param = new SqlParameter(); // param.ParameterName = "@ioid_nQty"; // param.SqlDbType = SqlDbType.Float; // param.Value = float.Parse(txtQty.Text.ToString()) * float.Parse(dtBOM_Mat.Rows[0]["Qty"].ToString()); // objCmd.Parameters.Add(param); //} //else //{ DataTable dtBOM_Mat = dbFunctions.getTable( "pr_FetchBOM_Material1 '" + cbItem.Text.ToString() + "'" ); param = new SqlParameter(); param.ParameterName = "@ioid_vBomItem" ; param.SqlDbType = SqlDbType.VarChar; param.Value = dtBOM_Mat.Rows[0][ "PartNo" ].ToString(); objCmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@ioid_vDescription" ; param.SqlDbType = SqlDbType.VarChar; param.Value = dtBOM_Mat.Rows[0][ "Description" ].ToString(); objCmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@ioid_nperQty" ; param.SqlDbType = SqlDbType.Float; param.Value = float .Parse(dtBOM_Mat.Rows[0][ "Qty" ].ToString()); objCmd.Parameters.Add(param); param = new SqlParameter(); param.ParameterName = "@ioid_nQty" ; param.SqlDbType = SqlDbType.Float; param.Value = float .Parse(txtQty.Text.ToString()) * float .Parse(dtBOM_Mat.Rows[0][ "Qty" ].ToString()); objCmd.Parameters.Add(param); //} param = new SqlParameter(); param.ParameterName = "@ioid_DeliveryDate" ; param.SqlDbType = SqlDbType.DateTime; param.Value = dtpDeliverDate.Value.ToString( "dd/MM/yyyy" ); objCmd.Parameters.Add(param); objCmd.ExecuteNonQuery(); colorchange(); // Fetch_Work_Order_send(); } catch (Exception Ex) { } }

Nitin Sontakke · Answer

You are shoing only some very small piece of code. Is this piece of code in some sort of loop? Please share maximum information that you can.

Nitin Sontakke · Answer

In the SAME place in your code, instead of executing the query you are currently executing just execute something else for example, select @@version as [Version]; And check how long does it takes. If it works perfectly okay, that means your sql is the problem. Are you using transaction by any chance? You obviously have to share more information. It is difficult to guess what is going on unless you tell us more info.

yesubabu k · Answer

13 sec sir it is taking

Nitin Sontakke · Answer

My dear friend, I told you: Have you tried executing the query in SQL Server Management Studio? Did you check how long does it take to execute there? Please answer this question, first. Also if possible, please post your query here too!

yesubabu k · Answer

same problem was raising sir

Nitin Sontakke · Answer

Your code is not a problem. The problem is your query. Have you tried executing the query in SQL Server Management Studio? Did you check how long does it take to execute there? In case you wish to wait for more time, when command is execuiting, you will need to change the CommandTimeout parameter of the objCmd in your code. Make it 0 (zero) which means infinite. But you SHOULD look into your query too!

Kaushik Dhameliya · Answer

Put below connection string and change in code SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString);

yesubabu k · Answer

public static string connectionstring = System.Configuration.ConfigurationSettings.AppSettings["ConStr"]; app.config

Kaushik Dhameliya · Answer

Try to this https://stackoverflow.com/questions/10108565/changing-sqlconnection-timeout if above solution is not working then put your connection string.