asp.net - Retrieve Data From SQL and insert all data back into db using C# -

first off, new c#. have been tasked project business unit @ work.

i have userform retrieve data sql db, , allow user input text boxes. when hit submit, need received data db , user written db on new table. it's written in c# , asp.net.

on page load have gathering data db:

html markup:

<asp:sqldatasource id="sqldatasource1" runat="server"  connectionstring="<%$ connectionstrings:contr1 %>"  selectcommand="select distinct [employee name] total_tech_minutes  (site = 'us.tn.memphis') order [employee name]"></asp:sqldatasource>     <asp:sqldatasource id="sqldatasource2" runat="server"  connectionstring="<%$ connectionstrings:contr1 %>"  selectcommand="select [total minutes] total_minutes [total_tech_minutes]  ([employee name] = @employee_name)">         <selectparameters>             <asp:controlparameter controlid="dropdownlist1" name="employee_name"  propertyname="selectedvalue" type="string" />         </selectparameters>     </asp:sqldatasource> 

that works perfectly. see action on db profiler. problem when rest of code. see nothing on db profiler code below.

the following html markup inserting db:

<asp:sqldatasource id="sqldatasource3" runat="server"  connectionstring="<%$ connectionstrings:contr1 %>"   insertcommand="insert obh([tech name],[total minutes],[off bench time], [submitted by],comments)  select [tech name]=techname,[total minutes]=@tm,[off bench time]=@obt,[submitted by]=@sb, comments=@comments"  providername="<%$ connectionstrings:contr1.providername %>"  cancelselectonnullparameter="false" datasourcemode="datareader">  <insertparameters>              <asp:controlparameter controlid="dropdownlist1" name="techname" propertyname="selectedvalue" />             <asp:controlparameter controlid="datalist1" name="tm" propertyname="selectedvalue" />             <asp:controlparameter controlid="textbox1" name="obt" propertyname="text" />             <asp:formparameter formfield="login1.username" name="sb" />             <asp:controlparameter controlid="textbox2" name="comments" propertyname="text" />         /insertparameters>     /asp:sqldatasource> 

this button action:

protected void button1_click(object sender, eventargs e)     {         sqldatasource3.databind();     } 

@mmk works perfectly.

protected void button1_click(object source, eventargs e) { sqldatasource3.insert(); } 

– mmk yesterday