-
- Updating nulls in sqlserve datetime column
by yog_23
- 4 Replies
- Last post
by VMazur
- How do we update nulls for a datetime column
The following is the code I am using, its throwing an exception = "String was not recognized as a valid datetime".
string sEffDate1 = effectiveDt;
string sEffDate2 = "";
int iResult;
iResult = sEffDate1.CompareTo(sEffDate2);
if (iResult <= 0)
{
param = new SqlParameter("@effectiveDt"
-
- Programmatically check the syntax of pieces of code
by Anton L.
- 4 Replies
- Last post
by Zac Bowling
- Hi all, Is it possible to check the syntax of code programmatically Let's say I have the following code.
Code Snippet
public void Test(int i, int j, params string[] k) Is it possible to determine whether this is a correctly typed method I want to do the same thing for variables, for example:
Code Snippet
private List<int> list = new List<int>() I tried to mak
-
- GetSchemaTable for a DataSet?
by KevinBurton
- 3 Replies
- Last post
by Andreas Johansson
- The SqlDataReader function GetSchemaTable works just fine for result sets that contain a single table. I was wondering how to get the schema for multiple tables in a DataSet I would like to get the schema for each table in the DataSet returned by a stored procedure call. GetSchemaTable seems to only show the schema for the first table in the result set.
Thank you.
Kevin
-
- Change the System
by Eragon.
- 1 Replies
- Last post
by nobugz
- Hi,
I'm creating an application that needs to have a few settings displayed, and if needed, the user is allowed to change them. I need to display things such as:
The user name
The time
Total physical memory
Available physical memory
Total virtual memory
Available virtual memory
Operating System (Service Pack versoion or edition included)
Any existant network connectio
-
- VARIANT_BOOL: Bug in RCW?
by mwarpheus
- 3 Replies
- Last post
by mwarpheus
- This happened with .NET 3.5 under Orcas:
An automation method, aMethod(), returns VARIANT_BOOL. The RCW seems to always translate a VARIANT_BOOL return value to "true", even in the case of VARIANT_FALSE!
To illustrate it, here is the Automation method:
Code Block
VARIANT_BOOL myClass::aMethod( void )
{
AFX_MANAGE_STATE(AfxGetAppModuleState());
-
- Mixed results
by Patrik H&#38;&
- 6 Replies
- Last post
by Patrik Hägne
- We have a web site (ASP.Net 2.0) running on a windows 2003 server with 8 processors. We have encountered an error that totally baffels me (well, us). When selecting (through stored procedures or "dynamic sql ") sometimes the returned result - in the form of a datatable - contains results from a totally different query.
To me the only shared resource between these different queries
-
- Invalid character in the given encoding
by seco
- 5 Replies
- Last post
by Derek Smyth
- Hi i have books.xml file like this -------------------------------------------------------------- < xml version="1.0" > <!-- This file represents a fragment of a book store inventory database --> <bookstore> <book genre=¡±autobiography¡± publicationdate=¡±1981¡± ISBN=¡±1-861003-11-0¡±> <title>The Autobiography of Benjamin Franklin</title> <author> <
-
- How to check if a remote queue exists
by Avi_harush
- 0 Replies
- Last post
by Avi_harush
- Hi
I've seen this problems in many posts but with no solution.
I am working with MessageQueue.Exists() but when the queue is on a remote computer, it throws an exception. How can I check if a remote queue exists
Thanks
Avi harush
-
- InterOP issue while calling COM Component from .Net
by Jealani
- 14 Replies
- Last post
by Jealani
- Hi All,
this is probably a very small issue but i have been trying so many things and i am new to .Net. so I need help.
I have an interface defined in IDL
interface IMatrix : IDispatch { [id(1), helpstring("Sets the column-major matrix elements by array of 16 doubles.")] HRESULT Set([in] double* pMatrix); [propget, id(3), helpstring("Gets/Sets the matrix element by
-
- Unique name for the validation report
by pdurbha
- 2 Replies
- Last post
by Peter Ritchie
- Hi, I have developed a tool for generating a validation report. The tool reads off huge volume of data and checks for invalid data(records). Any invalid record found is spitted out into a report. Right now, the tool is designed in such a way that each time the tool is run, the same report (say validation_report.txt) gets overwritten with a different set of invalid records. My question is: How can
-
- SharePoint getlistitems web service
by Shaun_SPS
- 1 Replies
- Last post
by John Saunders
- I'm pulling data from a sharepoint list into an infopath form using the getlistitems web service. If I only use 2 parameters, the data pulls. When I add a 3rd, the query fails. Can only 2 parameters be passed to a web service Here is my code that works
Code Snippet
query.InnerXml = "<OrderBy><FieldRef Name=""ActualMaterial"" Ascending=&qu
-
- Why this does not compile?
by nikov
- 7 Replies
- Last post
by nobugz
- Code Snippet
class Stuff
{
int Foo( object x, object y)
{
return x as int & y as int ; // error CS1003: Syntax error
}
}
-
- Convert XML to Flat File using XSLT
by Sidheshwar
- 9 Replies
- Last post
by Dimitre_Novatchev - MSFT
- Hi Everyone,
I need to convert an XML file to flat file thru XSLT in C#.NET.
Please suggest.
Thanks in Advance
Rgds
Sidheshwar
-
- Customer created strong named satellite assemblies
by pressie
- 2 Replies
- Last post
by pressie
- We have built our application and its corresponding DLL¡¯s with the possibility of using satellite assemblies. The exe and DLL¡¯s are all strong named therefore any new satellite assemblies also need to be strong named.
Our main problem is once we have released the software, we want to be able to add language support as needed. The process usually goes:
We release out strong
-
- Unzip File using .net 2.0 class libraries [no third party component like sharplib]
by Kamii47
- 6 Replies
- Last post
by Brody
- I have a zip file.I want's to unzip it how can i do this in .net 2.0 as we know there is a class i think gzip from which i can unzip a file. Please can anybody help.
What i have is a abc.zip file which contains only single file abc.xml.I want's to extract the abc.zip file and save abc.xml file.
I am using .net 2.0.I don't want to use any third party component like #ZipLib .I want's to unzip
-
- Structures in Webservice
by JDCAMP
- 6 Replies
- Last post
by JDCAMP
- In the webservice i have...
Public Structure CustomerStructure
Dim CusotmerNumber As Integer
Dim Company As String
End Structure
<WebMethod()> _
Public Function TestList ( ByVal CustomerList As System.Collections.Generic.List( Of CustomerStructure )) As String
Return "Success"
End Function
then in
-
- how to make faster conversion of csv files to xml...
by Tapan
- 1 Replies
- Last post
by Derek Smyth
- How to split large .csv files into smaller one, so that it can be processed faster by XML Processor to convert into xml files.
Please suggest me with the code in C#.NET
-
- best way to go back to the beginning of a file when using .ReadLine();
by Nasai
- 8 Replies
- Last post
by Nasai
- Hey all, I've been using a standard loop to use .ReadLine(); to go through a .txt file and store strings from certain lines to variables. I've basically created my own simple scripting algorithm that reads sections of a file's text and take the information from each section once at a time. I'ts been going well, but i need to change my code to first count how many of these sections there are by goi
-
- Data Access from SQL Server 2000
by anish11
- 2 Replies
- Last post
by anish11
- Hi. I¡¯m using VB .net windows form and MS SQL Server 2000 personal edition. I have created a table ¡°candidate¡± in SQL Server with 14 fields and of which ID and SDATE are two fields. Their data types are as follows.
ID- varchar(10), not null ¨C contains values 0 to 9 but in string format SDATE ¨C datetime, not null ¨C contains server system date in mm/dd/yyyy hr:min ec format
The sample table fi
-
- EXE has generated an error...
by Amiya K Acharya
- 1 Replies
- Last post
by OmegaMan
- Hi,
My application is on .NET Framework2.0 with C#.
Using MSMQ for Database Updation and Memory Queue for displaying and saving Logs.
After running 2/3 hours the application is giving the below error.
" EXE has encountered a problem and needs to be close. We are sorry for the inconvenience ".
"Tell this error to microsoft"
Can anybody help abt this.
-
- Updating data in one database from another using data tables and relationships
by DanaAtUM
- 0 Replies
- Last post
by DanaAtUM
- Hello, I have setting what I thought was going to be somewhat straightforward problem using VB2005 and ADO.NET ... I have a query to a database (happens to be in Oracle) that I was able to tie to a table adapter and data table. IOW, I connected and populated a test grid with data graphically using the xsd designer. Hooray for me. I have to say that was kinda cool (I'm a rookie with the datasets an
-
- socket.BeginSend cause some SocketError.NoBufferSpaceAvailable !!!!!
by cdemez
- 7 Replies
- Last post
by Indian Ocean
- Hi, I have some code like this : while(isTransferringStream) { ... SocketError error = SocketError.Success; socket.BeginSend(buffer, .... error, ...); if (error == SocketError.NoBufferSpaceAvailable) throw new FatalException(); ... } And, during long transfer, I got some "SocketError.NoBufferSpaceAvailable" errors... !!! How can I handle this I have try to synchronize this
-
- How do I transfer data from a Gridview on a webpage to another webpage?
by bwygal
- 1 Replies
- Last post
by Nathan Anderson - MSFT
- Okay, So I have a gridview on a asp web page. I want to be able to select a hyperlinked column and have it transfer me to another page in my project. My problem is that I want the text of that particular hyperlink to be used in a paramaterized query on the new page that opens up. Meaning I need to take the text information of the particular hyperlink with me to the new page. can anyone help
Tha
-
- Not updating database
by xion.truth
- 5 Replies
- Last post
by BonnieB
- I have an application that contains a listbox and a text box. the list box obtains information from database table accounts.acctnm with a primary key 1-32. when i hit seems to update the dataset but if i exit and get back in everything is back to default
Private Sub Manage_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load
'TODO: This line o
-
- Retrive IIS Information from Remote Server and Display Data using ASP.NET or Desktop Application in Dotnet-1.1
by J_Kumar
- 1 Replies
- Last post
by DaleJ
- Hi,
I want to retrieve the details of the sites running in the server
and display their status, for that i used wmi and adsi concept,
I used the code mentioned below to retrieve the details,
I'm getting invalid namespace error in the line
" Dim searcher As New ManagementObjectSearcher("root\MicrosoftIISv2", "SELECT * FROM IIsWebService")"