Click here to Skip to main content
15,903,175 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Problem Pin
koolprasad200318-Jul-07 1:06
professionalkoolprasad200318-Jul-07 1:06 
QuestionDisplay Problem Pin
.NET- India 17-Jul-07 3:48
.NET- India 17-Jul-07 3:48 
AnswerRe: Display Problem Pin
Vasudevan Deepak Kumar17-Jul-07 4:03
Vasudevan Deepak Kumar17-Jul-07 4:03 
QuestionPassing stringbuilder from code-behind to vbscript Pin
manowj17-Jul-07 3:15
manowj17-Jul-07 3:15 
AnswerRe: Passing stringbuilder from code-behind to vbscript Pin
Vasudevan Deepak Kumar17-Jul-07 4:04
Vasudevan Deepak Kumar17-Jul-07 4:04 
AnswerRe: URL Rewriting Pin
Sebastian T Xavier17-Jul-07 3:02
Sebastian T Xavier17-Jul-07 3:02 
QuestionURL Rewriting Pin
Brendan Vogt17-Jul-07 2:40
Brendan Vogt17-Jul-07 2:40 
QuestionGridview/DropDownList problem. Simple problem, I think [modified] Pin
aqzman_17-Jul-07 2:30
aqzman_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
AnswerRe: Gridview/DropDownList problem. Simple problem, I think Pin
gauthee17-Jul-07 2:37
gauthee17-Jul-07 2:37 
GeneralRe: Gridview/DropDownList problem. Simple problem, I think Pin
aqzman_17-Jul-07 2:43
aqzman_17-Jul-07 2:43 
GeneralRe: Gridview/DropDownList problem. Simple problem, I think Pin
gauthee17-Jul-07 2:50
gauthee17-Jul-07 2:50 
GeneralRe: Gridview/DropDownList problem. Simple problem, I think Pin
aqzman_17-Jul-07 2:59
aqzman_17-Jul-07 2:59 
GeneralRe: Gridview/DropDownList problem. Simple problem, I think Pin
gauthee17-Jul-07 3:07
gauthee17-Jul-07 3:07 
GeneralRe: Gridview/DropDownList problem. Simple problem, I think Pin
aqzman_17-Jul-07 3:10
aqzman_17-Jul-07 3:10 
AnswerRe: Gridview/DropDownList problem. Simple problem, I think Pin
sidbaruah17-Jul-07 18:45
sidbaruah17-Jul-07 18:45 
QuestionTo create Installer file. Pin
Sam.M17-Jul-07 2:28
Sam.M17-Jul-07 2:28 
Questionadding Marquee Pin
mavii17-Jul-07 2:16
mavii17-Jul-07 2:16 
AnswerRe: adding Marquee Pin
Sathesh Sakthivel17-Jul-07 2:20
Sathesh Sakthivel17-Jul-07 2:20 
AnswerRe: adding Marquee Pin
Mubashir Javaid17-Jul-07 2:41
Mubashir Javaid17-Jul-07 2:41 
GeneralRe: adding Marquee Pin
Vasudevan Deepak Kumar17-Jul-07 4:06
Vasudevan Deepak Kumar17-Jul-07 4:06 
AnswerRe: adding Marquee Pin
Vasudevan Deepak Kumar17-Jul-07 4:07
Vasudevan Deepak Kumar17-Jul-07 4:07 
AnswerRe: adding Marquee Pin
sidbaruah17-Jul-07 18:48
sidbaruah17-Jul-07 18:48 
QuestionHighlight Search Terms Pin
wEb GuRu...17-Jul-07 2:09
wEb GuRu...17-Jul-07 2:09 
AnswerRe: Highlight Search Terms Pin
Sathesh Sakthivel17-Jul-07 2:15
Sathesh Sakthivel17-Jul-07 2:15 
QuestionRe: Highlight Search Terms Pin
wEb GuRu...17-Jul-07 2:21
wEb GuRu...17-Jul-07 2:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.