Using a .accdb database as a datasource in Visual Studio 2005

.NET Framework Data Access and Storage

- Previous
  - 1
    - Shared configuration file between 2 apps I have two applications (one WinForm one WindowsService) that need to share some common settings. Right now we are using the registry to save these settings but would like to move these to an xml file that both can read/write to. From what I have read it looks like the app.config won't work because it is per application. So is my only choice reading/writing from a XML that both apps know about, or is there some way I can use some of the .net Settings framwork Thanks for the ideas. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 2
    - diffrence b/w .net 2.0 and .net 3.0? what is .net 3.0 frame work hw it is diffrent from .net 2.0 can we install it on windows xp service pack 2 Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 3
    - Attributes in a List<T>, how can i create a new list based on the type? Hi all, I don't think it would be easy to understand what I'm trying to do, but I'll try my best. I'm trying to write a simple object persistence framework, so far a got good results with single property values, but now I'm stuck with a One-Many relationship. What I want to do is, imagine my class is the following: class Order : SimpleObjects { public Order() : base() { } public Order(string ID) : base(ID) { } private List<OrderItens> _itens; [Persistent] public List<OrderItens> Itens; } In my base class a have a collumn ID and a method do fetch the details based on the ID and on the Class type, but i can't figure out how to get the type of this generic List and get all the Itens with the order ID, basically my code is something like this: foreach(PropertyInfo prop in this.GetType().GetProperties()) { foreach (Attribute atrib in Attribute.GetCustomAttributes(prop)) { if(atrib.GetType() == typeof(Persistent)) { if (prop.CanWrite) { if (prop.PropertyType == typeof(String)) prop.SetValue(this, r.GetString(r.GetOrdinal(prop.Name)), null); } } } } But in the case of the List, How can i know the type of the list, and based on it populate it with the right objects Thanks in advance for any help. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 4
    - Orcas Beta 1 and Acropolis Quick question . Has anyone had any issues w/ installing VS orcas beta 1 on their dev box and working off that instead of going the route of VPC I would love to check out Acropolis, but VPC are just too slow for me sometimes Thanks Nuz Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 5
    - Questions about using Native Images... Greetings, I've been coding in C# for a while now, and I kept running across ngen (Native Image Generator) which pre-JITs your application. Since I don't exactly know where this should be posted, I figured I'd post in the forum that relates to the language it was originally compiled in (granted it's translated into MSIL on compile, but...). The project is a foundation of classes geared towards making an IDE in a relatively simplistic manner, relying on Attributes and heavy reflection, including creating new generic types to the types bound to the system. Because of this, first case JIT on load takes 4-6 seconds if I'm lucky, and I noticed that later JITs on other types were relatively quicker since the code-base for the generics was already JIT'ed the first time (if I understand that Generic code is reused to a certain degree). I tried using NGen on my local system to create an image to see if it would be beneficial (it was also a first time test case of NGen). The comment command line used was: "ngen /silent /nologo $path$\_abs.core.dll" To give you an idea on the _abs.core, in Release mode it is 884KB, debug mode 972KB. Granted size doesn't tell you much, but I was a bit surprised at what happened. My CPU usage shot to 100% and it stayed there for thirty minutes with two mscorsvw instances in memory (one for the job, the other for work). The worker instance of mscorsvw was eating the CPU cycles and staying at around 23-24 MB memory usage. It stayed there for over thirty minutes and I couldn't see any notable change in disk usage or memory really for that matter. I understand that NGen is used to pre-compile, but how long should it take on an average case The IDE Framework contains a remade CodeDOM infrastructure (because CodeDOM is ... bad, set a method's PrivateImplementation to a generic, you'll see what I mean), a project system infrastructure, standard lightweight utilities, and a type services system that allows for open generic services to be bound to a type and allows for them to be closed at run-time (using reflection to fill in the 'gaps' in the type-parameters based upon the other attributes applied, with the active type of the instance using the services along with the active type being used as a generic argument). I'm in no big rush to get an answer, but it would be nice to be able to figure out if this is a standard case for NGen (thirty minutes was all I could take, I terminated the worker mscorsvw). If this is the wrong forum, I apologize Thanks in advance, -Alexander Morou Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 6
    - SAP XI - .NET Web Service Communication Hello, I have the next situation. I must develop a web service that will receive input from SAP XI - a tool that receives message from SAP System. I developed the web service like this: - i created a schema based on the xml that i will receive - generated a proxy class usign xsd.exe - develop web method tht accepts an object of the proxy class and call the bussines components that will store the data into the sql Db. Problem is that from a .net client the web service works. Also from infopath, Altova XML Spy but from SAPXI it does not work. I developed soap extensions to trace the raw xml message that was sent by sap xi. The xml message is identical; for example if a take the xml message from the log file and paste it into XML Spy it works. but when it comes from sap xi it does not work - the object that i receive as input to my web method is null. If somebody has an ideea why this happens or if somebody has developed a .net web service that interacted with sap xi please let me know how did you manage to make xi and .net communicate. Thanks in advance. Marius, Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 7
    - Import and Export Outlook Contacts To SQL db Via asp.net web application Hi all I serach for any thing help on this issue but I get Nothing anyone can help me Plesae thanks & regards Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 8
    - Creating Performance Counter Logs using C# Hey, I hope that I'm posting my question in the correct place. I'm developing an application that should sample certain Performance Counters with predefined frequency and save results to the Log file. Windows allows to create, configure and run Counter Logs using mmc. I've spent a lot of time looking for an API that allows to interact with this feature programatically and haven't found anything. Is there any way to create/manage these Performance Counters Logs using C# or any Win32 unmanaged API Thanks. P.S. Sorry for my English Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 9
    - Dynamic Assemblies unable to IDispatch Hello All, I have an interesting idea to increace productivity on a project of mine. My hope is to be able to create an instance of a C# component through the CCW using standard ComVisible techniques. That all works fine. Once the object is instanciated, it creates a Dynamic Type in a Dynamic Assembly and returns it to the host. This also works fine. The problem is that the in memory instance does not properly impliment IDispatch to VBScript is not able to make calls on it. Is there any way to override the stanard IDispatch of the CLR Or better yet, can I get the type to "just work" Code Snippet [ ComVisible ( true )] [ Guid ( "0EC51F67-0426-495b-B2C2-06515EB63DE0" )] [ ClassInterface ( ClassInterfaceType .AutoDual)] [ ProgId ( "DirectorsDesk.ConfigurationServiceRuntimeAgent" )] public class ConfigurationServiceRuntimeAgent { bool _isAspCalled = false ; Server _aspServer; public ConfigurationServiceRuntimeAgent() { object serverObject = ContextUtil .GetNamedProperty( "Server" ); if ((serverObject != null ) && (serverObject is Server )) { _isAspCalled = true ; _aspServer = serverObject as Server ; Response aspResponse = ContextUtil .GetNamedProperty( "Response" ) as Response ; aspResponse.Write( "This comes from .NET!" ); } } public object Stub() { AppDomain currentAppDomain = AppDomain .CurrentDomain; AssemblyName dynamicName = new AssemblyName ( "DynamicAssemblyDD" ); AssemblyBuilder assemblyBuilder = currentAppDomain.DefineDynamicAssembly(dynamicName, AssemblyBuilderAccess .RunAndSave); ModuleBuilder moduleBuilder = assemblyBuilder.DefineDynamicModule( "DynamicAssemblyDD.dll" , "DynamicAssemblyDD.dll" ); TypeBuilder typeBuilder = moduleBuilder.DefineType( "CompanyConfigurationType" , TypeAttributes .Public); typeBuilder.DefineDefaultConstructor( MethodAttributes .Public); ConstructorInfo clsI = typeof ( ClassInterfaceAttribute ).GetConstructor( new Type [] { typeof ( ClassInterfaceType ) }); typeBuilder.SetCustomAttribute( new CustomAttributeBuilder (clsI, new object [] { ClassInterfaceType .AutoDual })); ConstructorInfo cvType = typeof ( ComVisibleAttribute ).GetConstructors()[0]; typeBuilder.SetCustomAttribute( new CustomAttributeBuilder (cvType, new object [] { true })); MethodBuilder getExValueMethod = typeBuilder.DefineMethod( "GetExValue" , MethodAttributes .Public, typeof ( string ), null ); ILGenerator ilGenerator = getExValueMethod.GetILGenerator(); Label brS = ilGenerator.DefineLabel(); ilGenerator.DeclareLocal( typeof ( string )); ilGenerator.Emit( OpCodes .Nop); ilGenerator.Emit( OpCodes .Ldstr, "Hello World!" ); ilGenerator.Emit( OpCodes .Stloc_0); ilGenerator.Emit( OpCodes .Br_S, brS); ilGenerator.MarkLabel(brS); ilGenerator.Emit( OpCodes .Ldloc_0); ilGenerator.Emit( OpCodes .Ret); Type resultType = typeBuilder.CreateType(); assemblyBuilder.Save( @"DynAssembly.dll" ); return Activator .CreateInstance(resultType); } public string StubUsed() { object stubObject = Stub(); Type stubObjectType = stubObject.GetType(); return ( string )stubObjectType.InvokeMember( "GetExValue" , BindingFlags .InvokeMethod, Type .DefaultBinder, stubObject, null ); } } This is an example client Code Snippet < html xmlns ="http://www.w3.org/1999/xhtml"> < head > < title ></< FONT> title > </< FONT> head > < body > < script runat ="server" language ="vbscript"> ' VBScript File Set oClient = Server.CreateObject ( "DirectorsDesk.ConfigurationServiceRuntimeAgent" ) Response.Write(oClient.StubUsed()) Set oGen = oClient.Stub() Response.Write(oGen.GetExValue()) </< FONT> <script > </< FONT> body > </< FONT> html > The call to StubUsed works, as .NET can reflect and late call the method, but the call to GetExValue() directly does not work. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 10
    - Intefaces like IDisposable Hi at all, I'm trying to create an interface like IDisposable. If I create a Class that implements IDisposable automatically, when I press enter/tab, VS2005 IDE will create code: Private disposedValue As Boolean = False ' To detect redundant calls ' IDisposable Protected Overridable Sub Dispose( ByVal disposing As Boolean ) If Not Me .disposedValue Then If disposing Then ' TODO: free managed resources when explicitly called End If ' TODO: free shared unmanaged resources End If Me .disposedValue = True End Sub # Region " IDisposable Support " ' This code added by Visual Basic to correctly implement the disposable pattern. Public Sub Dispose() Implements IDisposable.Dispose ' Do not change this code. Put cleanup code in Dispose(ByVal disposing As Boolean) above. Dispose( True ) GC.SuppressFinalize( Me ) End Sub # End Region Anyone know how can I create an interface like IDisposable Thank you very much! Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 11
    - Dynamically change URL of webservice client at runtime Hi, I have a webservice that I wish to call from a client app written in VB. My problem is that I need to programatically change the URL during runtime. I know the path to the wsdl will always be the same but the server hostname and port must be updated. I want to be able to type in the hostname and port and then call the webservice. I have spent the last three days looking for ways to accomplish this with no luck. Someone from Microsoft recommended a proxy override in another post but the sample code was not VB and I could not figure out how to apply the same concept in my app. Does anyone have any idea how this can be accomplished using VB Best regards, John Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 12
    - Type Libraries I have a MS Visual Studio 7 .NET Class Library project whcih produces a dll (MyDLL.dll), I would then like to import the type library from it in Visual Studio 6 using a #import "MyDLL.dll". I really want to avoid the intermediate step of using tlbexp.exe as it is not available to us on a remote build machine. Is this possible Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 13
    - host name from HOSTS file not resolved with HttpWebRequest Hi all, I've a tricky problem using HttpWebRequest to place a GET request. In my hosts file I defined some names for few IP addresses that are on a local Network adapter. 127.0.0.1 localhost 192.168.254.1 xs.pc 192.168.253.1 xs.card 127.0.0.1 xs.simu If in my request I give the IP address it works normally, however if I give the alias name, like xs.pc, it doesn't work. The device never gets the packets. The line of code looks like this: HttpWebRequest httpRequest = ( HttpWebRequest ) HttpWebRequest .Create( new Uri (" http://xs.pc /ewd/login/all ")); -> Doesn't work HttpWebRequest httpRequest = ( HttpWebRequest ) HttpWebRequest .Create( new Uri (" http://192.168.252.1 /ewd/login/all ")); -> Does work localhost seems different because even if I remove it, it still works!! What I don't understand is that it works with the ping command, the browser or an XmlHttpRequest placed from a Firefox toolbar. I searched in the HttpWebRequest class but I didn't find anything to configure this. Does anyone knows how to fix this problem Thks by advance Olivier Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 14
    - DllImport Issue I am currently trying to make use of a .dll file that was written in C++ in one of my vb.net 2005 applications. Initially I thought I could simply add the file as a Reference to my project, however, I found this didn't work because the .dll was not written with managed code. After a little research I found I could accomplish this task by using DllImport. I wrote the following code to test this: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim InputRecords As New ArrayList Dim CmpltCheckFlag As Char Dim OutputRecords As New ArrayList Dim MessageRecords As New ArrayList Dim ReleaseList As New ArrayList CmpltCheckFlag = "Y" InputRecords.Add("Test") OutputRecords.Add("Nas") MessageRecords.Add("David") ReleaseList.Add("Something") Class1.TriConEngine(InputRecords, CmpltCheckFlag, OutputRecords, MessageRecords, ReleaseList) End Sub End Class Public Class Class1 'EntryPoint:="CallableTriConCEClient", <DllImport("CallableTriConCEClient")> _ Public Shared Function TriConEngine( ByRef InputRecords As ArrayList, ByVal CmpltCheckFlag As Char , ByRef OutputRecords As ArrayList, ByRef MessageRecords As ArrayList, ByRef ReleaseList As ArrayList) As Integer End Function End Class The .dll file expects five parameters: 1. &InputRecords of type vector<string> 2. CmpItCheckFlag of type char 3. &OutputRecords of type vector<string> 4. &MessageRecords of type vector<string> 5. &ReleaseList of type vector<string> I was not sure what data type to use on the VB.NET side so I chose Arraylist. I am getting the following error when I click the button on the form to test this out: An unhandled exception of type 'System.Runtime.InteropServices.MarshalDirectiveException' occurred in TestDLLImport2003.exe Additional information: Can not marshal parameter #5: The type definition of this type has no layout information. Any help or advice on this matter would be greatly appreciated. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 15
    - Silverlight in Acropolis? Hi, Are there currently any plans of incorporating support for Silverlight applications into Acropolis Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 16
    - Navigating through a DataSet Hi all, I was wondering if there was an easy way to navigate through dataset rows (this is not a DataGrid). I've used BindingManagerBase before. I am using a stored proc to retrieve data form the database. Here is my sample code... Code Snippet Form Load...etc. 'Connects to the database, runs the s/p and Fills the DataSet MyDataSet = SqlHelper.ExecuteDataset(SQLConnection, CommandType.StoredProcedure, "sp_Select_EmpData_Form" ) 'Binds my field to the form object txtpEmpID.Text = MyDataSet.Tables(0).Rows(0)( "Emp_ID" ).ToString I want to use a button to iterate through the dataset. I know I have to increment the Rows(0) value but I dont know how to do it efficiently. Thanks! Philip Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
- Next
  - 1
    - Cross Thread Problem with SerialPort DataReceived Event I am writing a custom Ref Class with C++ 2005 to control a measurement instrument via Serial Port. My class inherets System::IO::Ports::SerialPort. I also define events inside my class to generate action on specific RS232 messaages. My problem is as follows: Inside the datareceived event handler, I raise events based on messages reveived. However, when my class is instantiated on a windows form, if the event handler defined on the form changes properties of a textbox control, the sytem generates "System.InvalidOperation Exception" and goes on to describe that a different thread tried to access the control. I can solve the problem by setting the CheckForIllegalCrossThreadCalls property of the Windows Form to false. I do not like this solution, because it seems unsafe, and if someone other than myself was using my class, it might produce unexpected results in their program. I can also solve the problem using the invoke method of the form / control with delegates to produce a thread safe call as described here: http://msdn.microsoft.com/msdnmag/issues/04/02/TimersinNET/default.aspx I do not like this solution, as it puts too much burden on the Application programmer using my class, defeating the point of object encapsulation. If my class is in a published Assembly, I will have to explain to the programmer using it to define delegate / use the form->invoke method. My class also has a System::Timers::Timer , and the Elapsed event had the same issue, until I set the SynchronizingObject property of the timer to the Windows Form which instantiated my class. I like this solution, because it doesnt require anycode on the containing form, but the serialport class does not have a SynchronizingObject property, so I fail to see how to produce the same effect. 1 - Can I have my class inheret something so that it has a SychronizingObject Property 2 - Can I use any object System.Threading to invoke the event on the thread of the containing form This is acceptable to me as long as the code required can be part of my class, and not the form on which the class is instantiated. 3 - Any other possible solution I am missing Thank You Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 2
    - How do I read context of XMLReader twice? If I MoveToContent() and ReadOuterXML() how can I go back and repeat the same thing again that is reset the EOF back to begining Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 3
    - XML Digital Signature Problems Hi everyone! I have a code to sign one XML using msxml5 and work perfect BUT the msxml5 is including only in the Office, so I am trying to convert my code to class of FrameWork to sign and I get the same value in the <DigestValue> but different value in the <SignatureValue> and of course I have using the same Certificate. So when I check the signature of the document XML with other application they say that is wrong the signature. Here is the code to sign using the framework class (Visual Basic 2005 .NET) and I using the deattach signature: dim id_container as string = "{10CA2CE8-A17E-436A-BB62-22B98F36CDA6}" dim FileName as string ="c:\demo.xml" Dim cspParams As New CspParameters cspParams.KeyContainerName = id_container cspParams.ProviderType = 1 cspParams.KeyNumber = 2 Dim key As New RSACryptoServiceProvider(cspParams) Dim doc As New XmlDocument() doc.PreserveWhitespace = True doc.Load(FileName) Dim signer As New SignedXml(doc) signer.KeyInfo = New KeyInfo signer.KeyInfo.AddClause( New RSAKeyValue(key)) signer.SigningKey = Key Dim referencia As New Reference() referencia.Uri = "#SetDoc" referencia.AddTransform( New XmlDsigC14NTransform()) signer.AddReference(referencia) signer.SignedInfo.SignatureMethod = SignedXml.XmlDsigRSASHA1Url signer.SignedInfo.CanonicalizationMethod = SignedXml.XmlDsigCanonicalizationUrl signer.ComputeSignature() '------------------------------------------------------------------------------------ Dim xmlDigitalSignature As XmlElement = signer.GetXml() doc.DocumentElement.AppendChild(doc.ImportNode(xmlDigitalSignature, True )) If TypeOf doc.FirstChild Is XmlDeclaration Then doc.RemoveChild(doc.FirstChild) End If Dim vencode As System.Text.Encoding = System.Text.Encoding.GetEncoding( "ISO-8859-1" ) Dim xmltw As New XmlTextWriter(SignedFileName, vencode) xmltw.Formatting = Formatting.Indented xmlDigitalSignature.WriteTo(xmltw) xmltw.Close() ANY HELP!!!!! Ernesto Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 4
    - match.value not cleared?? I have a function to extract items from a web page. I use Match.NextMatch() within a loop. However, the code appends each item extracted from the source document TWICE. It is as if the Match.Value string is not cleared until you append it. Here is the function: Private Function ExtractItemFromPage(sSource as String ) As Boolean Dim expr As New Regex( "\b\d{3}\s\d{3}-\d{4}" ) '-- Get phone number -- Dim m As Match = expr.Match(sSource) Do While m.Success txtPhoneNums.AppendText(m.Value & vbCrLf) m = m.NextMatch Loop Return True End Function Why is this appending the same number twice Do I need to call some function to clear the value of m.Value before I call NextMatch() Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 5
    - creating webservice Hi I need a web service on my server for getting filelist to client, but i have no clue how to create a webservice, I have the (I think) code that needs to be on server. Is it a windows service (c#) I should create or... and what is "HTC" do i need it [ WebMethod ] Public string[] fileList(string pathToFiles) { string[] files = System.IO.Directory.GetFiles(pathToFiles, "*.*", SearchOption .AllDirectories) return files; } The code above need to be a webservice on my server. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 6
    - Update on one table clears RowState in related table This is weird. I have a typed DataSet with two tables, tblHeader and tblDetail, related by a FK relationship declared in the DataSet designer. After making inserts and changes to both tables, I want to use the TableAdapters to write the changes to MSSQL. After doing the Update on tblHeader, however, the RowState of rows in tblDetail is changed to Unchanged, and no update occurs when I use the tblDetail TableAdapter. Both updates are bound to a SqlTransaction: Code Snippet sqlTran = MyConn.BeginTransaction(); ... set SqlCommand.Transaction to sqlTran in all commands in both TableAdapters ... confirm that tblDetail[0].RowState == Added tblHeaderTableAdapter.Update(tblHeader); ... check tblDetail[0].RowState and discover it is now Unchanged tblDetailTableAdapter.Update(tblDetail); sqlTran.Commit(); ... clear SqlCommand.Transaction ... confirm that NO changes were written to tblDetail in the SQL database Can anyone explain this behavior What should I look for It's as if AcceptChanges() is being called on tblDetail as a result of the Update on tblHeader. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 7
    - The user is not associated with a trusted SQL Server connection. Hi Forumers! I been working on this for an hour right now.. Where did I go wrong The first I error I got is to allow my SQLExpress connected remotely, and I did and after running my work the error message say something like this: Login failed for user 'asmt_admin'. The user is not associated with a trusted SQL Server connection. Tnx in advance.. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 8
    - Problen Inserting Data into a Ms Database I can not seem to find the problem in the following snippet of code. I would like the code to insert data into the Ms Database. I get an error message as follows. System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message="No value given for one or more required parameters." Below is the code for the application Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ' Create containers to contain Text Dim myLastName As String Dim myFirstName As String Dim myTELUSID As String Dim myWork As String Dim myCell As String Dim myEmailAddress As String 'Fill the new containers with data the user keys in myLastName = TextBox1.Text myFirstName = TextBox2.Text myTELUSID = TextBox3.Text myWork = TextBox4.Text myCell = TextBox5.Text myEmailAddress = TextBox6.Text 'Open database connection and prepare to add records 'Dim MyConn As New ADODB.Connection Dim strConn As String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source= e:\GDPR-OPE.MDB;" 'MyConn.Open(strConn) 'opens database command 'now add the command to execute the database add Dim SQL As String = "INSERT INTO tblEmployees" SQL = SQL + "(LastName,FirstName,TELUSID,Work_Number,Cell_Number,EmailAddress)" SQL = SQL + "values(" SQL = SQL + "myLastName,myFirstName,myTELUSID,myWork,myCell,myEmailAddress)" Dim myconn As New OleDbCommand((SQL), New OleDbConnection(strConn)) myconn.Connection.Open() myconn.ExecuteNonQuery() myconn.Connection.Close() Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 9
    - UsernameToken with actor Is there a special way to set client credentials for a web service client that needs to specify client and service actors in its policy If I have actors on my usernameForCertificateSecurity or usernameOverTransportSecurity assertion specified in my policy file, then even if I call SetClientCredentials on the proxy, I get an error similar to "unable to determine client token to use". You can easily reproduce in the RoutingClient project in the SecureRouting WSE 3.0 sample. Just change the client's policy to use one of the "username" assertions. I've gotten a little farther by using proxy->RequestSoapContext->Credentials->SetCredentials to specify a "credential set", but it either doesn't like the actor value I use or for some reason doesn't send the password when connecting to the router. My ultimate goal is to implement a router service that validates a user with some token service and then passes on the user credentials along with a new token to an inner service. Does anyone know of a good sample to do this Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 10
    - .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506) Hello, I got the following Error in my WXP Application Log after I tried to start a custom C# .net application .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Source : .net Runtime Category : None Event Id : 1023 ---------- I think this problem started when I removed the trail version of a C# Profiler [ from a vendor that I can't name under NDA ] It seems that the profiler installed a hook somewhere to start itself whenever I start any C# / .net app. Does anyone know where the hook could be installed I would like to remove the hook without reimaging my laptop.... Thanks ! Benjamin Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 11
    - Mouse Related functions in Windows XP I would like to capture the mouse's left click event and convert it to a right-click. A few examples of utilities that implement this, are: DialKeys (for the UMPC), Fujitsu made a utility for the P1510D Notebook/Tablet PC, and Samsung also implemented this for the Q1 in their "TouchMon" utility. The reason I am looking for a solution like this is that in a UMPC there is no easy way to right-click. I am looking for a utility which I can run (.exe) which will then convert my next mouse click into a right-click. After performing the right-click, the mouse should function normally. I am familiar with programming and .net so if someone provides me with sample code I would be able to create this utility myself. Thank you very much. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 12
    - Determining local or network environment within program Hey guys! I have a question about determining what kind of access a program has. This is the problem - there is an object whose data is populated via a web service (which gets data from the database) or via local access to the database. In the scenario where the application has no web access, I need the program to know that it should use the local access to populate the object. At this point, this is what is happening: if httpcontext object is null, then populate object using direct access to db. else populate object using web service. Is there any .NET function or whatnot that will allow me to determine what environment (local/network) the program is running in Thanks! David Pham Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 13
    - Calling 32-bit COM object fails 80040154 I have a .NET project that normally calls into 32-bit COM objects. I would like to port it to 64-bit but there is one COM object that must remain 32-bit. When the project runs, it gives an error "Retrieving the COM class factory for component with CLSID {...} failed due to the following error: 80040154." The error is 'Class not registered'. Having researched the issue, on 64-bit Windows my 32-bit COM dlls are registered in HKCR\Wow6432Node\CLSID instead of the normal HKCR\CLSID. When my .NET project runs in 32-bit, it looks to HKCR\Wow6432Node\CLSID and finds the correct object there. When it runs 64-bit, it looks to HKCR\CLSID and doesn't find it. I thought if I compiled my interop assembly to only target 32-bit, it might work. However, the 64-bit app did not like working with the 32-bit interop assembly at all. Does anyone know how to do this correctly Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 14
    - XML "Id" attribute Hi there, I tried to read an XML file by using Dataset.ReadXML() method. However, i cannot read some of the "Id" attribute for some elements. But when i checked the XML file, there are values inside. Anyone can be advised on this Thanks, JL Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 15
    - Smtp with c# through gmail. Hi guys, hope you can help. I have installed Visual Web Developed and started learning ASP.NET with c#. I am currently trying to build a website that sends email through gmail's smtp, here's the code: _______________________________________________________________________ using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Net.Mail; using System.Net; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); System.Net.NetworkCredential cred = new System.Net.NetworkCredential("xxx@gmail.com", "xxx"); mail.To.Add("xxx@xxx.com"); mail.Subject = "subject"; mail.From = new System.Net.Mail.MailAddress("xxx@gmail.com"); mail.IsBodyHtml = true; mail.Body = "message"; System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient("smtp.gmail.com"); smtp.UseDefaultCredentials = false; smtp.EnableSsl = true; smtp.Credentials = cred; smtp.Port = 587; smtp.Send(mail); } } _______________________________________________________________________ And I am getting this error message: Server Error in '/email' Application. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond I am testing the app on the server that's integrated in Visual Web Developer, could that be the problem What else could it be Please help. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development
  - 16
    - Help connection to a database. I'm workin on converting a C # program from VS2003 .NET 1.1 over to VS2005 .NET 2.0 . The program accesses an Access 97 database with a password. In the original program, the following connection string works: "Provider= Microsoft .Jet.OLEDB.4.0;Data Source=\" C :\\SLData\\Database\\SLDebit.mdb\";Jet OLEDB: Database Password=\"PaSsWoRd\";" The new program crashes at: connection.Open I'm fairly certain that the problem is that the Database Password property isn't getting set. If I pause runtime and add a Watch on my OLEDBconnection object , I can't even find where this property exists to check if it was set. In VS2005, I tried to add a new database through the Server Explorer and was able to verify that all of my above information is valid. Through the server explorer, I was able to view all the database columns and rows. When using the Connect to a Database wizard, I paused to view it's Advanced. settings before clicking Ok. This view of the properties resembles that of a Watch and I could see that the Database Password property indeed had to be set inorder to connect. I'm stumped. This all has to be accomplished programically. If anyone can offer any help, it would be greatly appreciated. Tag: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005 .NET Development

Ktscopes

I am trying to use an Access database (.accdb) as a datasource in a Visual Studio 2005 application but get an error saying it is an unrecognized database format. Is there some way to use this file as a datasource Thanks for any help.

Top

Re: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005

Paul P Clement IV

Are you using the correct OLEDB provider It should be the Microsoft Office 12.0 Access Database Engine OLE DB Provider (if you're using the wizard).

Top

Re: .NET Framework Data Access and Storage Using a .accdb database as a datasource in Visual Studio 2005

Ktscopes

Thanks, Paul. I will check that out. In order to continue working I started saving the .accdb files as .mdb files and just moving on, but ultimately I will need to answer the question and resolve the problem. I should have mentioned that I am programming in C#, although I don't know why that would make a difference. Thanks again.

Top