Unable to extract data from sql database to a website when hosting

Question

1.00/5 (1 vote)

See more:

, +

I've developed a web form with 2 dropdown lists (UserID, accounts), when I select a userID in one dropdown, the other dropdown retrieve data from SQL databse & fills the dropdown with all accounts that paticular user have. It worked properly untill I have made a slight change in the table, I've addded a new column to my table which is not applicable for this web form. Now the web form works if I debug it in my PC, but it doesn't fill out "accounts dropdown" when I host it in server & run it from another PC. Help me with this issue.

XML

<identity impersonate="true"/>
    <authentication mode="Windows"/>

I have added above lines to web config as well.

Posted 11-Sep-12 20:19pm

WebMaster

Updated 11-Sep-12 21:41pm

Kuthuparakkal

v3

Add a Solution

Comments

Kuthuparakkal 12-Sep-12 3:42am

I have removed "Urgent Please Help" from your question...

Kuthuparakkal 12-Sep-12 3:43am

Need more details, table, store proc if any etc.. exact error if any

[no name] 12-Sep-12 3:53am

there is only 1 table with 4 columns. userID,name,account,address.. when user selects the user ID from 1st dropdown, it is supposed to load all the accounts that he has. It was working properly until i add that last column (address). But it has nothing to do in this web form

Kuthuparakkal 12-Sep-12 3:54am

how do you retrieve data ? Query, Stored Proc, and code for drop down bindin

[no name] 12-Sep-12 4:00am

drop down binding
SELECT [account] FROM [tblAccountDetails] WHERE ([userID] = @userID)

Kuthuparakkal 12-Sep-12 4:04am

I am very poor at guessing your code, post full details Or
1. Check conn string
2. Do remote debugging
3. Continue debugging till it resolves.

Kuthuparakkal 12-Sep-12 4:05am

You can also use Fiddler

[no name] 12-Sep-12 4:53am

as i told you nothing wrong with the program when it debugs from my PC. it works perfectly. Only thing is that drop down list doesn't fill when the userID is selected ONLY WHEN I RUN IT FROM A REMOTE PC THROUGH THE WEB ROOT... There's nothing in the coding, only things are sql data bindings

[no name] 12-Sep-12 4:01am

This was working perfectly & still it works when i debug it in my PC. problem is that doen't get account values from DB when i host it & run it from another PC.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)