Answer Questions
b0bd0gz Logging Data Truncation While Using SQLBulkCopy
Hi, I am using SQLBulkCopy class of .Net 2.0 to copy data from excel to SQL 2000 database. My problem is that I want to log records whose data was been truncated as the field length in the database was not sufficient enough to hold data present in the excel file. For example suppose there is a column called 'Employee Name' in the database as varchar (30) now if I try to insert data using SQLBulkCopy class from excel file having data of more than 30 characters for some rows then somewhere I want a log which helps me to identify that row number 10 & column number 20's data was truncated due to field length. Thanks & Regards, Pritesh Shah Paul, What do you mean with ...Show All
matthew lyden Writing XML Source from Database to XML File
Hi There, I'm trying to write XML Source (for ex: "blabla <b>bla</b> blabla") I stored in a database to my XML File: DSExport = (Get Dataset) Dim Writer As New XmlTextWriter(strFolder & "\Article.xml", System.Text.ASCIIEncoding.Default) DSExport.Tables(0).WriteXml(Writer) But the result shows this: "blabla <b>bla</b> blabla". I think this is an encoding-problem. Any ideas Kind regards! Marco Thank you for your solution! Cause I had no time, I did a workaround and build a little class with that I create my own XML Doc from a dataset. So I made my own Dataset.WriteXML function. I don't thi ...Show All
Judy-H List<int> property for a custom control. doesn't work in design time
I've created this windows user control: public class ToolStripMenuItemRol : ToolStripMenuItem So it still supporting all the native properties of the ToolStripMenuItem. The enhacement applied in this user control was a new property: private List < int > _roles = new List < int > (); [ Description ( "Listado de roles validos para usar este menu" )] [ Category ( "Security" )] public List < int > Roles { get { return _roles; } set {_roles = value ; } } Then the property Roles appears in the Properties Page in Design mode. And when I'm trying to edit this property in design time, a collection editor appears and work fine. Everyth ...Show All
Goodwill force english exception messages
On my development machine I want to force the exception messages of thown excpetions to always be in english language. I have installed the english Visual Studio 2005 but the exception messages appear in german. How come Does that mean I have installed a german language pack for the .Net Framework If so, can I configure the Runtime to always show english excpetion messages without having to uninstall that german language pack If not how can I uninstall the german language pack Salvador wrote: Hi, Check your options >> Environment > International Settings, there you can select the lenguage of Visual Studio 2005. Regards This setting will not affect the language in wich Exception's messages (Ex ...Show All
jonesbrasil output param sql2000 / vb.net 2003
For some reason i can not get a value from Stored proc I use as simple output param (@KEY) Then storing a vlue to it in SP, the command shoud have a value now in rhe parameter @KEY When i ran he SP i got back "" .... which is wrong Remco Code SP ALTER PROCEDURE dbo.InsertBeoordelingEnBedrijf ( @ddCreatie smalldatetime , @CriteriaId int , @Status int , @GeinitieerdDoor varchar (50), @Idbedrijf as varchar (50), @KEY as int output ) AS SET NOCOUNT OFF ; INSERT INTO Beoordelingen ( ddCreatie , CriteriaId, Status, GeinitieerdDoor ...Show All
Michael Hansen c# SQL POCKET PC
Hi, I want to develop an application in c# (cSharp) that create a database and popolate it with some information. In my mobile device I have SQL Mobile Edition... I want a brief tutorial or example to start. thank you very much You may want to start with the below links: http://msdn2.microsoft.com/en-us/sql/aa336364.aspx http://msdn2.microsoft.com/en-us/sql/bb219480.aspx Thanx ...Show All
Aleniko29139 regular expression pattern
4/21/2003 : On 4/21/2003 6:02:49 PM By DBROWN :: ; On 4/21/2003 7:04:41 PM By DBROWN :: called on 4/19 ; from the above string can any one tell me the pattern to extract the date preceded by 'On ' and name preceded by 'By' Assuming that :: is not part of the name... #On (.* ) By (.* ) ::# Hi Pradeep, Did the post resolve the problem If so mark the post as the answer, so when others search the forums, they might be more inclined to look at a successful post than a non successful one... in the search results the Answered posts are bubbled to the top before the unanswered . Or post why it failed for you. Thanks. ...Show All
kiwicoder2 C# - reading and writing memory for game trainer
I'm interested in creating a small trainer for a single player game I made and want to know how to read/write memory with C# given a specific memory address. I found the memory addresses which hold the score (int '004F19EC') and player x position (float '01150630') and want to use them to produce variables in C# to track them and manipulate them. I couldn't find much info on how to do this. It seems I use the Marshal class but I'm having trouble figuring it out. If someone could show a sample of how this is done, I'd appreciate it. Is it managed memory or unmanaged memory If it is managed (i.e. managed by the CLR) memory you shouldnt reference it directly as the address will change when the ...Show All
A.F.B WebUSerControl
Hi, I need some help to create a web user control, following is the Scenario: WebUserUontrol.ascx file: 1 text box, 1 button control I want to create a control which will accept color value from textbox and onclick event of the button control it will change the back color of the page on which that control is being consumed. Value of the color property should come from textbox example: red, green etc. Suppose control is WebUserUontrol.ascx and web form is webPage.aspx, when the control will be used on the web page it should function as describe above. For this purpose I also want to use properties in the webusercontrol. Looking forward for the valuable responce. Regards, Kapil ...Show All
CalinMac Web service operations
Hai How can we identify the series of operaions performed by a webservice from an application ( I added a web referance to an application . From the application i want to know when the operations such as requesting, connecting , receiving , closing are performed...Is there any specific mechanism for that..) Thanks in advance With Love Ratheesh Do you want to know what's going on behinde the scenes for educational purposes Or do you want to monitor a web service's activity in real-time Actually i want to show what operation is currently taking place ie , connecting , requesting,receiving..etc in a form ..so that 1 can identify at which stage the connection is lost or an error is occured.. with love Rath ...Show All
CSharpNewbie22 Help need on Proxy the SMTP request
My SMTP server is in a different machine. The machine where I deployed my code doesn't have port 25 open. I got one advice from one site that to proxy the SMTP request. As I am new to protocol programming please help me how to proxy the smtp request. Please help me. Below is my code 'set connection based on load oConnection = New System.Net.Sockets.TcpClient 'connecting on SMTP port and obtaining stream oConnection.Connect("smtp3.google.com", 25) --error is here netStream = oConnection.GetStream() ...Show All
Prabagarane View relationships
Hi, first than all, sorry for my english becose is my first post in english an I'am from Chile. I'm working in a Data Access Layer Generator in C# with SQL Server 2005 Express and it work, but now i want add a new feature, the application have to analize my data base Realtionships and generate the restrictions and method of access to the foreings keys in this way: public static List<Rol> User.GetRoles(); For this, i have to know the rerationships of User and what cells of the table UserRoles is foreingKey of User. Now i'm using the methods myConection.GetSchema(SqlClientMetaDataCollectionNames.Tables) for get the tables for example, but I dont find a parameter than bring to me the relationships and foreingkeys for one cell. I' hope y ...Show All
michhes can I install .NET Framework 1.1 alongside 2.0?
Hi, I have .NET framework 2.0 on my machine. and I just bought a sony ericsson w810i which comes with software to transfer music form the computer to the cellphone. but when I install this software called 'Disc2Phone' it says it needs .NET framework 1.1 and prompts me to install it. I contacted SonyEricsson and they say they don't have a version that uses framework 2.0. they suggested installing 1.1 alongside 2.0 is that ok I am bit wary of sonyericsson's 'suggestions' considering they don't have a newer version of their software even though its more than a year since 2.0 was released! so, I thought i'd ask the MS guys...can I have both 2.0 and 1.1 on the same machine and not have my whole computer come crashing down :) ...Show All
Kayda_SQL Path.GetFileName UNC bug
There appears to be a bug in Path.GetFileName relating to UNC paths: Console .WriteLine( Path .GetFileName( @ \\Server\Share )); outputs: Share But "Share" is not a file or directory by itself. Share IS a directory...its a directory made to be shared out publically so people can just type: \\server\Share to access it. It will output Share, as you have stated. In the docs however, it states that "If the last character of path is a directory or volume separator character, this method returns Empty" But it doesn't, as you have spotted. The same thing happens even if you are doing it locally: C:\documents and settings would return "documents and settings&qu ...Show All
Shawn Wildermuth - MVP &#40;C&#35;&#41; Compatibility
Hi, I want to know whether vs.net 2005 application will run in .net framework 1.1 (are they compatible ) Regards, Durga. Hi, The program execution has nothing to do with VS.NET installed or not, But only thing is, if you have created a project under VS.NET 2005 which is using .NET 2.0, and compiled it then that problem can't run on .NET 1.1 runtime. When you installing a framework then it provides platform to run application but its version dependent, though backward compatibility is there. So my work around was, convert your VS.NET 2005 project manually into VS.NET 2003 (you cant open it directly solution file create in 2005 into 2003 so you will need to use the workarond i have suggested) and then COMPILE it ...Show All