Hi there, I'm trying to use MSAccess as a "container" to move data around from one MS-SQL server DB to another. This is basically already a design decision that has been made for a lot of reasons and can't be changed by me. What I was wondering is what is the bet way to populate the MS-Acce...more >>

<form id="Form1" method="post" runat="server"> <asp:textbox id="TxtEmail" tabIndex="1" runat="server" Width="272px" ToolTip="Enter your emailaddress for authentication"></asp:textbox> <asp:textbox id="TxtPassword" tabIndex="2" runat="server" Width="272px" ToolTip="Enter your domain password"...more >>

It's my first time i want to write a cotum validator but it doesn't seem to work. In de page i've put this validator: <asp:CustomValidator id="CVFBeginDate" OnServerValidate="CVFBeginDate_ServerValidate" runat="server" ErrorMessage="Please fill in a valid date as startdate" ControlToValidate="T...more >>

I am trying to create a data entry form for an Access 2003 database - a very simple flat file DB. (1 Table) The Wizard creates the form fine, but when I try to enter data I keep getting a message "column xxxx does not allow nulls" (where xxxx is the field name). This does not matter what data ...more >>

i have a script that insert a variable amount of rows in a table. each row is identified by an autonumber by SQL how can i find out the number of the newly added rows without having to much troubles? ...more >>

I get An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: Format of the initialization string does not conform to specification starting at index 175. from this line: cn.ConnectionString = bs listing (more or less out of page ...more >>

I am trying to write a VB.NET front end to an Access databse that contains OLE Objects in one field. These objects can be xls, doc, pdf etc. I know it is not the best practice to save whole Objects in the DB but it cannot be helped - this is the way the client wants it. When I use the Data Fo...more >>

Hi, I have a MySQL database on a remote server that I need to address vi VB. Anyone done that, and what does the connection string look like? TIA, Larry Woods ...more >>

Hello - I have seen several items in the newsgroups that deal with the DBNull check for fields returned, especially Boolean ones. But none of them showed how to do it in VB.Net -- they were all C#. All I am trying to do is trap the Null and default to an unchecked state for the Boolean f...more >>

Hi Please can anyone help me, am trying to develop a unit conversion system, were by the program will be capable of converting metric linear and fluid measurements into their imperial equivalents. do anyone know the code i should use for this program or how i can develop it. Thanks ...more >>

Hi I was told be my company to develop a programm and also system development life cycle. Pls does anyone have an idea what system development is. Thanks ...more >>

I get an error stating this call is to a function not a stored procedure? How do I call a stored function in SQL Server from vb.net Thanks.... asp.Net Code..... (VB) sqlCmd = New SqlClient.SqlCommand("R_SiphonDetailForDays", sCon) sqlCmd.CommandType = CommandType.StoredProcedure sqlCmd...more >>

Hi I am looking for a good example of how to take a dataset from one MS Access table or tables, combine the information with some user input in a datagrid, or textboxes and insert it into another MS Access Table. Any help would be great Thank you David ...more >>

Hello: I need a data source for my windows application being developed in .Net 1.2. This is an application that assumes a non-networked (unplugged from Internet or LAN) environment. I want to assume the user does not own or operate any other database programs. The database will hold about ...more >>

Below is some code I have copied from the web with the intention of modifying but I keep getting the stated errors. This is the umpteenth attempt at trying to get OleDbConnection,OleDbDataAdapter to work without any success. Do the references have a hierarchy like in vb6 or is there somethin...more >>

Hi I am about to start to build a small windows application that will periodically retrieve selected data from a Database (DB2) and update an Access DB. My question is what is the best way to structure this VB Dot Net project. Should I build all the logic into a single application layer or ...more >>

I am developing a Windows Forms application in VB.NET that will use .NET remoting to access the data tier classes. A very simple way I have come up with is by creating typed (.xsd) datasets. For example dsParts.xsd and including that in the data tier. I then will create a class that looks ...more >>

Below is some code I have copied from the web with the intention of modifying but I keep getting the stated errors. This is the umpteenth attempt at trying to get OleDbConnection,OleDbDataAdapter to work without any success. Do the references have a hierarchy like in vb6 or is there somethin...more >>

In my solution I have two projects. One project contains windows forms and other user interface stuff. The other project contains data classes and typed data sets (.xsd). I've referenced prjFrontEnd with prjData. I am dragging a dataset object onto the form into design mode. I can selec...more >>

hey, I've been looking for a DateTimePicker for ASP but it does not exist, only in windows.forms. Now i wonder if anyone knows a script or has written a script that he's willing to share to get a DateTimePicker (like the one in windows.forms) in an ASP web form. Thxs in advance. Tom ...more >>

Hi there, First, is it availiable in VB.Net? Second, if it is, how can I dim a jagged array, let's say, of 10 elements with each element is a (8, 12) 2-D array. How do I index the elements? Thanks in advance for your help. Hugh...more >>

Hi, i have a problem about run sql.. It show error An unhandled exception of type 'System.ArgumentException' occurred in microsoft.visualbasic.dll Additional information: 'Prompt' cannot exchange to 'String'¡C I know is the variable "temp" problem. but no idea how to solve it. Cozs, I try to ...more >>

Hi, I made a dataset and datatable and append some record already. My question is how to find specific record in this datatable. for example: Tablename : "PO" Fields - Code, Description, name ...etc record: 01010125, ABC, ABC 04010050, EFG, EFG 19010008, XYZ, XYZ ...more >>

as title thanks ...more >>

Hi all I want to change datagrid's row color depending on a cell value How can I do this? I think that I must write some code in bind method but I dont know How I do this. please help me!! thanks... -------------------------------- From: Mathi Vairavan ----------------------- Posted by a us...more >>

Hi, there is no explanation I found in MSDN for choosing sqlprovider instead of oledb privider. Could someone explain in which sqlprovider is optimized? If i change of version for Sql Server ( SQL 2000 -> SQL 2005 ) I' ll have to change my sqlclient. Whereas choosing Oledb provider would a...more >>

I m trying to insert a record ina database access and I m getting the folowing exception: Syntax error in INSERT INTO statement however there's no error in the sql statement. i copied it and pasted it in a query in the access database then i ran the query and that resulted in inserting th...more >>

When updating an access table using the ADD COLUMN sql statement, my routine may encounter an OleDbException stating that the field already exists. How can I test for this error to allow the continuation while still catching other OleDbExceptions? The only way I can think of is to test for a...more >>

I have an application that has a function that executes a number of UPDATE queries using the following function: Public Function ExecuteSQLStatement(ByVal MyConnCatalog As String, ByVal MyConnDataSource As String, ByVal SQL2ExeCute As String) As String Dim conn As New Syste...more >>

I have an application that, upon exiting, has to update upwards of 300+ records in a SQL Server database. The update statements are very basic ones, following textbook update guidelines. I am programming in Visual Basic .Net 2003 There are issues with timeouts due to network traffic an...more >>

Hi all, I have a question about combobox. After I made a dataset and setting the combobox. I try to run the form, the combobox didn't so anything. The following is my code. ' connection already made Dim sql1 As String = "select code,name,description from vendor" Dim vds As DataSet ...more >>

I have an app for tracking company vehicle mileage. I can add a vehicle to the database but I need to figure out how to delete a vehicle from that database and then delete any records that correspond to that vehicle as well. The records could be as many as 100. I have tried to figure it out...more >>

Hi all, I have a question regarding the SqlCommand and ExecuteReader. Here's the deal - I'm using a basic While loop and reading my results into an Object array for a table that contains about 25 million records. As each record is read in, it's processed, split up and normalized, and then...more >>

Dear all, I am a vb.NET beginner. My case is that I created a form, inside have a datagrid. I used SqlDataAdapter to connect the SQL server and get the vendor table. That's mean I have SqlDataAdapter1, Sqlconnection1 and DataSet11 now. In DataFrid properties; I already set DataMember...more >>

Hello All, I am trying to update a database using dataset but seems that I am missing out something. After going through a lot of posts and checking my code, I am still at my wits end to figure out how to do a simple update. Here is the code. Any help would be greatly appreciated. Regard...more >>

When running the sp_helpdb 'master' command in SQL Server 2000, two result sets are returned. I can access the first result set via a SqlDataReader. How can I access the second result set? Thanks ...more >>

Is there any connected method (not using datasets, and lacking the need for OleDbCommandBuilder to write back to the database) in ado.net ? I admit here to being an old (20 years in the field) programmer who cut his teeth on dbase and who now makes a living with MS Access and VB6 - I'm look...more >>

Hi everybody, i am porting an application from VB 6 to VB.NET. This application uses an Access database in various ways. It's a database that holds numerical data that is updated at least every minute and therefor a lot of (large) records. The VB 6 app uses DAO as interface to the db. At fi...more >>

Dear Sir, Which VB6 functions can I use to detect some program is not responding to make it automatically restarted. So, how to detect that this is NOT RESPONDING program, and How To Restart it. Thank U V.Much ...more >>

Customer has data sitting on a legacy As400. How do we get to use it (read and write) they have internal staff that knows the database structure and they can give us access. What do we have to be watchfull for? Thanks for any help Bob ...more >>

I need to capture the number of records returned by a query in an inline VB.NET application. I had hoped this would work: Dim sql as string sql = "select count(*) from tblMyTable " Dim cmd As New SqlCommand(sql, con) NumAffected = cmd.ExecuteNonQuery() But, of course, it doesn't (it ...more >>

does anyone has axperience with accessing AD information through VB.Net. Is the best protocol LDAP? does anyone has a site for information about AD and VB.Net cause it's the first time i have to work with active directory in vb.net so all sources of information would be helpfull. Thanks ...more >>

I am using VB.Net 2003 to create an Access database, using the following code (partial): ==================== Dim cat As New ADOX.Catalog Dim tbl As ADOX.Table Dim con As ADODB.Connection Dim sCreateString As String sCreateString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Dat...more >>

Hi All, We're using the 1.1. Framework against SQL Server 2000, and are having a strange issue where we don't get errors back from the stored procedure, i.e. the exception never gets thrown. The scenario is this: 1.) Set up SqlConnection and SqlCommand 2.) Set SqlDataReader equal to the re...more >>

How do I compare 2 datasets to see if they are the same. I'm first saving the initial state of the dataset like this: ds1 = Session("ds") ds = Session("ds") 'making a change to initial dataset ds.tables(0).Rows(0).Items(1) = txt1.text Now txt1 might not have changed. How do I ...more >>

Hello! I developed a web application to display results from the database. Now I need to add search function, to search, sort and filter data. My question is, which way is better... 1) Store all related data in a single DataSet and use DataView to filter and sort data OR 2) Join rel...more >>