ASP.NET

Re: Gridview/DropDownList problem. Simple problem, I think

17-Jul-07 2:30

Hey guys, I'm having a little problem with my drop down list and gridview.

I used the drop down list to select what data is going to be shown in the gridview, it was working fine earlier but I changed the SQL string around a little bit and it went all haywire. Usually I back up my data every few hours, but just as my luck would have it, last time I backed up was right before I started that form.

The error I'm getting is "Must declare the scalar variable "@Name".", but I thought it was declared, I must have a line left out in the drop down list settings. Here is the code that I think matters. If I'm leaving any out please let me know!

<asp:DropDownList ID="myDropDownList" runat="server"
    DataSourceID   = "myFilteringDataSource"
    DataValueField = "Name"
    AutoPostBack   = "True" DataTextField="Name"
  />


    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT *
FROM tblCallers,
   tblTicket,
   tblUsers
WHERE tblTicket.TicketID = tblCallers.TicketID
 AND tblTicket.UserID = tblUsers.UserID AND tblUsers.Name = @Name">
    </asp:SqlDataSource>

Thanks,
aqzman

Edit: Just thought this might help elimate some problems. When I run this code without the "AND tblUsers.Name = @Name" code the gridview and drop down list both fill up with all the data they need to, but obvisiouly none of the data in the gridview is filtered

gauthee17-Jul-07 2:37

gauthee

17-Jul-07 2:37

How are you providing value to @Name?

Gautham

Re: Gridview/DropDownList problem. Simple problem, I think

aqzman_17-Jul-07 2:43

Re: Gridview/DropDownList problem. Simple problem, I think

17-Jul-07 2:43

Hi, thanks a lot for your reply!

I never changed any code with the dropdownlist, and that's where I thought where the value was getting assigned to @Name. I just noticed that not all the code for the drop down list is getting displayed in my first post for some reason.

Here is the drop down list code.

<asp:DropDownList ID="myDropDownList" runat="server"
DataSourceID = "myFilteringDataSource"
DataValueField = "Name"
AutoPostBack = "True" DataTextField="Name"
/>

gauthee17-Jul-07 2:50

gauthee

17-Jul-07 2:50

Hi,

I want you to check your command text, i.e. your select query.
In your select query after the and condition you are using the variable @name , how is the value getting substituted to that @name?
Dont you have to add this parameter to the command?

Gautham

Re: Gridview/DropDownList problem. Simple problem, I think

aqzman_17-Jul-07 2:59

Re: Gridview/DropDownList problem. Simple problem, I think

17-Jul-07 2:59

Thanks again for the reply.

Well this is actually sort of strange, but good at the same time I guess. I made of copy of that page when it was working and it was saved in a folder, so I forgot about it. Anyway, that page is working fine, but the strangest thing is that I carried over all the code, and even checked the settings, they all match. One works, and the other doesn't.

There is no value getting put into the @name on either page, the only time the actual phrase "@Name" is being used is in the selet query.

Should I just write some code to assign the currently selected item in the drop down list to the @Name instead of just wondering how one page works? Haha.

Thanks,
aqzman

gauthee17-Jul-07 3:07

gauthee

17-Jul-07 3:07

What i would say first leave the form with its functionality working then start your research and try to pass the value.

But strange though!!! OMG | :OMG:

Gautham

Re: Gridview/DropDownList problem. Simple problem, I think

aqzman_17-Jul-07 3:10

Re: Gridview/DropDownList problem. Simple problem, I think

17-Jul-07 3:10

Yup, I'll just throw everything on the working form. Thanks for the help!

sidbaruah17-Jul-07 18:45

sidbaruah

17-Jul-07 18:45

SelectCommand="
Declare @Name varchar
SELECT *FROM tblCallers, tblTicket, tblUsersWHERE tblTicket.TicketID = tblCallers.TicketID AND tblTicket.UserID = tblUsers.UserID AND tblUsers.Name = @Name";

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

To create Installer file.

Sam.M17-Jul-07 2:28

Sam.M

17-Jul-07 2:28

Hai there..

I created one installer file, that'll check AJAX Extensions registry file and if it's not there it'll install Ajax Extensions amd if it's there it'll install my appliation.

Now wat is the problem is: it's checking correct and installing Ajax if it's not there, but it's not installng my application once it's finished. If already AJAX is installed means then only it's installing my application. But i want this two things to be installed in one setup. I'm using SearchFor and Launch Condition. Please help...

Regards n Thks

Sam.M

adding Marquee

mavii17-Jul-07 2:16

mavii

17-Jul-07 2:16

how to add marquee (scrolling text) in asp.net page, i am using ASP.NET WITH C#, i have found no control in visual Studio 2005, i am designing a desktop application along with website

Sathesh Sakthivel17-Jul-07 2:20

17-Jul-07 2:20

Use AdRotator control instead of Marquee.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Mubashir Javaid17-Jul-07 2:41

Mubashir Javaid

17-Jul-07 2:41

<marquee>Hello

God Bless you.
Always do good to others

Vasudevan Deepak Kumar17-Jul-07 4:06

Vasudevan Deepak Kumar

17-Jul-07 4:06

He is actually looking at a desktop application I guess.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Vasudevan Deepak Kumar17-Jul-07 4:07

Vasudevan Deepak Kumar

17-Jul-07 4:07

mavii wrote:
website

Marquee Tag for MSIE.
You can check out cross-browser marquees in http://www.dynamicdrive.com/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

sidbaruah17-Jul-07 18:48

sidbaruah

17-Jul-07 18:48

In page design you can add the marquee tag i guess with the text!!
I have used that it works!!!

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Highlight Search Terms

wEb GuRu...17-Jul-07 2:09

wEb GuRu...

17-Jul-07 2:09

Hey Guys

How can I highlight search terms on my website. By search terms I mean the keywods used by users on Search Engine to reach my site. Thanks for your time.

You may find example of such highlighting from: http://search.yahoo.com/search?p=webmasterworld+highlight&fr=yfp-t-501&toggle=1&cop=mss&ei=UTF-8[^]

All the way from Sialkot ...

Sathesh Sakthivel17-Jul-07 2:15

17-Jul-07 2:15

Highlighter[^]

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

wEb GuRu...17-Jul-07 2:21

wEb GuRu...

17-Jul-07 2:21

Thanks dude

Will it work for ASP.net 2.0 too???

All the way from Sialkot ...

Sathesh Sakthivel17-Jul-07 2:27

17-Jul-07 2:27

Yes.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Mircea Grelus17-Jul-07 3:27

Mircea Grelus

17-Jul-07 3:27

It will only work if you install PHP on IIS[^].
There are other simpler options available like the SeeSearchWords control[^].

Cheers,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

uploading file.

Milind Panchal17-Jul-07 2:00

Milind Panchal

17-Jul-07 2:00

Urgent!!!!!!!

I want to upload image by drag and drop means I want to drag the image diectly from external folder and drop to webform instead of browse the image by using UploadFile control.And then upload it.
Another thing is droped images should be in thmbnail form.

which control I have to use or which software I have to use for this purpose.

If possible can any one send me sample code ?

Re: uploading file.

Sathesh Sakthivel17-Jul-07 2:11