|
Hi,
I am creating new Word documents using C# (automation) and would like to save the documents to SQL Server directly (bypassing the filesystem). Has anyone tried to do this? If so, how?
I already now how to upload documents to SQL Server. I just don't know how to go from a Document object created using C# to SQL Server directly.
Thanks for any pointers,
roccom
|
|
|
|
|
you can save word document as you save image
|
|
|
|
|
I've done something similar but not exactly something what you want to do. I've storred pictures in a database bypassing the file system. I was using PHP and MySQL to do this. In the MySQL database you have to have a table that is of type BLOB. Then you need to encode your word document and store the encoded object in the database. When you retrieve it you just need to do the opposite. Sorry I'm so vague about it but it's been a while since I did this project. If you do a websearch on "storring binary objects in a database" I'm sure you will find something more specific.
|
|
|
|
|
I am using C# to develop a database application which will connect to a local MySQL (Installed on the local PC). Is there any way to add the MySQL setup within my setup project or InstalledShield X.
Many Thanks..
|
|
|
|
|
Does anybody know of a way of accessing the Administrator password for the machine that an application is running on (Win 2k and above)
I want a user to enter the admin password before being able to access certain functions of the application, so I dont need it in plain text just some method of validating it against the system.
post.mode = postmodes.signature;
SELECT everything FROM everywhere WHERE something = something_else;
> 1 Row Returned
> 42
|
|
|
|
|
|
I have created a custom control, which I am trying to programatically add to my windows form. The problem is that the control's OnPaint method is never invoked, even though the control invalidates itself on regular intervals (it uses a timer). If the control is added to my form in Visual Studio's designer, all works perfectly. However, I can't add the control in the designer because I don't know how many instances of my control I will need until my application reaches a certain point.
Any help is much appreciated!
Thanks
|
|
|
|
|
You are almost certainly overlooking some of the code the designer would create for you. Did you remember to add your new control to the form's controls collection?
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
Thank you for your reply Rob!!
Yes, I have added the control to the collection. I have tried to mimic what the designer does, but maybe I have missed some small detail anyway. Does the paint event have to be tied to something before it can be invoked after invalidation of the control? I guess the windows form's message pump is involved somehow...perhaps it is not setup properly. I don't know much about the inner workings of windows forms and their controls, so I'm quite confused.
|
|
|
|
|
A thought: does your code call the Invalidate() method of the parent control? This method has multiple overloads, three of which take a boolean parameter "invalidateChildren".
|
|
|
|
|
I managed to get my control to show up finally, but it doesn't happen the way I want to. I had not actually added the control to the form's controls collection, but instead in the DataGridTextBoxColumn.TextBox.Controls. If I add the control to the form's collection, it shows up like it should. However, this is not the way I want to do it, since my form should only be aware of the columnstyles I use, and not of the controls they may use. I've written a new thread about this with a complete sample code that illustrates the problem. I hope you can help me! Thanks!!
|
|
|
|
|
Perhaps a snippet or two of your code would help.
The implementation of the OnPaint handler, and the code used to add the control dynamically, for instance...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
Hi!
I am looking for something like image recognition in .NET.
Short story what will I do:
Imagine I have a jpeg picture with a man on it. The background is
much brighter as the man on it. Imagine it so:
You have a white paper and a black figure on it.
I will automatically add 10 textboxes on the picture. But the 10 textboxes
can not be positioned on any part of the figure.
I need a framework or a sample code to recognize the image and set automatically
the 10 textboxes of any position on the picture where the background is
white.
do you know any sample code or a open source framework that provide
me this possibility?
Regards,
gicio
|
|
|
|
|
|
Hello
You can also look here. It's very simple to find all white regions with the library.
Andrew
|
|
|
|
|
|
Hello,
I have a project that need exporting data from a datagrid to MS Word and add bullets on each line. I know how to export data to word but no idea how to add bullets to it. Is any one know how to do this? Please help me!!
Thanks in advance!!!
|
|
|
|
|
Hello,
I have DataGrid with the event defenition:
foreach( DataGridTextBoxColumn dataGridTextBoxColumn in this.styleStages.GridColumnStyles ) {<br />
dataGridTextBoxColumn.TextBox.Leave += new EventHandler(this.GridTextBoxLeave);<br />
dataGridTextBoxColumn.TextBox.Enter += new EventHandler(this.GridTextBoxEnter);<br />
<br />
<br />
<br />
}
In the Leave event I grab the current cell:
private void GridTextBoxLeave (object sender, System.EventArgs e)<br />
{<br />
DataGridTextBox dtb = (DataGridTextBox) sender;<br />
DataGridCell cell = this.dataGridStages.CurrentCell;<br />
int r = cell.RowNumber;<br />
int c = cell.ColumnNumber;<br />
int rowCount = this.getRowCount();<br />
<br />
this.dataGridStages.EndEdit(this.dataGridStages.TableStyles["Stages"].GridColumnStyles[c], r, false);<br />
Debug.WriteLine("Leave: "+r+" - "+c);}
So, if I click away the current cell is the cell that I just LEFT (which is good), however, if I use TAB key to move to the next cell, the current cell will be the one I just moved to.
How can I make TAB key press to act the same as the TextBox.Leave event?
Thank you
|
|
|
|
|
hello,
how can I convert a 24bpp Bitmap object (the I stored before in the memory) to a 8bpp?
I want to use LockBits...Thx!
|
|
|
|
|
When a TreeNode is deleted from any level in TreeView, suscribed events in TreeView are lost. Even contextual menus does not active. Any idea?
Daniel Velázquez
Mathesis Consultores
México
|
|
|
|
|
Hello,
In my datagrid, the pressing Tab key, generates ChangeCurrentCell event.
Is there a way of forcing a Leave event when you press Tab key?
Or saying the other way, can I change the event that is triggered by defualt when I press Tab key.
Thank you
|
|
|
|
|
You can call another event from the current event: Inside you code for ChangeCurrentCell, call Leave.
|
|
|
|
|
Hey Guys,
Does anyone know of any good commercial audio processing libraries which can be used with .NET (either natively or via COM)? I'm looking for something which can mix multiple input files (mp3 or whatever) into one output file.
I've already found one at http://www.nctsoft.com/products/NCTAudioStudio2/ but the only version which comes with support is $2000 which is out of our budget.
Cheers
James
|
|
|
|
|
Hello everyone.
It's similiar problem as the last thread I pasted.
Two tables invoice and order_details are related, invoice_no is the foreign key of the order_details table. When I delete an invoice, the corresponding order_details record will be deleted automatically because the delete rule is cascade. Then if I try to loop a field say "type" in order_details table like:
foreach(DataRow row in ds.Table["Order_Details"].Rows)
{
row["type"]....
}
an error happens which says "Can't access the deleted rows. Dynamic SQL generation for the delete command is not supported against a selectcommand that doesn't return any key column information".
I try to use like
ds.Table["Order_Details"].AcceptChanges();
or write the chances back to the database. But it still doesn't work.
I think it may have some concurrency problem, does anybody know how to solve the problem please???
Asura
|
|
|
|
|
Hello, everyone! I am writing a interface to manager a invoice system database in Access.
I have a customer table and address table. Every customer may have several addresses. The delete, update rules are cascade.
If I delete a customer, the related addresses will be deleted at the same time. An error happens when update the address table which says "Concurrency Violation: the delete conmmand affected 0 records". I know this could be caused by the constraint relation. But I don't know how to avoid this happen. Any idea please???
Thanks in advance!
Asura
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
