Hi,

I am getting an error when trying to use ModuleID and UserId in a query, If I put them into a label to show up on the page, they show up correctly, but as soon as I do:

cmd.Parameters.Add(new SqlParameter("@prmModuleID", SqlDbType.Int)).Value = mod;
cmd.Parameters.Add(new SqlParameter("@prmUserID", SqlDbType.Int)).Value = userID;

(mod and userID are defined earlier in the code)

I get the following error: Incorrect syntax near 'ModuleID'.  if I remove the add param to moduleID it changes to Incorrect syntax near 'UserID'

the line of code it is saying the error is occuring on is: SqlDataReader rd = cmd.ExecuteReader();

has anyone experienced this issue before?

Thanks,

Chris

What are the database column data types of ModuleID and UserID? Are they int or one of the character string types?

Although I don't usually build queries by string concatenation, it appears that you need spaces before FROM and before WHERE in the second two statements:

String sql = "SELECT [ItemID], [ItemName], [CategoryName], [ModuleID], [UserID]";
sql = sql + " FROM Items INNER JOIN Categories ON Items.CategoryID = Categories.CategoryID";
sql = sql + " WHERE ModuleID = 423 AND UserID = 1";

Finally, I assume that you are hardcoding 423 and 1 in the WHERE clause for testing purposes and will replace those by the parameter names.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner

Dear Sir's

I want to develop my one module, i want to know show one of my data base table to one's how are login as Register User.
Can Any one help me know, which code check the user login and user ID?
What is the file name , and how should i use it in my code?

Many Thanks