ASP.NET

Re: connectivity in asp [modified]

3-Mar-09 23:42

Whats your Doubt? Specify the doubt?

Greg Chelstowski3-Mar-09 23:52

Greg Chelstowski

3-Mar-09 23:52

Well, there's a bug in your sql string though.
Not sure it's gonna run without the space after count(*).
Plus!
I'm pretty sure the column username would be an nvarchar, as most likely would the column password.
Hence, you have to use inverted commas. (').
BUT.
The best way yet to do it would be to add parameters to it instead, like so:

SqlCommand cm = new SqlCommand("select count(*) from myusers where username= @usrnm and password=@password",cn);

cm.Parameters.Add("@usrnm", SqlDbType.NVarChar).Value = textBox1.Text;
cm.Parameters.Add("@password", SqlDbType.NVarChar).Value = textBox2.Text;

Now try it Wink | ;)

var question = (_2b || !(_2b));

modified on Wednesday, March 4, 2009 6:00 AM

Re: connectivity in asp

Abhijit Jana4-Mar-09 0:08

Abhijit Jana

4-Mar-09 0:08

aratireddy wrote:
initially i created a table and inserted some data and connected to that table. i took 2 labels and 2 textboxes and a button. one for username and one more for password . in button_click i wrote the code as following

then what is your problem?

cheers,
Abhijit
CodeProject MVP

Gridview?

Karthick_gc3-Mar-09 23:03

3-Mar-09 23:03

Hi, I use Gridview in my form. The code is as follows.

<asp:gridview id="view1" autogeneratecolumns="false" allowpaging="True" xmlns:asp="#unknown">
OnRowCommand="GridView1_RowCommand" runat="server" CellPadding="4"
ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="view1_SelectedIndexChanged">

But at runtime the following erroe came.

The data source does not support server-side data paging.

Can anyone tell what the problem?

http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/273e19b8-02aa-4e54-b907-d461037b83eb/[^]

rakeshs3123-Mar-09 23:16

rakeshs312

3-Mar-09 23:16

Karthick_gc3-Mar-09 23:31

3-Mar-09 23:31

S. I got the solution. Now i want to display some 10 rows in grid view. And at the bottom of the grid the Page numbers are to be displayed. If i clicked the Second page again the rows from 2nd page has to display?How to achieve it?

keyur satyadev3-Mar-09 23:47

3-Mar-09 23:47

make the gridview paging property true and fire the event of grid view paging.
follow the code.set the column properties 10.

eg.
{
protected void grdemp_PageIndexChanging(object sender, GridViewPageEventArgs e)
//grdemp is ame of grid view
{
grdemp.PageIndex = e.NewPageIndex;
}
}

Regards
Keyur Satyadev

Karthick_gc3-Mar-09 23:56

3-Mar-09 23:56

i work on your code. But the following error came. Can u solve it?

The GridView 'view1' fired event PageIndexChanging which wasn't handled

keyur satyadev4-Mar-09 0:16

4-Mar-09 0:16

i think you use the view in your code so make event for it.

or send me your code so i make correct it?

regards
keyur satyadev

Karthick_gc4-Mar-09 0:40

4-Mar-09 0:40

<asp:gridview id="view1" autogeneratecolumns="false" allowpaging="true" allowsorting="true" xmlns:asp="#unknown">
OnRowCommand="GridView1_RowCommand" runat="server" CellPadding="4"
ForeColor="#333333" GridLines="None" PageSize="2">

<columns>

<asp:templatefield headertext="Job-ID">
<itemtemplate>
<asp:linkbutton id="lblId" runat="server">
CommandArgument='<%# Eval("jid") %>' CommandName="getid"
Text='<%# Bind("jid") %>'>

<headerstyle horizontalalign="Center">

<asp:templatefield headertext="Title">

<itemtemplate>
<asp:label id="lbltit" runat="server" text="<%# Bind(" title=") %>">

<headerstyle horizontalalign="Center">

<asp:templatefield headertext="Description">

<itemtemplate>
<asp:label id="lbldes" runat="server" text="<%# Bind(" description=") %>">

<headerstyle horizontalalign="Center">

In th COde behind i write the following code

protected void view1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{
view1.PageIndex = e.NewPageIndex;
}

Whats the error in this?

keyur satyadev4-Mar-09 1:18

4-Mar-09 1:18

please write event name in gridview property.

<asp:gridview id="view1" pageindexchanging="view1_PageIndexChanging" xmlns:asp="#unknown">

Karthick_gc4-Mar-09 1:25

4-Mar-09 1:25

Again the same error. What to do?

<asp:gridview id="view1" xmlns:asp="#unknown">pageindexchanging="view1_PageIndexChanging"
AutoGenerateColumns="false" AllowPaging="true" AllowSorting="true"
OnRowCommand="GridView1_RowCommand" runat="server" CellPadding="4" xmlns:asp="#unknown"
ForeColor="#333333" GridLines="None" PageSize="5">

The GridView 'view1' fired event PageIndexChanging which wasn't handled.

anujbanka17844-Mar-09 1:37

anujbanka1784

4-Mar-09 1:37

bind urs grid on page index changing also...call grid bind functin here also..

keyur satyadev4-Mar-09 1:47