Click here to Skip to main content
15,891,248 members

Comments by rajeeshsays (Top 15 by date)

rajeeshsays 31-Jul-14 8:56am View    
Which data type is suitable to show the second part also.Please update me
rajeeshsays 11-Jun-14 12:36pm View    
My heartfull thanks for this replay.My prayers
rajeeshsays 11-Jun-14 12:08pm View    
I have tried with the code suggested by you,it dialog box doesnt open when the page is loaded that was my first problem it solved thanks for that ,but when the button is clicked dialog box is opened and suddenly closed,it is closed automatically I need it be stayed open until I close it
rajeeshsays 17-Mar-14 10:57am View    
here the commented line of code is the actual way of passing parameters to sp in our project ,
here database variable and connection ,transaction are made of DataBaseFactory .pls resolve this problem
rajeeshsays 17-Mar-14 10:54am View    
public void UpdateTollTransaction(Database db, DbTransaction transaction,DataTable dtFleetRegOwnRequest)
{
Utilities.InfoLog.Debug("Entry");
SqlCommand com=new SqlCommand("HTA.up_UpdateTollTransaction");
com.CommandType = CommandType.StoredProcedure;

//com = db..GetStoredProcCommand("HTA.up_UpdateTollTransaction");
//var command = db.GetStoredProcCommand("HTA.up_UpdateTollTransaction");
var DailyTollParam = com.Parameters.AddWithValue("@DailyToll", dtFleetRegOwnRequest);
DailyTollParam.SqlDbType = SqlDbType.Structured;

var HtaParam = com.Parameters.AddWithValue("@HtaFileId", FileId);
HtaParam.SqlDbType=SqlDbType.Int;

//db.AddInParameter(command, "@HtaFileId", DbType.Int32, FileId);
//db.AddInParameter(command, "@TollFlag", DbType.Boolean, TollFlag);
//db.AddInParameter(command, "@TollTransactionId", DbType.Int32, TollTransactionId);
//db.AddInParameter(command, "@DailyToll",SqlDbType.Structured, dtFleetRegOwnRequest);

com.CommandTimeout = Utilities.TimeOut;
Utilities.InfoLog.Debug("Executing StoredProcedure " + com.CommandText);
if (transaction != null)
{
db.ExecuteNonQuery(com, transaction);
}
else
{
db.ExecuteNonQuery(com);
}
Utilities.InfoLog.Debug("Exit...");
}