Search results for query: *

Thanks Alex....I used to work with oracle and we always had to use lower/upper for user parameters. I thought it would be the same for sql server. Thanks!!!

Hello, I have the following select statement: select a.name, a.address, a.telephone, b.jobtitle from person a, job b where a.jobtitleid = b.jobtitleid and b.name = "jack" How can I change it so that it looks for all cases of the name (i.e jack, Jack, JACK, etc...) Can I do the following or...

Thank you all very much for the in-depth explanation. I learned several new things today...Thanks again...

Thanks Denis....I was told by my manager that we need to prefix our procs with sp_. Can you please tell me why it shouldn't be prefixed this way?

Hello Denis, Thanks for your reply. I am calling this procedure by using the command below: exec sp_GetPerson Smith Smith is the parameter input required (last name of person). When I use Le-Ann it will give me the error.

Hello, I am using SQL Server 2005. I have a stored procedure that requires a parameter at execution - employee name. When I type in any name like donald, mike, john then it works fine. But when I use name like Sarah-Lee with a hypen, it gives me the error even though I've declared the...

Hi everyone, I added the database name dot owner dot table and it worked. Thanks, Kathy

Hello, I am using SQL Server 2005 and have the following select statement inside a stored procedure. The stored procedure has a bunch of other selects that select from tables in the test1 database and the sp is being run against test1 database. The table in the select statement below is in...

Thanks jbenson....

Hello everyone, I am new to SQL Server. We're currently using SQL Server 2005. Please see example below: create procedure proc4 (@p1 char(15), @p2 char(20), @p3 int) as insert into Workers values (@p1, @p2, @p3) go Is there a way to write the code so that it prompts the user to enter in...

Thank you adamroof and ca8msn. It turns out that there was something wrong w/the query. It works fine now....thanks guys..

Hello ca8msn. Everything was working as expected until I added the if condition today. It still works but instead it redirects the user to the Default.aspx page regardless of correct or incorrect login. Is that what you were asking ca8msn? If not...sorry...

Hello everyone, Please see the line in bold below. I am trying to redirect the user to the Default.aspx page if the query from the typed data set (Criteria) returns at least a row. However, I am putting in usernames and passwords that do not exist in the 'People' table and it still goes true...

Thank you both very much. It worked!!!

Tipgiver - .GetDataBy is a method that was created through the TableAdapter Query Configuration Wizard. I created a query to pull all records of the people table based on the Username and Password parameters provided. When I plug in actual fields like "abc", "password" (these are actual...

Thank you tipgiver for your tips. I tried passing the texts of the textboxes but that still didn't work. I'm getting the error - "Object reference not set to an instance of an object". I am very new to .net and didn't understand how to try out your second tip. Thanks again, Kathy

Hello everyone, I am using VS2005 (C#) and have the following code behind for my login page. When I try to compile it, I get the following error on the line in bold below. Seems like I need to convert "UserName" and "Password" to strings. Can someone please help me with this? Thanks...

Hello, I am trying to learn typed data sets in VS2005. I have the following code behind. I am not sure if I'm calling the data sets correctly or not. I would also like to add a piece of code after the bold text below to check if the results return >1 then to redirect the user to a page...

Hello Prashant, Thank you for your reply. I actually figured it out. I changed "CodeBehind" to "CodeFile" on the first line and it worked. However, when I compile it now, I get an error on the line below: Error: NullReferenceException was unhandled by user code Object reference not set to...

Hello everyone, I'm very new to asp.net so please be patient w/me. I have a login page called login.aspx that has the following line below. When I try to compile it, I get the error - Could not load type 'LoginPage.WebForm1'. The namespace LoginPage and class WebForm1 exists on the code...