If I have multiple table updates in a stored procedure and one fails, does this mean that the earlier updates are automatically rolled back, since the stored procedure is a block of code that is run as a whole?
Cheers,
lfc77
How can I view all triggers for a particular database? I'm currently trying to find if there are any triggers on a large number of tables by right clicking on the table > all tasks > manage triggers and it's taking forever. Can anybody help me out?
Cheers,
lfc77
How do you use sockets in C#? I need to convert some old VBScript code to C#, and I need to establish a socket connection to another machine and then send to it.
Any assistance would be really appreciated.
Cheers,
lfc77
I have 9 different parameters which are coming in from an XML document, and they may or may not be entered by the user. When I am parsing the XML I am setting a string to the value of the relevant parameter, so if the value is entered by the user, the string will equal that value, otherwise the...
I need to write a stored procedure that inserts a record into 2 separate tables. However, the insert into the second table needs to take the auto incrementing primary key from the record inserted into the first table for one of its fields.
Can anybody tell me how to do this?
Any assistance...
I'm currently reading data from an XML file using XPathNavigator and XPathNodeIterator to select the subset of data that I want. I've never using the XPath objects before so I'm not sure how to get this data into a dataset.
XPathDocument doc = new...
I'm currently reading data from an XML file using XPathNavigator and XPathNodeIterator to select the subset of data that I want. I've never using the XPath objects before so I'm not sure how to get this data into a dataset.
XPathDocument doc = new...
I'm currently reading data from an XML file using XPathNavigator and XPathNodeIterator to select the subset of data that I want. I've never using the XPath objects before so I'm not sure how to get this data into a dataset.
XPathDocument doc = new...
How do I use DateTime to get for example, yesterdays date, or the date 5 days ago? I am using DateTime.Now.ToString() to get today's date, and I need to also find the date at certain intervals back from that.
Any assistance would be really appreciated.
Cheers,
lfc77
Is it possible to return a dataset from a stored procedure, or would you need to write the SQL in your C# file to return the dataset?
Any assistance would be really appreciated.
Cheers,
lfc77
I'm a ASP.NET/C# programmer new to XSLT/XPath with a bit of experience of XML. I've been reading through some stuff on XSLT and I'm struggling to think of what situations I would want to use it in. Basically XSLT is like CSS for XML files, right (i.e. setting how the XML is displayed on...
What happens when you put a try catch within another catch? I need to do this because on catching the an error, I need to write data to a table, which will also require a try catch to catch a db error.
Any help would be really appreciated.
Cheers,
lfc77
I have a field in one of my tables that I am writing a string of XML to. Is it possible to convert this XML using a SELECT statement or some other means?
Any help would be really appreciated.
Cheers,
lfc77
I need to be able to use an XmlTextReader to read a string object which is made up of XML. Does anybody know how to do this?
Any help would be really appreciated.
Cheers,
lfc77
I few times when looking at code on the net I have seen objects, variables etc prefixed by an underscore. But I've never seen any explanation for the reason for this. What is the reason for doing this?
Thanks,
lfc77
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.