I don't think this is a coding problem, as there isn't much code to it, but I'm not quite sure what's wrong. I am using visual studio 2008, programming with vb.net using a sql express 2005 database. I create stored procedures by right clicking on the database in my data connections and under stored procedures, i hit add new. I create stored procedures in there, save them, and call them using Me.MyDataTableAdapter.StoredProcedureName, I've used this for about 5-6 stored procedures, on the 7th stored procedure I created, when I type in My.MyDataTableAdapter.StoredProcedurename, it gives me the error in intellisense that the stored procedure doesnt' exist, I forget exactly what the error is but it was something to that extent. Is there some kind of limit on sql servers and how many stored procedures i may create or something? Because i also tried copying and pasting the code in one of my existing stored procedures, and then creating a new one with that code (thinking that maybe my code caused the stored procedure to not get recognized) but this was not the case either. I tried restarting as well (visual studio has randomly stopped associations between objects before, and fixed itself after restarting) any ideas on what i can do to fix this? Also, I just plain tried creating another stored procedure as well and no luck. Sorry for the lack of details but I really don't know what else to say because there was really no code involved, just " My.MyDataTableAdapter.StoredProcedurename" and the act of creating stored procedures.
Thanks!
edit: fixed problem, i guess i forgot to add the stored procedure in the dataset designer ..
Thanks!
edit: fixed problem, i guess i forgot to add the stored procedure in the dataset designer ..
Last edited:
