DataSet location

.NET Framework Data Access and Storage

- Previous
  - 1
    - Cross Thread Problem with SerialPort DataReceived Event Hi I am sorry, I am having trouble with this: this->synchronizationContext->Send((IDelegateCreateExpression NYI), e); as the argument for send, I had: this->synchronizationContext->Send( gcnew System::Threading::SendOrPostCallback(&MyClass::OnMyEventInternal) , e); That didnt work, can you elaborate on: Send((IDelegateCreateExpression NYI) thanks - Tag: .NET Framework Data Access and Storage DataSet location .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 DataSet location .NET Development
  - 3
    - XML Digital Signature Problems Hi, I've had a look at this and the results are interesting, here is what I did. First of all I stored a RSA key in the CSP for both SignedXml and MSXML to use. I then changed your sample XML file so that it only contained the SetDTE element, I removed all the signatures and the parent EnvioDTE, I just worked with the XML document. I created a detached signature for this document in .NET using the RSA key, not storing the KeyInfo, and this signature verified ok when checked in .NET. I then created a detached signature in MSXML using the same RSA key, not storing the KeyInfo, and this signature verified ok when checked in MSXML. However neither the DigestValue or the SignatureValue matched. I am getting completely different signatures and the MSXML signature is not being verified in .NET. Here is why I think this is happening. There is a difference in the way that the detached signature is being generated in both technologies. In .NET the XML file is being signed using a stream (because any file can be signed with a XML detached signature and so the XML is treated as binary) however in MSXML the XML file is being signed from a DOM. I'm using VBA inside Access to write the MSXML and the Sign method accepts a type of IStream but I cannot for the life of me find anyway in VBA to create an object of type IStream. I need to say that the .NET code you posted is not creating a detached xml signature. Here is how you create a detached signature in .NET for an XML document. 'sign the document into a detached signature Dim dsig As New SignedXml() dsig.SigningKey = key Dim strm As New FileStream( "XmlFile.xml" , FileMode.OpenOrCreate) Dim fileToSign As New Reference(strm) fileToSign.Uri = Path.GetFileName(strm.Name) fileToSign.Type = System.Net.Mime.MediaTypeNames.Text.Xml dsig.AddReference(fileToSign) dsig.ComputeSignature() strm.Close() From your code it looks like you are creating a enveloping signature without setting any object data. I am going to try the same experiment with an enveloping signature and see what the results are. That should remove the difference between using the Stream in .NET and the DOM in MSXML and hopefully the two should verify. If I had known about the IStream in VBA I wouldn't have bothered doing this test, but it's still good practise. I will post my findings. Tag: .NET Framework Data Access and Storage DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .NET Development
  - 7
    - The user is not associated with a trusted SQL Server connection. Let's see your ConnectionString. Note that you can connect to a SQL Server using Windows authentication (Integrated Security=SSPI) or SQL Server authentication (where you provide a hard-coded UID and PWD). In an ASP application if you use SSPI authentication, you need to setup rights for the IIS account (which vary based on the version of IIS). IIS 7 uses IUSR_<machinename> so you need to grant rights to the target database using SQL Server Management Studio (Express). If you've configured SQLEXPRESS to permit SQL Server (mixed mode) authenication, you need to create a user account and (again) grant rights to the target database. See Chapter 9 of my book or get started with the whitepaper on connecting on my blog. www.betav.com/blog/billva hth Tag: .NET Framework Data Access and Storage DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .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 DataSet location .NET Development
  - 16
    - Help connection to a database. Let me also repeat. The connection string is wrong. Fix your connection string and the problem is solved. Adamus Tag: .NET Framework Data Access and Storage DataSet location .NET Development
- Next
  - 1
    - 64-bit License Compiler issues You could call the makers of the component they could have a solution for you since it is licensing related. Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 2
    - schemaLocation problem with Serialization. I am using serialization in c# 3.0 (trying to serialize). I want to use the schemaLocation xml attribute as that is what is in an example i need to stick to. I cannot work out what c# attribute i need to use to do this. I have tried: Code Snippet public Class exampleClass { [System.Xml.Serialization.XmlAttributeAttribute("schemaLocation", Namespace = "http://www.rewerse.net/I1/2006/R2ML http://oxygen.informatik.tu-cottbus.de/R2ML/0.4/R2ML.xsd")] public string schemaLocation; } where "exampleClass" is the root node in the serialized document. The output should be like: Code Snippet <exampleClass schemaLocation="http://oxygen.informatik.tu-cottbus.de/R2ML/0.4/R2ML.xsd"> ... </exampleClass> what comes out is more like: Code Snippet <exampleClass xmlns="http://oxygen.informatik.tu-cottbus.de/R2ML/0.4/R2ML.xsd"> ... </exampleClass> Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 3
    - IPv6 Multicast Hi, I'm trying to find out how IPv6 Multicast works, from a C# application's viewpoint. How are multicast addresses assigned i.e. how would an application obtain a multicast address for use on the public internet. How does an application connect to a multicast address and recieve data. i.e. Computer A is multicasting how does computer Z register its interest in that multicast when the public internet (Computers B through Y) stand in the way. Cheers Colin Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 4
    - List<T> collection not getting disposed even after closing the form. You are calling GC.Collect() too soon to be able to collect your InfoClass[] object. It is being kept alive because of the reference held by the Form object. The Form object is still very much alive by the time the FormClosing event runs. Which keeps the object alive too. You might have noticed that a Form object never gets collected, even though there is no active reference to it anywhere. The Form object is being kept alive by an internal handle-to-object mapping table inside Windows Forms. It keeps the form from suddenly blinking out of existence when the next GC collection runs. The reference to the form (and by inference, your InfoClass) doesn't disappear from the mapping table until WF gets the WM_NCDESTROY message, the message that Windows sends just before it makes the Handle invalid. Although it might technically possible to wire into that message to call GC.Collect(), there is absolutely no reason to do so. The trusty garbage collector will finish your object off when it decides the time is right. It is almost never wrong, certainly not in this case. Next time you try to diagnose a memory leak problem, be sure to create and destroy (dispose) an object no less than 100 times. If the memory usage keeps going up, and increases well beyond 2 megabytes, you might have a real leak. Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 5
    - Business layer passing results from a SQLDatareader Hi, I'm creating a business layer to access an SQL database cycle through the data for validation and pass the clean data onto an ASP form. I am currently retrieving the results into a SQLDatareader into my class file. I loop through the reader and validate the data. Should I place the results into an array Is that the best way to pass that data via code to my VB code for the ASP form. Can I transfer that into a datatable or something similar. I don't mind cycling through the records in the VB part of the ASP form but I don't want to persist any SQL connections. Thank you for your help Vear Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 6
    - How do you 'Join' a background worker thread? I am using a 'BackgroundWorker' object to impliment multithreadeding because it provides a really neat way of passing events into the main UI thread. My problems occur when it is time to halt the background worker thread. I can easily signal the thread to exit via synchronization objects and if desired I can service the 'RunWorkerCompleted' event later on but what I can NOT neatly do is wait for the thread to exit after I have signalled it to do so. If this was a thread I had instantiated myself I could call its 'Join' method but I can find no equivalent for the BackgroundWorker - nor can I see anyway to get hold of its thread to call join on it myself. I can bodge something up using synchronization objects so that the thread loop releases an object just before it exits and the terminating function 'Waits' on this object. But this approach causes problems during debug. Is there any way to perform a 'Join' or some equivalent operation on a background worker thread. Thanks in advance for any help or discussion on this subject. Ted.. Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 7
    - sproc to determine if query will produce Invalid SqlNotificationEventArgs event I'm using an SqlDependency so I'll get an alert when the data under a query changes. When the query does not meet the criteria spelled out here http://msdn2.microsoft.com/en-us/library/aewzkxxh.aspx then I immediately get a SqlNotificationEventArgs event with the "Invalid" note. This is good. I would like to know that a query is invalid before I try it with my ASP.NET application. Is there a sproc I can give to my SQL developers so they can test that they haven't used any stuff that would invalidate SqlDependency What I'm hoping is that there's already a system sproc which could be called... exec sp_QueryInvalidForNotification "exec myTestSproc 99" Does such a sproc exist Or does anyone know how to write one Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 8
    - WSE 3 and VS2008 Hi, Are there any plans to support WSE 3 in VS2008 I tried installing WSE 3 after VS2008 Beta 2, but does not integrate with the IDE. Thanks Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 9
    - Sending content of file over serial connection. You must be using .NET 1.1. Here's a replacement for File.ReadAllLines(): public static string[] ReadAllLines(string path) { System.Collections.ArrayList list = new System.Collections.ArrayList(); System.IO.StreamReader sr = new System.IO.StreamReader(path); string txt; while ((txt = sr.ReadLine()) != null) list.Add(txt); sr.Close(); return (string[])list.ToArray(typeof(string)); } Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 10
    - Configuring Jet connection parameters using .NET OLEDB connection I'm not aware of such a resource. It probably would depend upon what you are attempting to accomplish and what your code looks like. Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 11
    - How to save xml file in a client-server environment... I have used the doc.Save( Application .StartupPath + @ \..\config\\vb_alias.xml ); to save on my local machine & it works here. But when in a client-server environment i want to save some thing it gives error that Access to the path \\client57\myTest\product\config\vb_alias.xml is denied. Please help me. With regards Tapan Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 12
    - Difference between CreateInstance and CreateInstanceandUnwrap ? Hi, Can somebody please tell me how object returned by Assembly.CreateInstance() is different than AppDomain.currentDomain.CreateInstanceAndUnwrap () When a webservice calls my businessclass which dynamically loads a dll and invokes a method on a object, I get an error "MissingMethodException" if I load the assembly and create instance using reflection (Assembly.CreateInstance) and do not get the exception if I use AppDomain.CurrentDomain.CreateInstanceAndUnwrap. Can somebody please tell me how these methods are different Are there any performance implications of using CreteInstanceandUnwrap method Aditi Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 13
    - IIs 5 and .net 2 - major issues The first link covers Asp.net permissions and the second covers permissions in IIS6 because you did not say if the server OS is Win2k or Win2003. Hope this helps. http://msdn2.microsoft.com/en-us/library/kwzs111e.aspx http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2016829&SiteID=1 Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 14
    - Please help me Dear Sir, After populating the records from a text file into gird, and when we select another text file to populate into the same grid control the following message is coming " Cannot create child list for a filed". dataGrid1.DataMember = "csvCustomer"; The error will come inthis position. What I have to do to read another file in the same grid. Please help Thanks in advance. Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 15
    - SQL connections stop & Webservices Hello, I appeal to all to save me from this situation. I have a WebService in VB.net by IIS and a operation to connect to the SQL server and run a query and others operations. All fine... But after a certain time only the SQL operations don't respond nothing, the others are OK. So the problem is not in the IIS i think and something between the IIS and the SQL Server. Can you give me some light about this PLEASEEEE Thanks If any of you need the source say it. Thanks Tag: .NET Framework Data Access and Storage DataSet location .NET Development
  - 16
    - converting of wsdl to cs file Hi all, I want to convert my wsdl file to cs file. Can any one help me with an example. Thank you. kris Tag: .NET Framework Data Access and Storage DataSet location .NET Development

RedLion1973

Hi, ALL!

I had added an sdf file to my project and created dataset on design time.

While running the application on WM2003 the sdf must be located in application folder otherwise I get an error...

I'd like to move the sdf to memory card, but can't find how to change connection string!

Any help!

Lev

Top

Re: .NET Framework Data Access and Storage DataSet location

Derek Smyth

Hi mate,

The connection string should be stored in the app.config file. It's stored in the <ConnectionStrings> element.

Top

Re: .NET Framework Data Access and Storage DataSet location

RedLion

Thank You!

But where is a app.config file located

Top

Re: .NET Framework Data Access and Storage DataSet location

RedLion

Thanks a lot!

But where is app.config file located

Top

Re: .NET Framework Data Access and Storage DataSet location

Derek Smyth

Hi mate,

You should see it in the Solution Explorer along with your project. When you add and use a database in your project using the tools and panels of Visual Studio it usually automatically creates a configuration file for you and stores the connection string in there. It's added in the solution explorer along with your forms and other items. Just double click it and it will open, you'll see the connection string.

Top