ASP.NET

rajmani wrote:

I want to do a bulk insert of around 25k records into sqlserver databse .

for(int i=0;i<=YourValue;i++)
{
    //Prepare your insert query
    //Pass query to command object
} 

<script><br />
<br />
function LoadFocus(){<br />
<br />
document.getElementById('<%= <TextBoxName>.ClientID %>').focus();<br />
document.getElementById('<%= <TextBoxName>.ClientID %>').select();<br />
<br />
}<br />
<br />
window.attachEvent("onload", LoadFocus);<br />
<br />
}<br />
<br />
</script>

daniel__c wrote:

document.getElementById('<%= .ClientID %>').select();

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

aziz_subaie wrote:

how can I set the delete command

aziz_subaie wrote:

daynamic

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

The ANZAC wrote:

First of all, how do i populate the combobox with data from this table (column: towns)

<br />
<br />
In form_load event, <br />
<br />
     <code>   <br />
        SqlConnection dbConn = new SqlConnection(connectionString);<br />
<br />
        dbConn.Open();<br />
<br />
        SqlDataAdapter da = new SqlDataAdapter("SELECT town FROM table1", dbConn);<br />
        DataSet ds = new DataSet();    <br />
        da.Fill(ds);<br />
<br />
        dbConn.Close();<br />
<br />
        DropDownList1.DataSource = ds.Tables[0];<br />
        DropDownList1.DataTextField = "town";<br />
        DropDownList1.DataValueField  = "postalcode";<br />
        DropDownList1.DataBind();<br />

The ANZAC wrote:

second of all, when i change item, how do i make the textbox display the postcode (a.k.a. zip code) (column: postcode).

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)<br />
    {<br />
       txtPostalCode.Text = DropDownList1.SelectedValue;<br />
    }

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.