ASP.NET

Danpeking wrote:

Thanks for the replies guys, it would be great to have one central table containing the IPT rates and dates effective but this would be extremely difficult to do given there is only 2 developers in the team and the IPT is a rating factor in a few products quote engines.

public static CustomerResponseLogCollection FindAll(int orderID)
       {
           Database db = EmersonDataHelper.CreateConnection();
           CustomerResponseLogCollection customerResponseLogs = new CustomerResponseLogCollection();

           var c = db.ExecuteSprocAccessor<CustomerResponseLog>(ConstantsDB.USPGetResponseLogsByOrderID, orderID).ToList();

           foreach (CustomerResponseLog item in c)
           {
               customerResponseLogs.Add(item);
           }

           return customerResponseLogs;
       }

future3839 wrote:

Now, I just wondering to know, when I wanna insert data via Store procedure do I have to write SP for each of them?
is there any approach to insert data with writing just one SP.

treuveni wrote:

I have a grid with 10K rows

treuveni wrote:

DataTable dt = (DataTable)GridViewArgs.DataSource;

foreach(GridViewRow row in grdRawData.Rows)
{
    myData = row.Cells[ColNum].Text;  // For BoundField only.//
}

TextBox txtName = (TextBox)grdRawData.Rows[rowNum].FindControl("IdOfTextBox");  // For BoundField only.//
myData = txtName.Text;

Asif Rehman wrote:

I want to remove defaultvalue that dropdownlist captures when I bound the control to sqldatasource. So that user selects from list.

Asif Rehman wrote:

Secondly,
How to dropdown the list when it got focus.

Abhijit Jana wrote:

Didn't get your question