<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="DriverTelephoneDetails.aspx.cs" Inherits="NFTRANS.DriverTelephoneDetails" %> <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server"> <style type="text/css"> .style3 { width: 226px; } .style6 { width: 227px; } #tblAddnew { width: 100%; } .style7 { width: 311px; } .style8 { width: 110px; } </style> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <p> <br /> </p> <asp:Panel ID="Panel1" runat="server"> <table class="style1"> <tr> <td class="style3"> Driver Name :</td> <td class="style7"> <asp:Panel Id="panel2" runat="server" DefaultButton="bt1"> <asp:TextBox ID="txtDrivername" runat="server" Width="153px"></asp:TextBox> <asp:Button id="bt1" Text="Default" runat="server" onclick="bt1_Click" /> </asp:Panel> </td> <td class="style8"> </td> <td> <asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">Add New</asp:LinkButton> </td> </tr> </table> </asp:Panel> <table id="tblAddnew" class="style1" runat="server" bgcolor="#FF9966" > <tr> <td bgcolor="#FFCC99" class="style6"> </td> <td> </td> </tr> <tr> <td bgcolor="#FFCC99" class="style6"> Code</td> <td> <asp:DropDownList ID="DropDownList1" runat="server" Height="24px" Width="190px" AutoPostBack="True"> </asp:DropDownList> </td> </tr> <tr> <td bgcolor="#FFCC99" class="style6"> Country</td> <td> <asp:TextBox ID="txtCountry" runat="server" Width="191px"></asp:TextBox> </td> </tr> <tr> <td bgcolor="#FFCC99" class="style6"> Operator</td> <td> <asp:TextBox ID="txtoperator" runat="server" Width="189px"></asp:TextBox> </td> </tr> <tr> <td bgcolor="#FFCC99" class="style6"> Telephone</td> <td> <asp:TextBox ID="txt_Phno" runat="server" Width="187px"></asp:TextBox> </td> </tr> <tr> <td bgcolor="#FFCC99" class="style6"> </td> <td> <asp:Button ID="Button1" runat="server" BorderStyle="Double" Text="Submit" Width="91px" onclick="Button1_Click" /> </td> </tr> </table> <table class="style1"> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> <br /> <br /> </asp:Content>
protected void bt1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(connStr); SqlDataReader ddDR = null; con.Open(); SqlCommand cmd = new SqlCommand("SELECT DriverMaster_tbl.Driverid, DriverMaster_tbl.DriverCode, DriverMaster_tbl.FirstName, DriverMaster_tbl.LastName, DriverMaster_tbl.Nationality, DriverPhonenumNew.PhOperator, DriverPhonenumNew.Country, DriverPhonenumNew.PhNum FROM DriverMaster_tbl INNER JOIN DriverPhonenumNew ON DriverMaster_tbl.Driverid = DriverPhonenumNew.DriverId WHERE (DriverMaster_tbl.FirstName LIKE '%" + txtDrivername.Text.Trim() + "%') OR (DriverMaster_tbl.LastName LIKE '%" + txtDrivername.Text.Trim() + "%') ", con); ddDR = cmd.ExecuteReader(); dt.Load(ddDR); con.Close(); }
Page.Form.DefaultButton = bt1.UniqueID;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)