|
Hi,
I'm in desperate need of help. I'm very new to C# and have only limited exposure to ASP.NET. I'm developing a win form application.
Basically, the user clicks a button and imports a text file into a sorted checkedlistbox. That works so far.
The text file will hold a list of IDs that need to be retrieved from a table in my DB. I have a stored proc in the db that does the same but when I ran that via GetStoredProcCommand, I'm getting 'Array out of Bounds' exceptions.
I've tried GetStoredProcCommandWithSourceColumns, GetStoredProcCommand, ExecuteReader, and AddInParamter, all of which won't work. I know I'm making it harder than it really is since I'm also using VS2008. If stored procs won't work, I will settle for a regular select * from table where user = CheckedlistBox.CheckedItem as well. Once I have the users I need to work with, I have several stored procs that should be run depending on the what control the user clicks. I just don't why it's not working trying to run a simple proc. Thanks in advance for your help.
I've read, read, and researched every place I could before posting here as well.
Code below
//code to load/process IDs (from import to checkedlistbox) with a stored proc in a sybase table
private void ProcessListbutton1_Click(object sender, EventArgs e)
{
try
{
//open up database connection
Database _db = DatabaseFactory.CreateDatabase();
foreach (object sysuser in CheckedListBox1.CheckedItems)
{
DbCommand cmd = _db.GetStoredProcCommand("sp_ust_user_retrieve");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message) ;
}
-----------------------------
//import text file into Checkedlistbox
private void Importbutton1_Click(object sender, EventArgs e)
{
this.checkedListBox1.Items.Clear();
//this.checkedListBox1.GetItemCheckState();
OpenFileDialog Open = new OpenFileDialog();
Open.Filter = "Text Document|*.txt|All Files|*.*";
try
{
Open.ShowDialog();
StreamReader Import = new StreamReader(Convert.ToString(Open.FileName));
while (Import.Peek() >= 0)
checkedListBox1.Items.Add(Convert.ToString(Import.ReadLine()));
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex.Message));
return;
}
this.checkedListBox1.BeginUpdate();
for (int x = 0; x < 0; x++)
{
this.checkedListBox1.Items.Add(x.ToString());
}
for (int x = 0; x < this.checkedListBox1.Items.Count; x++)
{
this.checkedListBox1.SetItemChecked(x, true);
}
this.checkedListBox1.EndUpdate();
I've tried databinding directly from the checkedlistbox and it returned all rows in the table - and overwrote what I imported. I only need to return rows from that table that are checked.
I hope this was clear. If not, please be patient with me and I will post whatever is needed. 
|
|
|
|
|
[rant]There you go using those bloody build in data management thingies, why does MS do this all the time, if you feed a newbie a GetStoredProcedureAndMakeItWork widget how are they expected to learn to actually work with a database.[\rant\
Please do the following. Learn what a Data Access Layer (DAL) is. This will sit between your code and the database (you need to write or snaffle one). This should be the tool you use to manage the data. Most developers will then use an Object Relationship Map ORM (often a table) class to represent your data. Your orm gets the data from the DAL and you can bind the orm to the UI in 2008.
This way YOU manage the data, you understand the ins and outs of the data not some black box in VS.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I wasn't looking for a sarcastic answer but rather a real suggestion of what I should/shouldn't be doing to guide me in the correct direction.
If anyone can help, please reply. Thank you.
|
|
|
|
|
And you wonder why after 24+ hours you have no helpful supportive answer. Most "developers" will not be able to help with these MS supplied tools, simply because we don't use them. As for a senior dev pointing you in this direction, I would suggest the 5yrs may have been wasted.
The description of a DAL was meant to be helpful not sarcastic. Because of your moniker and the quality of the question I assumed you had no idea. Then again if you iknow what it is why ae you using the MS widgets to do your work!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: I assumed you had no idea.
Safe assumption 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
And also, the previous code for that was suggested by a Sr. colleague who's been doing .NET deveoplment for at least 5 years now. He obviously knows what a DAL is and so do I. Rather than insulting him, I thought I would look here first because someone could provide
some guidance. Thanks. 
|
|
|
|
|
Hi,
I had written a webservice.Now I need help to accompolish the following goals..
1.How to host the webservice?..since this i have to use in windows application.
2.How to consume this webservcie through the C#.net windows application.
My task is to write the Webservice,using this I will pick some data and that data I have to pass to a windows application/windows service where I will update the database.
|
|
|
|
|
... and don't cross post either - see C# 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi everyone,
I have written an application in c# .net 2.0 where i can convert a word2007 document to a pdf file...
But now i have to do the same thing for word2003 and i dont wanna change alot on my code. Coz the reference i add it is for office 2007 and if i remove it nothing works obviously...so i just want to add another reference for 2003 and include a method.
Is there anybody out there
who did this already? Please let me know if anyone can help me out!!!
Thanks n regards argun
|
|
|
|
|
Have you looked at any third party components? You may want to google around and I am sure something comes up. Better yet, do an article search on this site, I recall seeing an article using OpenOffice to generate pdf files in C#/VB.NET...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi Paul,
Well ya that is the problem i cannot look for a third party, to keep the cost low. And well i guess i have to google around to find the answer. Or like the good old times do it urself
Thanks anyway but ya still would be great if there is a solution for my problem out there.
|
|
|
|
|
Argunsun wrote: i cannot look for a third party, to keep the cost low
I hear you.
Generate PDF From C#[^] is the article I think I mentioned a little while ago. Worth looking at
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi
please i want to create a AVI or WMV clip from a set of bitmaps images, i
am useing vb.net 2003 can any one help thanks.
Mohammad Al Hoss
|
|
|
|
|
You will have to resort to a third party SDK, their is no such capability in .NET. DirectX would be my suggestion.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
|
Hi,
I'm trying to find out if this is possible, and if so how to do it. From a machine running XP or Vista, as I understand it, when you send something to print, Windows/the print drivers render the file into a format the printer can read and understand (a spool file?). This file is sent to the printer then the local copy is deleted. I believe this file is held briefly in the 'C:\WINDOWS\system32\spool\PRINTERS' folder, which is effectively the shared print queue folder. for all printers on that machine.
My question is whether you can capture this 'raw' spooler data (I've managed to copy and paste to capture the files that appear in the spool folder, but you have to be fast!), and crucially, once you've captured it, can you then somehow send it to print again?
I have a feeling this is more complicated than I think. Presumably there are different formats of spooler data etc? Is there a utility that can do the printing/viewing of captured files?
|
|
|
|
|
I don't know wht is user control and custom control in windows form
If anybody knows this concept plz explain with example and difference between both
Regards,
Ashwini
|
|
|
|
|
Hi Ashwini,
"Custom" Controls: Controls that display UI by making calls to a Graphics object in the paint event. Custom controls typically derive from RichControl. A Chart control is an example of a custom control. There is limited design time support for creating custom controls.
"User" or Composite Controls: Controls that are composed of other controls. User Controls derive from UserControl. A control that displays a customer address using TextBox controls is an example of a User Control. There is full design time support for creating user controls using the WinDes application."
For information on User Controls and Custom Controls for WebForms, please refer to this [^] Link.
Hope this helps.
Vinay
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
|
Where are you getting RichControl? Or do you mean UserControl? I have never seen a RichControl in .NET before.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
I created an application that opens Word documents inside an axwebbrowser object in the windows form. However, if i run 2 instances of the application and open 2 files - FileA.doc and FileB.doc, i lose control of the toolbar icons on FileA.doc as soon as i open FileB.doc in the second instance of the application....ie... i am no longer able to click on the toolbar buttons. The toolbar buttons are visible but do not function and cannot be clicked on. Please help.
|
|
|
|
|
Hi,
I am currently working on a WinForms application in which I am displaying database table in DataGridView control.
I want to implement feature of record locking when a user starts modifying a row in the DataGridView. In such case, the system should give alert message to other user that someone else has already opened the record for editing.
Also, when two users try to save the same record, the first to click save button will get access & the second user will get message that record has already modified by someone.
How can this be done? If anyone can share the code for this then it would be great.
Thanks in advance,
HR
|
|
|
|
|
You are not going to get any code for this as it is a philosophical question.
First thing to ask is this a real world situation, lots of business people raise this sort of ? when in reality it almost never happens.
Second, think about how your system works,
You get a set of records (no lock) that are copies of the data and not connected to the database.
Now the user begins editing, you want the UI to inform the database the records is being edited, the database must retain the identities of all the users who have a copy of the record and inform them that the record is being edited.
Now the user either cancels the edit of saves the record the UI must save back the record, first checking that this is the master copy and should be locked!
When the record is saved the adta should be pushed to the other holders of the record.
The above scenario is a nightmare of pushmepullme horrors.
Answer the first question, and then if it is still an absolute requirement then I suggest the following design.
Do not allow in grid editing. Make the user open a dialog with the 1 record to be edited. If you think this is unreasonable I have 5 major apps in production and there are precisely 2 forms with inline editing. You then lock the record as being edited when passing it to the dialog (use a flag on the record). Only when a SECOND person attempts to edit the exact record do you actually need to do anything, ie tell the second user it is a read only record! If you flag it with an ID you can tell the second use who has it locked.
Caveat - you will inevitably end up with incorrect falgs on records (incomplete edits) make sure you have a maintenance program to clear them down.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Excellent answer. Well put.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi
Am creating setup project for my application
how to make my primary output shortcut to be installed to all users of the system.
Thanks for the help
ngrj
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
