Dont know how to create a storage procedure to - C# Discussion Boards

Re: getting a method progress percentage

16-Aug-12 10:50

What platform? Desktop or ASP.NET?

You load your data with a IDataReader in chuncks, using a backgroundworker[^] for instance. In the read-loop on that background thread, you check how much items/kb has passed, and update the status every 10-50 items.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Mostafa M.A16-Aug-12 11:57

Mostafa M.A

16-Aug-12 11:57

thanks for your reply
it's on a desktop platform
but how can I get the passed Items/kb from backgroundworker?

Re: getting a method progress percentage

Eddy Vluggen16-Aug-12 13:26

C# code snippet for InfoPath form

16-Aug-12 13:26

You create a loop in the worker-thread, and you read a chunk. Then you can report the ReportProgress-method to pass on any progress and/or intermediate results. The main-thread will be notified by an event, and receive both as a parameter.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

dmsWebDev16-Aug-12 5:12

dmsWebDev

16-Aug-12 5:12

I have a question about a code snippet that a author provided in an article for InfoPath 2007...how can I contact the author or can I get help by asking question here?

Here's the article: Switch Infopath Views from FormControl[^]

I realize it was written long ago - I can't get the form to start due to error...I am using VS 2008 3.5 Framework and c# and InfoPath 2007 on Win 7 64bit machine.

"Exception of type 'System.Windows.Forms.AxHost+InvalidActiveXStateException' was thrown."

It happens in this line of code:

private void formControl1_InternalStartup(object sender, EventArgs e)
{
//Handle the context Changed event.
((FormControl) sender).EventManager.FormEvents.ContextChanged += FormEvents_ContextChanged;
}

modified 16-Aug-12 11:21am.

Re: C# code snippet for InfoPath form

Wes Aday16-Aug-12 5:19

Wes Aday

16-Aug-12 5:19

Member 9360291 wrote:
how can I contact the author

You can contact the author by posting on the article's message board at the bottom of the article.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Re: C# code snippet for InfoPath form

dmsWebDev16-Aug-12 5:30

dmsWebDev

16-Aug-12 5:30

Thanks. I guess I was being stupid, I didn't scroll down the page far enough to notice the message board. Sorry about that (new to site is my only excuse). You can delete my post if necessary.
Doreen

Dont know how to create a storage procedure to

paddymega16-Aug-12 1:39

16-Aug-12 1:39

I am making a project in c# with sql on electoral database that consists of 5 fields ie name, dob, family size, etc etc. Now i'm currently unable to create a storage procedure to edit the data in the database, as am unable to understand how to pass the parameter to receive the value being passed from the program. Searching the net hasn't helped me. Can someone assist me with this?

I have uploaded the project with the database, it can be accessed at https://rapidshare.com/files/1397492724/WindowsFormsApplication2.rar[^]

Shameel16-Aug-12 1:41

Shameel

16-Aug-12 1:41

You're probably talking about a Stored Procedure[^].

paddymega16-Aug-12 3:00

16-Aug-12 3:00

@Shameel: Absolutely. Sorry, i keep typing the wrong name. :P

@Eddy Vluggen: This is for console applications, and more importantly doesnt edit data. It adds, which i am already able to do. My requirement is to edit the data in a form.

Say, a user loads the data. He finds some error. He makes the change, and clicks on edit data, and its done.

Eddy Vluggen16-Aug-12 3:12

16-Aug-12 3:12

paddymega wrote:
@Eddy Vluggen: This is for console applications, and more importantly doesnt edit data. It adds, which i am already able to do. My requirement is to edit the data in a form.

..does the type of application change the way we talk to a database?

You're adding data by executing an insert statement? Updating is done the same way, with an update statement. Where are you stuck, and what code do you already have?

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

paddymega16-Aug-12 5:11

16-Aug-12 5:11

CREATE PROCEDURE EDITROW (INT naim, INT aig, INT fmno, INT doab)//these are the parameters being received by the program to the procedure

@age INT,//parameters from the database no wonwards
@name VARCHAR(30),
@familymemno INT,
@DOB int,//end of parameters from the database

AS

UPDATE elecdb
SET naim=@name, aig=@age, fmno=@fammemno, doab=@dob
WHERE @DOB=doab; //update query
RETURN

I just want that the query matches the data in the databse to the data being passed on from the program and update it in the database

Eddy Vluggen16-Aug-12 5:24

16-Aug-12 5:24

Looks like a reasonable update-statement, and looks like a sproc. I assume that it creates the procedure correctly, or did you get an error?

If the proc is correct, you hook it up to a SqlCommand and set the parameters. You'll probably already have something similar in the insert-statement.

The only thing that bugs a bit is the DateTime that seems to be used as a primary key. I suggest using an identity-field, an auto-incrementing integer. See, the dob might contain a specific time, and that would make it "hard" to find it in the database - a mismatch of a second, and it'll say the record can't be found.

paddymega wrote:
I just want that the query matches the data in the databse to the data being passed on from the program and update it in the database

Programming is not an easy task; we're already skipping corners here Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

paddymega16-Aug-12 6:00

16-Aug-12 6:00

nope, it's not getting saved. Shows error near ) , god knows what error. U can see it for yourself, i have uploaded the whole project on https://rapidshare.com/files/1397492724/WindowsFormsApplication2.rar[^] Though i had not saved this as the stored procedure named "editproc"

Eddy Vluggen16-Aug-12 6:20

16-Aug-12 6:20

paddymega wrote:
Shows error near ) , god knows what error.

If it "shows", then besides God, you could know too what it says. God would speak of a syntax-error here;

SQL

CREATE PROCEDURE EDITROW (INT naim, INT aig, INT fmno, INT doab)//these are the parameters being received by the program to the procedure

@age INT,//parameters from the database no wonwards
@name VARCHAR(30),
@familymemno INT,
@DOB int,//end of parameters from the database
 
AS

UPDATE elecdb
SET naim=@name, aig=@age, fmno=@fammemno, doab=@dob
WHERE @DOB=doab; //update query
RETURN

Are @age, @name etc. part of the parameter-list? If yes, then they should be declared before the ) mark. If not, then they should be declared in the body of the stored procedure, below the "AS" keyword. Something like this probably;

SQL

CREATE PROCEDURE EDITROW (INT @naim, INT @aig, INT @fmno, INT @doab) 
AS
BEGIN
  UPDATE elecdb             // this is not a comment, this style will create a syntax error too!
     SET name=@naim,        -- this is a comment
         age=@aig,          /* or this */ 
         fammemno = @fmno, 
         dob = @doab
   WHERE dob = @doab; 
END

The parameters in the UPDATE statement (the ones with the @-sign) need to match those at the top; the other names are the fieldnames, as defined in the elecdb-table.

I'm at home, on a Linux-laptop. I could open the archive, but there's no Sql Server to run it against.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

paddymega16-Aug-12 7:29

16-Aug-12 7:29

Oh yes, u're right . My bad :P

The // was added for you guys only, so that the logic could be better viewable for u.

ps: The error's still there. The error is "incorrect syntax near INT, must declare the scalar variable @naim"

Eddy Vluggen16-Aug-12 8:30

16-Aug-12 8:30

paddymega wrote:
The error is "incorrect syntax near INT, must declare the scalar variable @naim"

You could look up the syntax in the documentation[^]. I'm guessing that the parameters need to be declared like in the documentation; the example I gave was not tested, and according to the docs, the parametername should precede the type, like this;

SQL

CREATE PROCEDURE EDITROW (@naim INT, @aig INT, @fmno INT, @doab INT) 
AS
BEGIN
  UPDATE elecdb             
     SET name=@naim,        
         age=@aig,          
         fammemno = @fmno, 
         dob = @doab
   WHERE dob = @doab; 
END

If you have more errors, feel free to post them; but please include your actual version of the code, and the error-message; that way you'll get the most (useful) replies.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

paddymega16-Aug-12 8:36

16-Aug-12 8:36

saved now.Thanks Big Grin | :-D

Eddy Vluggen16-Aug-12 8:37

16-Aug-12 8:37

You're welcome Smile | :)

Eddy Vluggen16-Aug-12 1:59

how to how message from window serviece

16-Aug-12 1:59

Tutorial[^]

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

ashjassi16-Aug-12 1:27

ashjassi

16-Aug-12 1:27

I want to know how to show message from window serviece

Eddy Vluggen16-Aug-12 1:34

16-Aug-12 1:34

Windows services do not display messages. At all.

A service is something that runs before the user even logs on; that means that there is no user to view your message, and no desktop to display it. The service even runs under a different account; open "Services" from the Admin-section in the config-panel, find your service, look at the second or third tab; that's where the username/password is specified for the account that the service is running under.

The default approach is to create a second app that runs under the users' credential, and have it communicate with the service. I'd recommend TCP/IP for that, but there are more ways to communicate.

Main question here is whether you actually "need" a service. So, what does your service do, and how would a "message" look like?

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Wes Aday16-Aug-12 1:35

Wes Aday

16-Aug-12 1:35

ashjassi wrote:
show message

If you mean show a messagebox, you don't. Services do not interact with users by design.

Shameel16-Aug-12 1:47

Shameel

16-Aug-12 1:47

As already stated, a Windows Service is designed to run in the background without a UI and is best suited for tasks that do not need user interaction or even a user session. If at all you have to show a message and interact with the user, you may consider writing a windows application instead of a windows service.