Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records

.NET Framework Data Access and Storage

- Previous
  - 1
    - is this ridiculous use of regex? reader = New StreamReader(strCapFile & ".tmp") s = reader.ReadToEnd reader.Close() Dim ptn As String = _ "( :^PART-NO\.\s+)( <partno>[A-Z/-]+)( :\r\n)" & _ "(( :^DESC)( =[ ]+)( :\s+)( <desc>.+)) ( :\r\n)) " & _ "(( :^O\.H\.)(( =[ ]+)( :\s+)( <onhand>- [A-Z0-9]+)) ( :\r\n)) " & _ "(( :^COST)(( =[ ]+)( :\s+)( <cost>[0-9\.]+)) ( :\r\n)) " & _ "(( :^LIST)(( =[ ]+)( :\s+)( <list>[0-9\.]+)) ( :\r\n)) " & _ "(( :^LOST)(( =[ ]+)( :\s+)( <lost>\d+)) ( :\r\n)) " & _ "(( :^LTDATE)(( =[ ]+)( :\s+)( <ltdate>\d{2}\w{3}\d{2})) ( :\r\n)) " & _ "(( :^RDATE)(( =[ ]+)( :\s+)( <rdate>[A-Z0-9 ]+)) ( :\r\n)) " & _ "(( :^ENTRY)(( =[ ]+)( :\s+)( <entry>\d{2}\s\w{3}\s\d{2})) ( :\r\n)) " & _ "(( :^SO)(( =[ ]+)( :\s+)( <source>\d+)) ( :\r\n)) " & _ "(( :^A\.B\.C\.D\.)(( =[ ]+)( :\s+)( <abcd>[A-Z0-9\\/* -]+)) ( :\r\n)) " & _ "(( :^BIN1)(( =[ ]+)( :\s+)( <bin1>[A-Z0-9.'%\\/* -]+)) ( :\r\n)) " & _ "(( :^BIN2)(( =[ ]+)( :\s+)( <bin2>[A-Z0-9.'%\\/* -]+)) ( :\r\n)) " & _ "(( :^BIN3)(( =[ ]+)( :\s+)( <bin3>[A-Z0-9.'%\\/* -]+)) ( :\r\n)) " & _ "(( :^SS)(( =[ ]+)( :\s+)( <ss>\w+)) ( :\r\n)) " & _ "(( :^MULT)(( =[ ]+)( :\s+)( <mult>\d+)) ( :\r\n)) " & _ "(( :^O\.O\.)(( =[ ]+)( :\s+)( <onorder>\d+)) ( :\r\n)) " & _ "(( :^T)(( =[ ]+)( :\s+)( <otype>[A-Z])) ( :\r\n)) " & _ "(( :^RB)(( =[ ]+)( :\s+)( <rb>DEL|RB|WAS)) ( :\r\n)) " & _ "(( :^PNC)(( =[ ]+)( :\s+)( <pnc>[A-Z0-9]+)) ( :\r\n)) " & _ "(( :^BRP)(( =[ ]+)( :\s+)( <min>[0-9 ]+)) ( :\r\n)) " & _ "(( :^BSL)(( =[ ]+)( :\s+)( <max>[0-9 ]+)) ( :\r\n)) " & _ "(( :^JAN)(( =[ ]+)( :\s+)( <jan>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^FEB)(( =[ ]+)( :\s+)( <feb>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^MAR)(( =[ ]+)( :\s+)( <mar>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^APR)(( =[ ]+)( :\s+)( <apr>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^MAY)(( =[ ]+)( :\s+)( <may>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^JUN)(( =[ ]+)( :\s+)( <jun>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^JUL)(( =[ ]+)( :\s+)( <jul>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^AUG)(( =[ ]+)( :\s+)( <aug>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^SEP)(( =[ ]+)( :\s+)( <sep>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^OCT)(( =[ ]+)( :\s+)( <oct>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^NOV)(( =[ ]+)( :\s+)( <nov>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^DEC)(( =[ ]+)( :\s+)( <dec>- [0-9]+)) ( :[0-9 -]+) ( :\r\n)) " & _ "(( :^MNS)(( =[ ]+)( :\s+)( <mns>[0-9]+)) ( :\r\n)) " Dim mc As MatchCollection = New MatchCollection(s, ptn, ignore_whtspc or multiline) Is this just a poor attempt at trying to alleviate boredom at work it works like i want it to, but am i just wasting my time Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 2
    - .net 2.0 - winform - win xp pro style Hi, I am using .net 2.0 windows forms under windows xp pro. Created a file called: MA.exe.manifest The solution is MA.sln This manifest file is in the same path as MA.sln on the C drive where I do the development. For a particular button property in the form I have set the flatstyle property to system rather than standard. How can I enable the Windows XP styles I.e. a button control to appear as the windows xp style rather than the present standard. This is the content of the manifest file: < xml version="1.0" encoding="UTF-8" standalone="yes" > <assembly xmlns="urn chemas-microsoft-com:asm.v1" manifestVersion="1.0"> <assemblyIdentity version="1.0.0.0" processorArchitecture="X86" name="WindowsXP" type="win32" /> <description>Your application description here.</description> <dependency> <dependentAssembly> <assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" processorArchitecture="X86" publicKeyToken="6595b64144ccf1df" language="*" /> </dependentAssembly> </dependency> </assembly> Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 3
    - ASP.NET 2.0 Membership Hi All, I have 2 issues. I am using the standard ASPNETDB.MDF with Visual Studio Web Express edition and have installed both SQL Server 2005 (developer edition) and (express edition) 1) The web app is using neither of these servers to update the member information and instead has decided to use the ASPNETDB.MDF file in the /App_Data directory How do i change the web.config file to point the developer edition server 2) In the website when a user forgets their password i need an Admin user to reset this passsword (using ResetPassword() ) but the catch-22 situation is that in order to do this the answer to the users question must also be provided which is not know by the Admin user. How can i get around not providing this parameter although i do see another method that does not take the any parameters it cannot be used for some reason Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 4
    - Importing .EPS files I need to read .eps files and rasterize them on the fly on a web server...is there any way to read an .eps file in .Net Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 5
    - Export/Import api in .net Hi All, I want to transfer data from MS Access to SQl server in .net.Is there any import/Export API to do this I want to develope a application wher i choose the mdb files as source and sqlserver as destination. There can be more then one mdb files.It should pick each file one by one and then import that data to sqlserver. Any help is appriciated Thanks, Rakesh kashnia Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 6
    - Help with Socket TimeOut? Possible? Help Please? Ok, So I have a socket, and i have it connecting to see if it can connect or not. and im doing asynctously. like this. sock.beginconnect(ip,port,new AsyncCallBack AddressOf(ConnectCallBack),nothing) And Is there a way to set like a timeout on it Becuase, it waits like 15 seconds before throwing an error that it couldn't connect Is there a way to set a timeout to like 5 seconds, or anything like that Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 7
    - Empty strings in System.Collections.Specialized.StringCollection Maybe there should be a specialized string containing collection that blocks adding empty strings I know v.v.easy but in my opinion should be included as standard. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 8
    - Mulitple Registry keys Hi all, I know that only one default key is allowed for each file extension. But if i want to add the link of another program to that particular extension (for example ".txt"), is it possible to do so thanks Regards chun Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 9
    - Get names of controls in an aspx page Hi! I had a website project and it contain some page. I want to get the whole names of any control in a page by coding in a class. Is it possible Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 10
    - Iformatprovider Everytime I want to use format provider I need to use the overload of tostring (I dont know otherwise), is there anyway to specify it by Types' attribute so that default Tostring picks up the one specified by attribute rather than current threads' Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 11
    - vERY uRGENT - READING TEXT FILE Please help me to find out the tab position number of each word while reading the text file using string builder Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 12
    - The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. I just installed Visual Studio 2005 today and I'm already getting an error. This code worked fine on 2003. I am running Windows XP 64 so I definitely have the latest MDAC. Anyone know why I would get this error Dim strConnect As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & GetWorkingPath() & "db.mdb;Persist Security Info=False;" conn = New OleDbConnection(strConnect) conn.Open() Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 13
    - Running ASP web application on IIS Hi, I am tryimng to run an ASP application on IIS, but its giving me " Service Unavaliable " message. Can anybody help me trouble shoot this issue. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 14
    - Xerces and MSVS 2006 Hi, I work on an xml project using xerces integrated to the MS VC++ 6.0 environment (msdev). I need to integrate xerces with MS Visual Studion 2003 (devenv). The following are the setup options I create with the VC++ 6.0 a. Project Setting -> C/ C++ tab -> Category : Preprocessor ->Additional Include Directory : <path where xerces is stored till the src folder> b. Project Setting -> Link -> Category : Input -> Object/ Lib Modules : Xerces-c_2D.lib and Addtional lib path : <Directory where the lib file is stored> Xerces works fine with this. When I try the same with MS VS 2003, i get linker errors indicating that there is a clash between the MSXML and xerces' functions definitions. What Should I do to resolve this issue. Please help With regards, Sitaram. S Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 15
    - can webservice raise error at client side? Hi I am new to asp.net web services. I have developed websevice using vb and soap, where i am raising error at client side by writting Err.raise in my service. Is there anything similar to this in ASP.Net web services Thanks Sandy Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 16
    - Find node(s) whose InnerText matches... Hello! I have the following HTML (I'm using SgmlReader to parse it) structure: <table> <tr> <td></td> <td></td> <td>I don't want any of these.</td> <td></td> <td></td> </tr> <tr> <td>I am looking for this!</td> <td></td> </tr> <tr> <td>I don't want this.</td> <td></td> </tr> <tr> <td>This won't do, either.</td> </tr> </table> I need to get the highlighted node using XPath. Unfortunately, I can't hardcode the query, because this node may change it's position in various documents, it also doesn't have any distinctive attributes. I can only rely on it's InnerText, which never changes and is unique. I tried several XPath queries, but with no success. I am looking for something like this: data.SelectSingleNode("./descendant::td[text()='I am looking for this!']"); data is an XmlNode holding the <table/> element in the above structure. Unfortunately, my query results in null. Any ideas Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
- Next
  - 1
    - Question regarding Array.IndexOf I've been trying to use the Array.IndexOf method to get the location within the array of a certain string. However, each and everytime I try, the method returns a -1. After going through step by step with the debugger I'm certain the array contains the string value I'm looking for. I've also tried to use a List<string> to accomplish the same thing, to no avail. Here's what I'm after: I've got a CSV string I've read in from a database (ASCII based string) I've split this string via the comma. This part works excellent, the problem comes down to when I actually try to compare: At this point I have Code Block int arrayPosition = splitList.IndexOf(MyControl.Name); Still only getting a -1 with this, and myValue is in the string. If one string were in unicode and the other was ASCII would this cause a problem Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 2
    - Exception while using IHttpModule Hi, I am extend IHttpModule interface to handel al unhandeled exceptions in asp .net application. I ahve extended a class from IHttpModule interface . I am using following code. public class ErrorHandler : IHttpModule { public ErrorHandler() { // // TODO: Add constructor logic here // } #region IHttpModule Members public void Dispose() { } public void Init( HttpApplication context) { context.Server.ClearError(); // Event binding context.Error += new EventHandler (context_Error); } // Error event handler void context_Error( object sender, EventArgs e) { Exception NewException = ((System.Web. HttpApplication )sender).Server.GetLastError(); if (NewException != null ) { AppErrHandler appErr = new AppErrHandler (); ((System.Web. HttpApplication )sender).Server.Transfer ( "//ApplicationFramework//ErrorHandling//ErrorMessage.aspx" , true ); ((System.Web. HttpApplication )sender).Server.ClearError(); } //Log new NewException.Message; } #endregion } While an exception raised in application , the void context_Error(object sender, EventArgs e) raising three times . First time the expression Exception NewException = ((System.Web.HttpApplication)sender).Server.GetLastError(); returns an unhandeled exception object that is thrown from asp file . next two times the event raise with a message File Not Found. Here is the stack trace for same. at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context) at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) i ant help regarding this event should occure only once. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 3
    - Deleting multiple records using OleDbDataAdapter I have two tables that have one to many relationship. I defined OleDbDataAdapter for each table. However since the child table does not have a primary key whenever I run: childAdapter->Update(myDataSet, childTableName); I get a concurrency exception. The DeleteCommand of the childAdapter is defined like this: "DELETE FROM childTable WHERE ID = " It looks like that the adapter deletes all the instances of the desired records at once but it tries to delete the rest of the records and it can find them (because it has deleted them with the first call) and generates an exception. Any help in how to approach this Thanks in advance. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 4
    - .NET Socket implementation Hi, I'm new to asp.net web application and also socket programming. I need help on socket programming. I want to create a asp.net web application page that can connect to the server using socket and for the data access part I need to use xml for communication between the server and the client applcation. The server connect to three databases and it acts as a middle man between the client and the database. The server is a program written in java. How am I suppose to do the socket programming inside my web application. Can anyone help me with that I really need help... As I can't find any good example on socket programming. Please help... Snow Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 5
    - out of memory exception in .NET Remoting v2.0 - TCP Channel Binary formatter Has anyone seen this error I am getting it when the server is supposed to return a dataset with response data. The database may be large but not more than a couple of megabytes. can anyone advise what could be the issue System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. Server stack trace: at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder..ctor(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder..ctor(String value, Int32 capacity) at System.Data.DataSet.SerializeDataSet(SerializationInfo info, StreamingContext context, SerializationFormat remotingFormat) at System.Data.DataSet.GetObjectData(SerializationInfo info, StreamingContext context) at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.Serialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) at System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Write(WriteObjectInfo objectInfo, NameInfo memberNameInfo, NameInfo typeNameInfo) at System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck) at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck) at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.SerializeResponse(IServerResponseChannelSinkStack sinkStack, IMessage msg, ITransportHeaders& headers, Stream& stream) at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 6
    - remove characters I dont know if this can be done with regular expresions and faster.I want to filter a file removing the ASCI characters below. The character codes are : 0-9 , 11 , 14-25 , 27-31 , 127 , 129 -160 , 173 , 210 and 255. I have done this with two loops comparing each byte of file with these , but with big files it takes long time. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 7
    - Reading a node from an XML string. well, new to XML thingy.... anyways, how do u guys get to a particular node in an XML string. i want to store the value of a node into another string 'nodestr' from an XML string called 'response'. i can find alot help to read XML documents, but not enough on reading XML strings. plz, help me outta this one..... Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 8
    - Server.Transfer Demands Unmanaged Code Permission due to HttpResponseUnmanagedBufferElement I have some ASP.NET 2.0 code (Subtext) running using Webserver.WebDev that has been working fine for a very long time. I was testing some Medium Trust scenarios and found that Server.Transfer throws a Security Exception. Stepping through the code I noticed that the page I transfer to runs just fine. Once the page is done rendering, an exception occurs as the content is being flushed to the response. In the stack trace, there's a call to System.Web. HttpResponseUnmanagedBufferElement .System.Web.IHttpResponseElement.Send Anyone know why the unmanaged buffer is used instead of the HttpResponseBufferElement Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 9
    - Unable to cast object of type 'System.Runtime.Remoting.Identity' to type 'System.Runtime.Remoting.ServerIdentity' Hi, I am getting the following exception: Unable to cast object of type 'System.Runtime.Remoting.Identity' to type 'System.Runtime.Remoting.ServerIdentity') thrown when trying to access a remote object that has been created in a remote processes AppDomain. e.g. - Client remotes to a Well Known SAO (the 'broker' object). - Client requests the Uri of a 'service provider' object from the 'broker'. The 'broker' creates a new AppDomain and creates the 'service provider' object in this new AppDomain (using CreateInstanceAndUnwrap). The 'broker' then calls RemotingServices.Marshal for the 'service provider'. The 'broker calls RemotingServices.GetObjectUri for the new 'service provider' and returns it to the client. - Client remotes to the 'service provider' using Activator.GetObject(Type, uri) - Client makes a call on 'service provider' - exception thrown. If I remove the creation of the AppDomain and the CreateInstanceAndUnwrap, and just call 'new' for the 'service provider' and Marshal it using RemotingServices.Marshal it all works fine. Any Ideas on why the same object marshalled from a different AppDomain causes this exception Thanks Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 10
    - UNC Share Security Access Exception Hi, We are trying to run a network application from one of our servers on a client workstation but I keep getting a error. Here is the error: An unhandled exception of type 'System.Security.SecurityException' occurred in app.exe Additional information: Security error. I have tried adding our UNC shared application to the Machine level policy with full trust source but I am still geting an error.... If I run this application from a local directory it runs without issue... can anyone point me in the right direction Thanks. I tried adding the the app to the security policy via the following command line: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\caspol.exe -m -ag 1 -url " \\sever\apps\app\ *" FullTrust -exclusive on also with: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\caspol.exe -m -ag 1 -url " \\sever\apps\app\ app.exe" FullTrust -exclusive on Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 11
    - running an external command line program Hi, I am trying to run a 3ed party program from a c# application and read the result of the run. To do this I Create a new Process object, redirect the standard output and read from the standard output stream. The problem is, the stream is always empty although the programm always prints output. the code itself seems to be fine and if i try to run simple dos commands it works ok. Any ideas Thanks. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 12
    - WebClient.UploadFileAsync and FTP and active vs. passive mode I am using the WebClient class in order to FTP files asynchronously. This works great for sites that use PASV mode. The problem is when trying to send to an FTP server that only uses active mode. There doesn't appear to be a way to set it to use activemode when using the UploadFileAsync method of the WebClient. There is a property for the FtpWebRequest called UsePassive, but that property doesn't appear to be exposed through the WebClient class. Is there any way to do an UploadFileAsync and specify the STOR action to use active instead of passive mode I can post sample code if need be. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 13
    - idle timeout callNTpowerinformation Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 14
    - How can I call a server COM DLL from a client machine? Hi All, I am looking for ways to call a COM object from a remote machine. What is the best way to call it Some of the alternatives I can think of are DCOM, .NET Remoting or a Web Sevice. My calling application (Client application on a remote machine is a VB.NET windows application). Web service could be an easy solution, but performance is utmost importance here. What are the other alternatives Any help is appreciated. Regards, Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 15
    - getting data out of a database? I'm trying to set a variable outside of the database for quick use, but i can not find any way to do so in code. Could anyone please help i've tried a couple things with the code and this is where i am: SqlDataSource getData = new SqlDataSource(); getData.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); getData.SelectCommand = ("FROM [Forum] SELECT @Topic = Topic"); Profile.ForumId = getData.SelectParameters.Add("@Topic"); getData.Select(); and i've also tried this, but to no better sucsess: SqlDataSource getData = new SqlDataSource(); getData.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); getData.SelectCommand = ("FROM [Forum] SELECT Topic = @Topic"); Profile.ForumId = getData.SelectParameters.Add("Topic", SqlDbType.NVarChar, "20"); getData.Select(); the problem keeps coming from the bolded line. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development
  - 16
    - Why cannot load the win32 ini configs when using .net interop? In my project I should use a win32 library(dll), I have written the .NET Interop code for it. There is a ini format configuration files with the win32 library, I deployed them in the application folder, but when I put the application to run, it seems cannot load the ini configs. I think, there is some problem with the interop I use the DllImport to import the win32 library. How can I do now Waiting for your answer. Very Thanks. Tag: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records .NET Development

jilan3109

Trying to add a record by setting all the rows in each table to

For Each row As DataRow In Me.TTSDataSet.SiteInfo.Rows

row.SetAdded()

then i use a tableadapter to update the record, but then i have already encountered a duplication issue.

So i would like to check the destination database to determine if the record exist either by name or some attribute to avoid conflict. Can some show me a possibility.

Then i can trigger the row.SetModified()

Thanks

Top

Re: .NET Framework Data Access and Storage Trying to add a record to a SQL 2005 DB via Vb 2005 Application but avoid Duplicate Records

VMazur

To uniquely identify records, you need to have primary key and check if record exists based on a values in primary keys. I believe you could do it using stored procedure, passing values for the record to it, checking if it exists, based on PK and return or insert record, based on the check

Top