timed out error

yesubabu k

8y1kWindows Forms

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();

13 Replies

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

hari haran8y ago
you can try to

catch (Exception E)
0
Nitin Sontakke8y ago
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.
0
yesubabu k8y ago
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
0
yesubabu k8y ago
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)
{
}
}
0
Nitin Sontakke8y ago
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.
0
Nitin Sontakke8y ago
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.
0
yesubabu k8y ago
13 sec sir it is taking
0
Nitin Sontakke8y ago
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!
0
yesubabu k8y ago
same problem was raising sir
0
Nitin Sontakke8y ago
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!
0
Kaushik Dhameliya8y ago
Put below connection string

and change in code

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString);
0
yesubabu k8y ago
public static string connectionstring = System.Configuration.ConfigurationSettings.AppSettings["ConStr"];

app.config

0
Kaushik Dhameliya8y ago
Try to this

https://stackoverflow.com/questions/10108565/changing-sqlconnection-timeout

if above solution is not working then put your connection string.
0