Comments by sat_100m (Top 13 by date)

Yes I did little bit but big changes in DB .

ALTER procedure [dbo].[quest_categories_FullJoin_State_Retrieve]
@SNo int
as
select quest_categories.City AS City1,State.City AS City2,quest_categories.Sr_No as Sr_N01,
phone,Population,State.City AS City2,State
from quest_categories
full Join State on quest_categories.City = State.City

where quest_categories.Sr_No=@SNo
RETURN

Thnx Mahendra.p25....u r correct..........

Thank You very Much

No I am trying to get check value of checkbox chksr from database....

No, I want chkSr value(selected one) from database and table name "State"...

rdoSr contains same values of state column and I want after select on rdoSr, the value of chksr comes up automatically.

Both rdoSr and chksr contains same values dat's retrieve from column Sate of table State

No, I want chkSr value(selected one) from database and table name "State"...

rdoSr contains same values of state column and I want after select on rdoSr, the value of chksr comes up automatically.

Both rdoSr and chksr contains same values dat's retrieve from column Sate of table State

Thnx...............

Thnx....

I have created 2 textbox txtRows and txtCols........when i input some value on dem it has created
the same no. of row and columns with every cell containing blank textboxes....i want to insert valus on dat textboxes to a table in database(sql)....

<div>
Rows:
<asp:TextBox ID="txtRows" runat="server" />
 Cols:
<asp:TextBox ID="txtCols" runat="server" />
<br /><br />
<asp:CheckBox ID="chkBorder" runat="server"
Text="Put Border Around Cells" />
<br /><br />

<asp:Button ID="cmdCreate0" runat="server"
Text="Create Table with textbox" onclick="cmdCreate0_Click" />
<br /><br />
<asp:Table ID="table1" runat="server" />
<br />
<br />
 <br />
<br />
 <br />
</div>



public partial class table : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// Configure the table's appearance.
// This could also be performed in the .aspx file
// or in the cmdCreate_Click event handler.
table1.BorderStyle = BorderStyle.Inset;
table1.BorderWidth = Unit.Pixel(1);

}



protected void cmdCreate0_Click(object sender, EventArgs e)
{

table1.Controls.Clear();
int rows = Int32.Parse(txtRows.Text);
int cols = Int32.Parse(txtCols.Text);
for (int row = 0; row < rows; row++)
{

TableRow rowNew = new TableRow();

table1.Controls.Add(rowNew);
for (int col = 0; col < cols; col++)
{

TableCell cellNew = new TableCell();
TextBox txtContent = new TextBox();

cellNew.Controls.Add(txtContent);

if (chkBorder.Checked)
{
cellNew.BorderStyle = BorderStyle.Inset;
cellNew.BorderWidth = Unit.Pixel(1);
}

rowNew.Controls.Add(cellNew);
}
}
}


}