c# - How do I send multiple users message using a gridview with templates -

how send mltiple users message using griview should connected 2 tables namely login(from usernames retrieved , shown) , second table message (where message stored particular usernames). have connected login not able insert values message table. message table has msg_id , username , message columns.

here design:

.aspx

</asp:content> <asp:content id="content2" contentplaceholderid="contentplaceholder2" runat="server"> <asp:gridview id="gridview2" runat="server" autogeneratecolumns="false"      enablemodelvalidation="true" datasourceid="sqldatasource1"      onrowcommand="gridview2_rowcommand"> <columns>     <asp:boundfield datafield="username" headertext="username"          sortexpression="username" />     <asp:boundfield datafield="password" headertext="password"          sortexpression="password" />     <asp:boundfield datafield="utype" headertext="utype" sortexpression="utype" />     <asp:boundfield datafield="ptype" headertext="ptype" sortexpression="ptype" /> </columns>       </asp:gridview>       <asp:sqldatasource id="sqldatasource1" runat="server"          connectionstring="<%$ connectionstrings:automobileconnectionstring14 %>"          selectcommand="select * [login] ([utype] '%' + @utype + '%')">         <selectparameters>         <asp:parameter defaultvalue="u" name="utype" type="string" />         </selectparameters>         </asp:sqldatasource> </asp:content> 

aspx.cs code

protected void gridview2_rowcommand(object sender, gridviewcommandeventargs e) {     if (e.commandname.equals("cc"))     {         textbox txt1 = (textbox)gridview2.footerrow.findcontrol("textbox1");         foreach(gridview gr in gridview2.rows)         {             checkbox chk = (checkbox)gr.findcontrol("checkbox1");             if (chk.checked)             {                 object ob = gridview2.datakeys[gr.rowindex].value;              } 

now stuck how can insert values other table message when connected login table. me want accomplish here send message checked users.

try below :

    <asp:gridview id="gridview2" runat="server" autogeneratecolumns="false" datasourceid="sqldatasource1" datakeynames="userid"         onrowcommand="gridview2_rowcommand" onrowediting="gridview2_rowediting" onrowupdated="gridview2_rowupdated" onrowupdating="gridview2_rowupdating">         <columns>              <asp:templatefield headertext="username">                 <itemtemplate>                     <asp:label text='<%# eval("username") %>' runat="server"></asp:label>                 </itemtemplate>             </asp:templatefield>             <asp:boundfield datafield="password" headertext="password"                 sortexpression="password" />              <asp:boundfield datafield="utype" headertext="utype" sortexpression="utype" />             <asp:boundfield datafield="ptype" headertext="ptype" sortexpression="ptype" />              <asp:templatefield>                 <itemtemplate>                     <asp:label text='<%# eval("messgae") %>' runat="server"></asp:label>                 </itemtemplate>                  <edititemtemplate>                         <asp:textbox id="txtmsg" runat="server"></asp:textbox>                     </edititemtemplate>             </asp:templatefield>            <asp:templatefield>                 <itemtemplate>                     <asp:checkbox id="chk" runat="server" />                 </itemtemplate>              </asp:templatefield>         </columns>      </asp:gridview> 

on rowdatabound event set edit textbox message find control. , refer code inline editing on check box click.

http://www.c-sharpcorner.com/uploadfile/9f0ae2/gridview-edit-delete-and-update-in-asp-net/ http://www.codeproject.com/articles/23471/editable-gridview-in-asp-net