Comments by Bhargav.456 (Top 39 by date)

Hi.. Thanks for the reply..
I have tried in this way..
DELETE tbl1, tbl2 FROM tbl1 INNER JOIN tbl2 ON tbl1.username = tbl2.username WHERE tbl1.username='shiva'

but i am getting error i.e., incorrect syntax near ,

Thank you

Thanks..
Can we use trigger of implement table data..??

Yes.

Thanks..

E.g : If I have an ad under 'Assam', countadvertizment column should be '1'.
At further if I again enter an ad under Assam, it should be '2' (Incremented by 1)
Now, If I have an ad under 'AP', countadvertizment column should be '1'. Again if it is under 'Assam', countadvertizment column must be '3', as I have entered 2 ads under ASSAM.

I want to implement with triggers.Does the above query works??

Thank you..

Thanks..

Actually,I have a column named as 'state' (contains different states e.g Assam, AP, Bangalore etc) based on the state name the column 'countadvertizment' should be incremented by '1'

E.g : If I have an ad under 'Assam', countadvertizment column should be '1'.
At further if I again enter an ad under Assam, it should be '2' (Incremented by 1)
Now, If I have an ad under 'AP', countadvertizment column should be '1'. Again if it is under 'Assam', countadvertizment column must be '3', as I have entered 2 ads under ASSAM.

Hope you got my question. Help me.

Thanks

Thanks.. Actually I have struct with this..

I have a column named as 'state' (contains different states e.g Assam, AP, Bangalore etc) based on the state name the column 'countadvertizment' should be incremented by '1'

E.g : If I have an ad under 'Assam', countadvertizment column should be '1'.
At further if I again enter an ad under Assam, it should be '2' (Incremented by 1)
Now, If I have an ad under 'AP', countadvertizment column should be '1'. Again if it is under 'Assam', countadvertizment column must be '3', as I have entered 2 ads under ASSAM.

Hope you got my question. Help me.

Thanks

Thanks for the reply,
i need case2 pattern.
1 more query i need to ask.. Can I assign primary key for two columns?
Thanks

I want to increment '+1'.

Thanks for your reply Vani. But I need to implement query string in 3 -tier architecture.
(Query string which has 3-tier architecture)
How can I do it??

Sorry!!

I have asked the code for history in C#. . . not navigation (Read it properly and do answer)
Thanks

Even I too expects the same Shubh Agrahari.. Even I vl also do some research. But i couldnt find any solution. I dont know how to start the project. so thats why I have posted.
Anyway thanks for ur comments.

Thanks, Suppose if I have 40 textboxes, how can I do?

Thanks, Suppose if I have 40 textboxes, how can I do?

data base like this

id code qty osno
1 2 10 1
2 3 10 2
3 4 10 3
4 6 10 4
5 7 10 4

my question is to get max of osno value should show in a gridview as separate column
as well as the database also

i need gridview like this to show an output

id code qty osno max no
1 2 10 1 4
2 3 10 2 4
3 4 10 3 4
4 6 10 4 4
5 7 10 4 4

please explain clearly

i did the same one, but i used group query, its showing maximum of there particulars.
i need max value of column from database and show the all the values in grid view in that grid view i want max value should show in separate column.

Sorry, I wrote the above code in gridview selectedindexchanged event.

I am getting the below error.

CS1061: 'System.Web.UI.WebControls.GridView' does not contain a definition for 'RowCount' and no extension method 'RowCount' accepting a first argument of type 'System.Web.UI.WebControls.GridView' could be found (are you missing a using directive or an assembly reference?)

Sorry,

I am getting this error after writing code in textbox changed event.

CS1061: 'System.EventArgs' does not contain a definition for 'KeyCode' and no extension method 'KeyCode' accepting a first argument of type 'System.EventArgs' could be found (are you missing a using directive or an assembly reference?)

I am not getting output, please help

While I run the page, I am not getting gridview display on enter click of textbox

Thanks, but I am not getting output. I have written like this.

design:
<asp:TextBox ID="TextBox1" runat="server" OnKeyDown="TextBox1_KeyDown()"
AutoPostBack="True">
in cs:

private void TextBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
GridView1.Visible = true;
}
}

is it correct?

what code should i write under selectindexchanging?
where should i write the code in selectindexchanged or selectindexchanging?
i am not getting clearly?

Thanks for the code, But I need to get the selected row data from the gridview1 to the table. How do I do it?

Could you show ur code?

Thank YOu, I even need to det an id displayed in that box.

Thank You, but your solution is not working. If you have another idea, please do tell me

Thank You, Can we implement in any other way other than membership provider? If yes, could you please tell me.

Thank You, But i need to change the url i.e., if it is www.sample.com, the user for example abcd gets loggin, his name (abcd) should be indicated in the url i.e., abcd.sample.com

TABLES:
<asp:Panel ID="Panel1" runat="server">
<table>
<tr>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
<td>
<asp:TextBox ID="TextBox3" runat="server">
</td>
</tr>
</table>

<asp:Panel ID="Panel2" runat="server">
<table>
<tr>
<td>
<asp:TextBox ID="TextBox6" runat="server">
</td>
<td>
<asp:TextBox ID="TextBox7" runat="server">
</td>
<td>
<asp:TextBox ID="TextBox8" runat="server">
</td>
</tr>
</table>


GRIDVIEW Code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1"
onselectedindexchanged="GridView1_SelectedIndexChanged2">
<columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="Code" HeaderText="Code" SortExpression="Code" />
<asp:BoundField DataField="Description" HeaderText="Description"
SortExpression="Description" />
<asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice"
SortExpression="UnitPrice" />
<asp:BoundField DataField="Eup" HeaderText="Eup" SortExpression="Eup" />
<asp:BoundField DataField="Mrp" HeaderText="Mrp" SortExpression="Mrp" />


<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sruthiConnectionString %>"
SelectCommand="SELECT [Code], [Description], [UnitPrice], [Eup], [Mrp] FROM [sample_tbl]">

Thank you, Could you please provide its code?

Thank You, For example, If we have two different tables say table1 and table2. Both tables have 1 row, 5 columns each(each column has five textboxes naming from textbox1 to textbox5 for table1 and textbox6 to textbox10 for table2).
I placed those tables one by one i.e, first table1 as 1 row then table2 as 2nd row.
At first instance, For binding data from gridview (on select command) to table1, we write TextBox1.Text = GridView1.SelectedRow.Cells[1].Text;
TextBox2.Text = GridView1.SelectedRow.Cells[2].Text; etc. . then at next 2nd row i.e., we have table2. How can I insert data in that from gridview?