|
You shouldn't use string concatentation and "@" together. The literal character, "@", is so that you don't have to escape special characters (like backslashes) or so that your text can span multiple lines. Both your original code and my example of using "@" (but honestly, such a short SQL command is easier to read as a single line) would compile. Your only problem is that in the first code you posted you had a comma after MID which may cause a SqlException to be thrown; it's an extraneous comma.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I am writing a c# windows application and want it to fill out a simple HTML form, submit the form, and return the content of the returned webpage. Is this possible?
I know how to use WebRequest and WebResponse to retrieve the content of a specific webpage, but I can not figure out how to retrieve the content of a webpage accessed by submitting a form.
Here's what the form looks like for some more info:
<html>
<form method=post action="../cgi-bin/homestead/mail.pl?mama172">
Name:
<input type="text" size="35" name="name">
Address?
input type="text" size="40" name="address">
City?
<input type="text" size="25" name="city">
<input type ="submit" value="Send">
</form>
</html>
|
|
|
|
|
Take a look at the HttpWebRequest.GetRequestStream[^] for HttpWebRequest.GetRequestStream which shows a good example of sending a POST request to a CGI sitting off on some web server.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
|
|
I have some code to open up a word document and add paragraph to the end of the document and then save and close the document. Now creating a word application object is fine, the opening a word document is fine. The problem occurs when I use this code
1. Word.Paragraph wordPara;
2. wordPara = wordDoc.Content.Paragraphs.Add(ref wordRng);
3. wordPara.Range.Text = "Original electronically authenticated by " + physName + " on " + strDateTime;
4. wordPara.Range.Font.Bold = 1;
5. wordPara.Range.InsertParagraphAfter();
For some reason after line 3 runs I recieve this error: "The server threw an excpetion". That is only error I recieve. In my project I am referencing the Microsoft Word 10.0 Object Library can anyone help?
Nicholas Ingratta
ningratt@hotmail.com
|
|
|
|
|
What else does the stack trace say for the exception? You should also try duplicating this code in a VBA project (the ol' school VB) which - if the .NET exception doesn't tell you enough, and I'm surprised that it doesn't - will give you more details about the problem itself through the Err object in VB (its implementation of IErrorInfo defined for OLE/COM).
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
the only thing in the stack trace that is of any importance is:
"at Word.Range.set_Text(String prop)"
not really sure what that means
I only have Visual studio .net so I cannot create and old VBA project that I know of
|
|
|
|
|
Obviously you have Office (otherwise you couldn't even instantiate the WordApplication class), so you have VBA. VBA = "Visual Basic for Applications" and is a VB binding to the application's automation layer. Just click Tools->Macro->Visual Basic Editor.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
|
And it won't. VB != VB.NET. It's merely the same syntax. VB (6 and older) is an automation client that uses objects defined in type libraries and implemented by COM servers. VB.NET uses the .NET BCL (base class library) and compiles to Intermediate Language (IL).
So, you copied VB.NET code into a VB IDE (Integrated Development Environment). You need to write VB which is documented if, in the IDE, you click on the Help menu (and like Contents or Index or whatever).
The basic objects will be the same, but the types not defined in the typelib (like Missing.Value) will not work - they're defined in the .NET BCL and, unless exposed to COM through a CCW, cannot be called by VB6 (which is what the VB IDE in Office and other applications uses).
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi!
I've a Web Service and 3 different SoapExtension. In my client app., I configure the web.config to execute the 3 diferent SoapExtension.
I'm trying to throw a SoapException in the first SoapExtension and i wan´t to stop the message flow. I don´t want that the flow of the Soap Message continue.
Is that possible?
|
|
|
|
|
Hi!
I am writing a server/client application in which I need to transfer short text strings across a network from the server to the client. The message receiver in the client is running in its own thread, and it uses a stream reader to get the message strings from the TcpClient.
It appears that both the 'Read' and 'ReadLine' methods of the StreamReader class blocks until there is something on the stream (if it is empty when they are invoked). The problem is that not even a call to .Abort() will interrupt the Read(Line) metod (which is exactly what I want to do). Is there any way to abort a call to Read(Line)?
I have tried to use the Peek() method to determie whether or not the stream is empty. However, Peek() returns -1 even though ReadLine() returns with a string that is supposed to be there. Any thoughts on why this happens?
Does anyone no of a construct that provides a non-blocking read from a stream?
|
|
|
|
|
"Any thoughts on why this happens?":
MSDN states for the return value of the Peek method: "The next character to be read, or -1 if no more characters are available or the stream does not support seeking." So maybe your stream doesn't support seeking.?
"Does anyone no of a construct that provides a non-blocking read from a stream?":
Try getting the underlying stream through BaseStream property and using its asynchronous BeginRead and EndRead methods.
www.troschuetz.de
|
|
|
|
|
You'll need to use asynchronous interfaces. Use the BeginRead/EndRead, BeginWrite/EndWrite methods. Not THAT easy to do, but once you learn the asynchronous patterns in .NET, everything will be easier.
My advice: don't use TcpClient/TcpServer for anything but the simplest things, as they're too simple, and have several drawbacks, as you're starting to notice. Use the Socket class, instead, that is a bit more complex to use, but will not give you so many headaches.
Yes, even I am blogging now!
|
|
|
|
|
|
Thank you all for your advice! I will switch to using sockets instead. It will take some effort, but I'm sure it's worth it! Does anyone know of a good tutorial on working with sockets?
However, I'm the sort of person who cannot let things go so easily. That Peek() does not work as I think it would  still borthers me somewhat, and I would like an explanation if there is one? I will let this go eventually, but until then I will remain confused. Anyone?
Thanks!!
|
|
|
|
|
Search for Sockets here on CodeProject and/or read the example given by the MSDN topics for the Socket class.
www.troschuetz.de
|
|
|
|
|
how can i clear the date time picker control from any date in it?
|
|
|
|
|
It is not possible with System.Windows.Forms.DateTimePicker, because DateTime is a ValueType and cannot be empty.
You can set dateTimePicker.CustomFormat to String.Empty, but then the user won't be able to enter a new date.
Search for "Nullable DateTime Picker" in the articles, there is a useful solution with a TextBox and a DateTimePicker.
_________________________________
nur Idioten brauchen einen Führer
|
|
|
|
|
Hi,
I have a query with regards to data sets.
I have the following declarations in C#.NET, it's just brief, so I hope it makes sense:
SqlDataAdapter adptContacts;
dsContacts.ContactsRow rowNew;
rowNew = dsContacts.Contacts.NewContactsRow();
rowNew.ContactID = GetNewContactID();
rowNew.FirstName = txtFirstName.Text;
rowNew.LastName = txtLastName.Text;
I have code that adds data to the new row, then I add the code to the data set using the following code:
dsContacts.Contacts.AddContactsRow(rowNew);
I modify the database like this:
adptContacts.Update(dsContacts);
I just want to know when adding data to the database like I did. As far as I understand it, a dataset contains data retrieved from the database. So when I do my update, does it delete the data in the table and all the data in the data set, or does it just add the new row to the table?
Brendan
|
|
|
|
|
DataRows have a DataRowState property which defines if a datarow is modified, added or deleted. Check ur rowNew.RowState and you will se its System.Data.DataRowState.Added.
When u update the source datatable in ur underlying database, the dataadapter
method adptContacts.Update(dsContacts) will use the adapter's DeleteCommand for the Contact's table to delete any Deleted datarows, the InsertCommand for any Added datarows and the UpdateCommand for any modified rows ur datatable might have.
In ur case, ur DataTable only has one Added row, so the dataadapter will add ur row to the underlying database datatable. It wont delete anything anywhere.
In ur code, I seem to be missing where un initialize the adptContacts DataAdaper. U have to create and assign the SqlCommands to it. An easy way is to create the DataAdapter in the designer, it will create all commands by itself, unless ur querying more than one DataTable through a JOIN.
|
|
|
|
|
Look at the IDataAdapter.Update [^]IDataAdapter.Update documentation in MSDN. It is clearly explained.
--------
"I say no to drugs, but they don't listen."
- Marilyn Manson
|
|
|
|
|
Hi,
I am using collection to bind data to datagrid.
Dim oCars as CarCollections = New CarCollections
DataGrid1.DataSource = oCars
Everyithing work fine but there is a sorting problem.
If I do so, there is no sorting features in DataGrid. When I bind DataSet to Datagrid I can Sort data in DataGrid by clicking on columns header. DataGRid automaticly sort filled data according clicked colum.
When I bind datagrid to Collection that features is missing.
What should i do, in Collection class - CarsCollection, to have sorting features back
Thanks in advance
P.S. Sorry for bad English
... Never argue with an idiot, they will drag you down to their level and beat you with experience
|
|
|
|
|
Tancev Sasa wrote:
Everyithing work fine but there is a sorting problem.
IIRC, your class needs to implement IComparable for sorting work.
Yes, even I am blogging now!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
