ASP.NET

CODEBEHIEND CODE:

Using System;

Using System.Data;

Using System.Data. SqlClient; 

Using System.Configuratio n; 

Using System.Web.Configur ation; 

Using System.Collections; 

Using System.Web; 

Using System.Web.Security ; 

Using System.Web.UI; 

Using System.Web.UI. WebControls; 

Using System.Web.UI. WebControls. WebParts; 

Using System.Web.UI. HtmlControls; 

Using System.Text; 

Public partial class ClientCallBack : System.Web.UI.Page, System.Web.UI.ICallbackEventHandler 

{

private string raiseCallArgument, stateId; 

protected void Page_Load(object sender, EventArgs e) 

{

if (!IsPostBack) 

{

string strConnection = WebConfigurationMan ager.ConnectionStrings["DemoConn"].ConnectionString; 

SqlConnection con = new SqlConnection(strConnection) ; 

string strSQL = "SELECT DISTINCT * FROM tblRmStateMaster"; 

using (con) 

{

con.Open();

SqlCommand objCmd = new SqlCommand(strSQL, con); 

SqlDataReader dtReader = objCmd.ExecuteReade r(); 

using (dtReader) 

{

if (dtReader.HasRows) 

{

ddl.DataSource = dtReader;

ddl.DataTextField = "Statename"; 

ddl.DataValueField = "Statename"; 

ddl.DataBind( );

}

}

}

}

if (Request.Browser. SupportsCallback ) 

{

string callbackRef = Page.ClientScript. GetCallbackEvent Reference(this, "document.forms[ 0].elements[ 'ddl'].value", "CallbackonClientsi de", "null"); 

ddl.Attributes["onChange"] = callbackRef; 

}

}

public void RaiseCallbackEvent(string raiseCallArgument) 

{

this.raiseCallArgument = raiseCallArgument; 

stateId = this.raiseCallArgument; 

}

//This method should return a string value for the Javascript method to handle 

public string GetCallbackResult( ) 

{

StringBuilder returnString = new StringBuilder(); 

using (SqlConnection cn = new SqlConnection(ConfigurationManage r.ConnectionStrings["DemoConn"].ToString() )) 

{

cn.Close();

cn.Open();

SqlCommand cmd1 = new SqlCommand("select * from tblRmStateMaster where Statename='" + stateId + "' ", cn); 

SqlDataReader dr; 

dr = cmd1.ExecuteReader( );

string str = ""; 

while (dr.Read()) 

{

str = dr[

"Stateid"].ToString() ; 

}

dr.Close();

cn.Close();

int a = ddl.SelectedIndex + 1; 

string exp = raiseCallArgument; 

try 

{

cn.Open();

SqlCommand cmd = new SqlCommand("select DISTINCT * from tblRmCountyMaster where Stateid=" + str, cn); 

SqlDataReader rdr1 = cmd.ExecuteReader( ); 

using (rdr1) 

{

while (rdr1.Read() ) 

{

returnString. Append(rdr1[ 2]);

returnString. Append(","); 

}

}

rdr1.Close() ;

cn.Close();

}

catch (Exception ex) 

{

Response.Write( ex.Message) ;

}

}

return returnString. ToString( ); 

}

protected void Button1_Click(object sender, EventArgs e) 

{

Response.Write( ddl.SelectedItem .Text);

Response.Write( DropDownList1. SelectedItem. Text);

}

}

<%

@ Page Language="C#" AutoEventWireup="true" CodeFile="ClientCallBack. aspx.cs" Inherits="ClientCallBack" EnableEventValidati on="false" %> 

<!

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional/ /EN" "http://www. w3.org/TR/ xhtml1/DTD/ xhtml1-transitio nal.dtd"> 

< 

html xmlns="http://www. w3.org/1999/ xhtml"> 

< 

head id="Head1" runat="server"> 

<title>Client Callback on ChillapzLocal</title> 

<script type="text/javascript" language="javascript"> 

//Function to handle and process the server-side result 

//The result comes as string and the method takes two arguments, here. 

function CallbackonClientsid e(stringResult, context) 

{

var listCompany = document.forms[ 0].elements['DropDownList1']; 

listCompany. innerHTML = 

""; 

var entries = stringResult. split(','); 

var str = ""; 

for(var i=0;i<entries.length- 1;i++) 

{

var company = entries[i]; 

//Create the list item 

var item = document.createElem ent('option'); 

item.value = company;

item.innerHTML = company;

listCompany. appendChild( item);

}

//alert("end" ); 

}

</script> 

</

head> 

< 

body> 

<form id="form1" runat="server"> 

<div> 

State: 

          

<asp:DropDownList ID="ddl" runat="server"> 

</asp:DropDownList> 

<br /> 

<br /> 

County: 

       

<asp:DropDownList ID="DropDownList1" runat="server"> 

</asp:DropDownList> <br /> 

<br /> 

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div> 

</form> 

</

body> 

</

html>

dharanighanta wrote:

my requirement is fill the county dropdownlist with out page postback

Table1 (with 5 rows)<br />
Table2 (with 2 rows)<br />
<br />
<br />
Dim Dt As Data.DataTable<br />
Dim dr As Data.DataRow<br />
<br />
<br />
dt = Table1<br />
<br />
            For index As Integer = 1 To LeaveReacordTable1.Rows.Count - 1<br />
                dr = dt.NewRow<br />
                dr.Item("Column Name 1") = LeaveReacordTable1.Rows(index)("Column Name 1")<br />
                dr.Item.....<br />
                dt.Rows.Add(dr)<br />
<br />
            Next<br />
            GridView1.DataSource = dt<br />
            GridView1.DataBind()

ASP.NET 2.0 wrote:

I need one Gridview with 5 rows and another gridview with 2 rows and I need to merge this two gridview show 7 rows.