473,378 Members | 1,389 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

SQLCommand control insertion and code synchronization buggy ?

hi all, sorry this is a bit lenghty...

I am getting stucked with an unexpected behaviour of visual studio
when I insert an sqlcommand data control in a aspx page, and
after configuring it to run a stored procedure inside MSDE I have difficulties
in getting the generated part of code from VS in place.

e.g. if I change the stored procedure inside MSDE and then try to refresh it
inside VS it does not refresh the previous generated initialization code
present
in Private Sub InitializeComponent() wich is quite annoying. For example if
I add a parameter to the procedure I cannot update that code without removing
and inserting and configuraing again a new sqlcommand in the GUI.

I thought it would just need making a refresh on Server Explorer, in
stored procedures of the connection.

Most of the times the code is not generated again unless I change the name
of the control to a never used one, and then back to original.

Sometimes my code is ok but the generated code is not there so
I get errors about missing stored procedure parameters.

Entering the code by hand to declare the parameters, is quite a bit
out of question as this replicates all over my data pages

Presently I am stuck with this cause I have to debug a submiting data page
with a big update command full of parameters.

Am I doing something wrong ?
Does this have something to do with having already a lot of SQLCommands
instatiated in a single page (about forty with stored procedures)

Is this a bug ?
Jul 21 '05 #1
1 1157
just to say that I was able to get around this, but I did nothing special,
I mean, the funny behaviour seems to persist...and sometimes it happens...
sometimes not...

"joao dias" wrote:
hi all, sorry this is a bit lenghty...

I am getting stucked with an unexpected behaviour of visual studio
when I insert an sqlcommand data control in a aspx page, and
after configuring it to run a stored procedure inside MSDE I have difficulties
in getting the generated part of code from VS in place...

.....
Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

28
by: AK | last post by:
Hi, I recently read an advice here that one should try to use make and version control system even if you're the only one working on the program. Is that a good advice? How many of you do that? ...
20
by: Patrick Guio | last post by:
Dear all, I have some problem with insertion operator together with namespace. I have a header file foo.h containing declaration of classes, typedefs and insertion operators for the typedefs in...
5
by: John N. | last post by:
Hi All, Here I have a linked list each containing a char and is double linked. Then I have a pointer to an item in that list which is the current insertion point. In this funtion, the user...
4
by: Julie J. | last post by:
When working w/ forms and controls, in 95% of the cases, the value of the control is used somewhere in the program (duh!). However, there doesn't seem to be an easy way to attach a value variable...
2
by: Jan Bares | last post by:
Hi, I have found a bug in generated code in debug build. I have Visual C++ .NET 7.1.3088. Function Buggy::isBug() returns true and it should return false. The sample is contrived to exhibit the...
1
by: joao dias | last post by:
hi all, sorry this is a bit lenghty... I am getting stucked with an unexpected behaviour of visual studio when I insert an sqlcommand data control in a aspx page, and after configuring it to run...
5
by: Aggelos | last post by:
I want to start developing a simple Content Management System and having done that before I know there is a point where you can't manage different versions of applications unless you have a...
0
by: =?Utf-8?B?U3dvcmRBbmdlbA==?= | last post by:
Hello, I have a function that looks like the following: <code snippet> private void function genRegCodes(long maxid, long numOfRowsToInsert) { bool ok; SqlConnection sqlcon = new...
8
by: Brad Walton | last post by:
Hello. First post, but been doing a bit of reading here. I am working on a project in Java, but decided to switch over to C# after seeing some of the additional features I can get from C#. One of...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.