Answer Questions

• Bogey1 Quick and Dirty Simple Authentication with WSE 3.0 Help Needed...

  Hi all, I am trying to apply a very simple small layer of protection to a .NET 2.0 web service with WSE 3.0. I want to send a token (username and password) in each packet to the service, then in the service I want to be able to validate using an external assembly (token will be validated against a sql 2005 database in production already) then return. Entire service will validate each call - but no separate layers of security or certificates or anything else... Has anyone done this before - and can they offer any help Keywords here are simple, small and fast to implement :) Thanks Bruce, WSE will validate the credentials using AD by default. If you need a custom authentication approach, ei ...Show All

• Nikhil - MSFT Executing a query against Access and Excel

  Hi, there I wrote a program that reads data from both Excel and Access. But I don't know how to submit a query to both of them. Connection to Excel is made through OleDb in code, and Access connection is made through Database Explorer, in design time. The question is: how can I make reference to these sources Thanks, Flavia So are you getting an error I'm not sure what the problem is. I just don't know how to reference tables from each dataset in a sql statement. For example: "select <access_table>.my_code as projeto where <excel_table>.installation = <access_table>.client_code" Getting info from Excel spreasheets is ok, but how can I reference Access schema Yours, Flavia ...Show All

• LearnTheThings connect to an access database

  Hi everybody, I want connect and manipulate data from an MS Access db, I've done some digging on the internet, but found many and different approaches that for some reason were raising errors. Can anyone gimme some pointers or some code snippet that can help me walk on the coreect way. 10x See if the following helps: How to use Microsoft Visual Basic .NET to connect to a Microsoft Access database and to retrieve data You should look for ADO.NET . .NET offers via ADO.NET a standardized way to access different databases. For Access you need to use OleDB  ( .NET namespace for OleDB )! For the connection string look at www.connectionstrings.com Here are few MSDN link 2for ADO.NET 2.0 http://msd ...Show All

• donWong StreamReader, Regex and memory

  I am using StreamReader's method ReadToEnd() to read an entire file in to a String. I then use a Regex to parse some content from the file. I do this two times for each file to get all the data i want from it. The first regular expression looks like this: String^ regexData1 = "<tag>( <Occurrence>.* )</tag>"; Regex^ regOccurrence = gcnew Regex(regexData1, System::Text::RegularExpressions::RegexOptions::IgnoreCase | System::Text::RegularExpressions::RegexOptions::Singleline); This is working just fine for now and whit smaller kinds of files. But I would like to learn how to parse larger files. I suppose that I can't use ReadToEnd() with really large files. I could use ReadLine() instead to parse ...Show All

• MickDotNet FtpWebResponse.Method = Ftp.UploadFileWithUniqueName

  I am writing a Winforms program to replace a cmd batch file that uploads a file to an ftp site and the folder on that site is d:\UploadedFiles. The site is ftp://uapkb100.central.com . I can upload to the ftp site by using the following create stmts but I cannot figure out a way to upload the file to the d:\UploadedFiles folder. The cmd file used the following lines in its ftp text file. How can I do the same thing in my .Net program That is write to the correct folder. :--DOS Cmd file stmts----- UserID Password lcd d:/UploadedFiles put SANION13.txt '----My VB.2005 statements-------- Dim uploadResponse As FtpWebResponse = Nothing Dim uploadRequest As FtpWebRequest = Nothing ftpFileName = " ftp: ...Show All

• Andy Britcliffe custom control focus enter event

  I'm sure I posted this before but now I can't find it on the boards. I've made a custom control which has three picture boxes and a combo box. Is there a way to determine when the control as a whole has or looses focus. It was suggested that the enter event for the control could be used. This, however, only seems to work if I click on the actual control 'container' . If I click on the picture boxes or combo box it does not seem to be triggered. Have I done something wrong in the creation of the control or not set some property Any advice or thoughts greatly appreciated. Cheers, Gareth Thanks, I ended up putting the following into the click event of each control; this .UserControl_Ent ...Show All

• donkaiser Dataset.GetXml incorrectly renders XMLNS, breaks XSLT

  I have a very simple dataset, just 4 fields in one table. I am using the GetXml method of the dataset to render the XML into an XmlStream, and then XmlCompiledTransform to implement an XSLT, then save it to an HTML file. The Dataset.GetXml method oncorrectly renders the xmlns for my dataset, though. Since it is a strongly typed dataset, the XSD is added to the root node, as such: < xml version="1.0" encoding="UTF-8" > < xml-stylesheet type='text/xsl' href='ProblemStoreReport.xsl' > <ProblemStores xmlns=" http://tempuri.org/ProblemStores.xsd "> <ProblemStore> <SiteNumber>00260</SiteNumber> <SiteName>00260 - 632 3RD AVE.</SiteName> <Variance> ...Show All

• Kevin J Baird Locale of ThreadPool's Thread

  Is there any way to modify CurrentCulture/CurrentUICulture of ThreadPool's threads OR to set the default values of these properties for every thread created within a process ThreadPool threads may be created before your application's entry point is even executed--their default culture will be whatever the system's culture is set to. The only way to have a custom culture, as you've described, is to manually set the threads' culture. hmmm... that means I have to set the culture in whatever function I pass to QueueUserWorkItem . I think there should be an option to set the default culture for all threads within a process. Framework might want to change (talking about TP) it for its own but can restore ...Show All

• bluefish c# ms access problem

  Dear All. I have mdb file (office 2003) with table called table1 (F1 int primary key, F2 text). and below is my c# code: private void FM_Main_Load( object sender, System.EventArgs e) { System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(); Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\db1.mdb"; System.Data.OleDb.OleDbDataAdapter DA = new System.Data.OleDb.OleDbDataAdapter("select F1, F2 from table1", Conn); DA.Fill(DS); // DS is the typed dataset with structure as table1 } But when I run my application it gives below error: "The Microsoft Jet database engine could not find the obj ...Show All

• LarBru SqlDataReader.Close or .Dispose results in Timeout Expired exception

  Hi everyone, I have a project in VB 2005 that uses a data access layer (custom dev) to open and return SqlDataReaders. There is one method in my project where the call to SqlDataReader.Close() or SqlDataReader.Dispose results in a timeout exception. The code roughly looks like this Dim dr As IDataReader = Nothing Try dr = <call to data access layer> If (Not dr Is Nothing) Then Do While (dr.Read() AndAlso ...) ' Code here to read a string field from the datareader Loop End If Finally If (dr IsNot Nothing) Then dr.Dispose() End If End Try The code fails on the dr. Dispose line. Replacing with dr.Close() results in the same exception. The Data Access Layer looks like this: ...Show All

• Andrew J Problems deleting a record.

  I am using VB 2005 with a Access data base and I am getting the following error code. “Parameter [@DonorID] has no default value. objCommand = New OleDbCommand( "Deductable_Delete" , objConnection) objCommand.CommandType = CommandType.StoredProcedure objCommand.Parameters.Add( "@DonorID" , OleDbType.Guid, 16, New Guid(txtDonorID.Text).ToString) ‘ 'open the dataBase connection OpenConnection() intRowsAffected = objCommand.ExecuteNonQuery() close etc... Is my problem in access or vb. The "ToString" was added to get rid of a sintax error. Thanks for the help. Thanks, The first reply fixe ...Show All

• laboremus tcplistener and guest login

  This is the source file that i am having trouble with. When the user is logged in as guest (built in account guest) the ListenToServer function isnt accepting connections. I tried to impersonate the administrator, everything works fine if logged in as an admin. Please take a look and see what i am doing wrong using System; using System.Collections.Generic; using System.Windows.Forms; using System.IO; using System.Net; using System.Net.Sockets; using System.Threading; using System.Runtime.InteropServices; using System.Diagnostics; using System.Security.Principal; namespace client { static class Program { [ StructLayout ( LayoutKind .Sequential, Pack = 1)] ...Show All

• Vijay R dataset paging for a large oracle dataset

  i've got a datagrid that needs to be able to page through and sort (multiple columns) a large oracle dataset (1,000's of rows)... i can't simply return the entire dataset, it'll be too big...so i need to return smaller slices of data and then go back to the db to get more when needed... i assume someone else has already solved this as i don't want to try and reproduce a wheel that's already been created... thanks for the help See if the following helps: Paging Through a Query Result ...Show All

• Camey Import Excel sheet using ASP.net web application

  Hi all, this is thiru from India, hope i shall get answers here for my questions. 1. I need to import an Excel spread sheet to a remote sql server database through ASP.Net web application. I brief the process im following now please go through it. Import Process: a. select a fiile(.xls) and upload it to server. b. using M/S Odbc Excel driver, and the uploaded excel file as datasource, c. query the excel sheet to populate a dataset. d. iterate through the rows of the dataset(I could not bulk copy the excel data, because have to check the database, if record exists then update, else insert) to import to the SQL Database Performance issues: 1. I have to import spreadsheets having upto 60,000 records or even more at a tim ...Show All

• Curtis the Analyst of Doom ASP.NET Controlling Browser Sze

  This may seem like, and very well may be, a stupid question, but does anybody know if it is possible to control/set the size of a browsers window from within an ASP.NET application I know you can set the size of a new window, but that is not what I'm talking about. What I would really like to be able to do is to resize the size of the browser in which my site is initially loaded. So, for example, if the user's browser is set to 300x300 (or whatever), when they hit my website I can change it to a different size to make presentation better. They could subsequently change it again, but at least I would have made the attempt. The forums at http://forums.asp.net are better able to answer UI questions. Th ...Show All