Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cyberjay82

    Is this stored procedure code right?

    Yes, they contain wildcard characters. The size of each param is greater than the string that is going into each param. Thanks.
  2. cyberjay82

    C# & SQL - Stored Procedures

    I still don't get any records but here is an update of code. This is the new and Updated Stored procedure: CREATE PROCEDURE [dbo].[Search] (@param0 nvarchar(100), @param1 nvarchar(50),@param2 nvarchar(100),@param3 nvarchar(100),@param4 nvarchar(100),@param5 nvarchar(100),@param6 nvarchar(50))...
  3. cyberjay82

    Is this stored procedure code right?

    I still don't get any records but here is an update of code. This is the new and Updated Stored procedure: CREATE PROCEDURE [dbo].[Search] (@param0 nvarchar(100), @param1 nvarchar(50),@param2 nvarchar(100),@param3 nvarchar(100),@param4 nvarchar(100),@param5 nvarchar(100),@param6 nvarchar(50))...
  4. cyberjay82

    C# & SQL - Stored Procedures

    I have also did ExecuteReader method with: connection.Open(); SqlDataReader reader; reader = sqlDataAdapter.SelectCommand.ExecuteReader(); while(reader.Read()) { MessageBox.Show(reader.GetString(0)); } MessageBox.Show(reader.GetString(0)); //to make sure reader.Close()...
  5. cyberjay82

    Is this stored procedure code right?

    I have changed things just like you said to match my sizes and still nothing happens.
  6. cyberjay82

    C# & SQL - Stored Procedures

    I decided to ExecuteNonQuery like this right before I call the fill method: int counterR = 0; sqlConnection1.Open(); counterR = sqlDataAdapter1.SelectCommand.ExecuteNonQuery(); MessageBox.Show(counterR.ToString()); sqlConnection1.Close(); I got -1 records affected. Something is not right...
  7. cyberjay82

    Is this stored procedure code right?

    I haven't done anything with a return value or anything like that, does the fill method take care of that with the dataset or is that where my error is.
  8. cyberjay82

    C# & SQL - Stored Procedures

    I haven't done anything with a return value or anything like that, does the fill method take care of that with the dataset or is that where my error is.
  9. cyberjay82

    Is this stored procedure code right?

    Yes I have and I'm getting good advice but still nothing is working right. I don't know. I'll keep trying. If you get any more advice, I'll be happy to listen. Thanks.
  10. cyberjay82

    C# & SQL - Stored Procedures

    Sorry, I still get nothing. I just can't figure this one out. I'll keep trying and if you have any more advice, I'll be happy to listen. Thanks.
  11. cyberjay82

    Is this stored procedure code right?

    All my data types are nvarchar and I have put it through the query analyzer and it works. I have made sure my variables are holding the right data then set the params in my c# code and then checked the params to make sure. But I still get no records. I just can't seem to figure this out. Thanks...
  12. cyberjay82

    C# & SQL - Stored Procedures

    I did what you said to do and they are all holding the right values but I still get no records. I have also don't have any more <NULL> values being selected either. That didn't fix it either. I don't know what is wrong I must have something either set wrong or the stored procedure is wrong or...
  13. cyberjay82

    C# &amp; SQL - Stored Procedures

    I have tried it in the query analizer, and it works when I pug in the params with my own data, but when I use the params and pass the text to them it doesn't work, its as if the text is not getting passed right.
  14. cyberjay82

    Is this stored procedure code right?

    Please let me know if my stored procedure code is right. Here is my stored procedure in my sql database: CREATE PROCEDURE [dbo].[Search] (@param0 nvarchar, @param1 nvarchar,@param2 nvarchar,@param3 nvarchar,@param4 nvarchar,@param5 nvarchar,@param6 nvarchar,@param7 nvarchar) AS SET NOCOUNT ON...
  15. cyberjay82

    C# &amp; SQL - Stored Procedures

    Here is my stored procedure in my sql database: CREATE PROCEDURE [dbo].[Search] (@param0 nvarchar, @param1 nvarchar,@param2 nvarchar,@param3 nvarchar,@param4 nvarchar,@param5 nvarchar,@param6 nvarchar,@param7 nvarchar) AS SET NOCOUNT ON; SELECT Number, PartNumber, Description, Cost, Quote...

Part and Inventory Search

Back
Top