How do I post changes in the datatable back to the DB? Const Con_string As String = "Data Source=(LOCAL);Initial Catalog=MyDB;Integrated Security=True" Const Command_String As String = "select * from Samples" Dim myDataAdapter As New SqlDataAdapter(Command_String, Conn_string) Di...

apologies for askin this kinda question..but..<br/>i just wanted to confirm whether my application in vb.net using mysql would support the incorporation of another database...once my currently active database gets exhausted??

Hi. I need to create a view, where i have some informations column about product. I have columns like that:ID(int), Name(varchar), Price(money), Tax(bit)I need to create a query where if Tax=1 then in Price column show a Price=Price+22%, when Tax=0 then Price=Price+7%. How to do that?I want to resul...

1)whenever i try to connect with my oracle database then i am getting an error message that an oracle error has occured and oracle could not give the error message. and it gives me a dialog box to enter uname,password and server name2)while connectivity with oracle i am getting an error stating tha...

Why won't the Update Command work here?DS1 has 3 rows and DS2 is empty. Both have the same schema withcol1 being the primary key. I want to copy DS1 to DS2 and save thechanges back to the original database but Update doesn't do that here. Dim connection1 As New OleDbConnection...

hi...<br/>can u please explain me as to how to handle Date data type in Access..<br/>each time it gives a different..i mean that its not clear to me whether days or months come first..<br/>thanks...

I cannot update the Data grid fields for the following example:The grid and 2 buttons are visable but I cannot mainpulate (update) the dataImports System.Data.SqlClientPublic Class WebForm1 Inherits System.Web.UI.Page#Region " Web Form Designer Generated Code " 'This call is required by t...

Input string was not in a correct format. Line 94 seems to be the culprit but I don't know whyDescription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exc...

Can you help me?<br/>I wan to excute another *.exe file from my program (I have a button, when click on it then another program running)<br/>I'm programming by C#

hi all,In table the id is int where i using following code to fill combo box following is the error i am receiving . "cast from string system.data.datarowview to type integer is not valid"following is the code i am usingDim myCommand As New SqlCommand("gettest", conn) myCommand.CommandType...

Hi,Form and PictureBox HelpI am working a project that is suppose to load a startup welcome form then close the frmwelcome(1 st form) and then open the main form ( ane once i close the second i want it to close everything). Also I am having problem with the click events for picBox i have used the .n...

If have been able to successfully create a MS Access database and a single table. The database name is secure.mdb and the table is tblauthorise. The program I am creating needs to create a new table for each month of the year eg tblJan2006, tblFeb2006...... tblDec2006.What I am having trouble with i...

I am new to .NET and to ADO. I am using "Visual C# .net". I downloaded MSDE 2000. In the "Development Envionment" when I open "Server Explorer" the "data connections" entry can not be expended. What should I do to see the SQL service?<br/>Thank you<br/>Ronor

I was hoping someone could take the following data and show me the steps to make it work. I can do it with a single table but not with multiple tablesThe web will have the following fields:db NAME "DUDE"Policy Number (Insurance Table)LastNAme (Custome Table)RenewalDate (Insurance Table)1. User...

I want to open an excel through as connection. and from another data source I want to retrieve data and put it on excel file.Is it ppossible to use the existing excel file and append the data at the end of the existiong file. I know that new files can be created but what about append?Another one,For...

In my code below, When I go to a new line, it will not let me put the ( ) at the end of Dim ds As New DataSet I can enter the parenthesis () but it removes them when I go to a new line Also the dataAdapter.Fill(ds, "progs")gives me the error"Declaration expected"Here is mycode so far:*************...

hello,<br/>when trying to retrieve data into second combobox based on first combo selectedvalue i am receiving system.componentmodel.invalidenumargumentexception error.pl.hep me how to solve this prob.<br/>Thanks in advance<br/>karuna

why use catalog rather than database= ?<br/>I have notice some connection strings use<br/>either "database=" or "catalog=" in their<br/>connection string.<br/>Are they the same or is their a reason <br/>for the difference.

Normally you pass values as parameters.<br/>But how can I pass a columnname as parameter in a stored procedure.<br/>The procedure should look like somehow.<br/>select * from A where @columname = 'Test'<br/>Regards,<br/>Maurice

Hello,Im in the situation where I have to decide on technology on my project and I need advice for this. The scenario is that we have some legacy code based on C++ and db2 which we want to move to MS SQL Server. We dont want to rewrite the whole lot in C#, but rather minimize the work by only replac...

Does any body know how to set up "create shortcut" from Primary output so after installing a program, when I right click on properties of an application's shortcut, the "Change Icon" is enabled? The "Change Icon", "Find Target" of my shortcut's properties are grey out.Thanks in advance,Uo...

Hi , i try open dbase file which filename is over 8bytes, using ado .but i cannt .the error message is 'can not find myDbase89.dbf file'.but 'myDbase8.dbf' file opens well.how do ...please, look over the code following and help me....////////////////////////////////////////////...

hi, I am working on a project and what i am trying to accomplish is i want this particular code to save the values from mutiple text boxes into a excel file. When i run the code I get a exception error mesaage that states, "Syntax error in INSERT INTO statement". P.S. Also I was wondering once i sol...

Hello, I am somewhat new to Vb programming and in need of a little help!I am writing a Class Module that wraps ADO connections. I have been successful in sending a recordset from the Class to a user form for processing but am having a problem sending the recordset back to have it update throught the...

In my asp .net web application project, I want to display a report in web form. the report is from Access database. How can I do?<br/>Thanks a lot.

we are planning to migrate from sql 2k to 2005, im just wondering if we may need to change some codes in my vb.net program...currently, the backend that we're using is sql 2k, will there be any changes that we need to do when i change or migrate to sql 2005?thanks in advance!...

Hello friends.I have a quite peculiar problem. I would like to have a combobox that showed values of a field (key primary of a table) and besides I would like to record this value in another different field of a diferent table (that it would be foreign key). I know that with ADO this fact was possib...

I have a checkbox whose checked property I'm trying to bind to a Yes/No field in MSAccess. I'm working in disconnected mode with a dataset, and it's working fine when I fill the dataset and view records with simple bound controls, including the checkbox. I can also check or uncheck th...

Hi <br/>Can Anyone please help in saving byte data from VB.NET to SQL server db. Please guide how would i design the DB. and how should i save this byte data from VB.net to SQLserver2000<br/>Kind regards<br/>Ali Ahmad

Can anyone help me in the following context.I need to create an excel worksheet and need to put data into that...I used ADO and C++.Creation of excel sheet if the file does not exists, dumping data onto it works fine for me.But the problem is The requirement is like that I need to dump data from a p...

HiWe have a MySql database (A) on a Linux machine and a MS Access database (B) on a windows machine. One of the tables in each of these two databases must be synchronised constantly. In A new records are added but no other modifications to records are done. In B records can be added, modified or del...

Hi,I've a running .NET 2.0 app that connects to DB locally (thru ODBC), using an entry in connectionStrings section in web.config.Now I want to connect to a second DB, but adding justanother entry in web.config (see below).<connectionStrings> <add name="My1stDbConn" connectionString="...

hi<br/>do i need to make a mutex to ADODB::_Recordset object?

I am trying to write a stored procedure that receives data passed from a web page and generates some data within itself. I'm not having a lot of success so far. I want to pass 5 variables into the procedure and insert them, along with one that I populate when the procedure runs, into the tabl...

I've got Visual Studio 2003 and SQL Server 2005 set up, and we're using ASP.net with C#. I've got a web form set up, but everytime I drag over a table to the form, I get the following error:The wizard detected the following problems when configuring the data adapter for "Table1".Detai...

I'm having performance issue with this ASP.NET app. From SQL Server log there're MANY MANY log which resembles the following:SQL Server log: Login succeeded for user 'APPL_ACCOUNT'. Connection: Non-Trusted.I'm talking thousands in one morning. And I am suspecting that this i...

Hello, Im new to asp.net... I dont know how to connect the backend with two text boxes in the webform... Please give me the exact coding for getting connceted in the backend with text boxes...the database should be updated in backend while we enter the information in the text box... give me codin...

i trying to create parent hyperlink and children hyperlink. I have my parent table name t_linkchapter and children t_linktitle..where link_chapterid is the primary key in table t_linkchapter and i also set link_chapterid as foreign key in t_linkchaptermy code are as below. but i found and compilatio...

hi, i would like to know how to add fields to an already created table. i am using visual c++, ado, and access database file for my database. the .mde file is already created with existing tables and existing data in those tables. i am trying to use visual c++ and ado to open one of the existing...

Hi,Let's say I got two different tables:customers: custID, custNameorders : orderID, custID, orderDatecustID is a foreign key in "orders"In my application, the user selects in a ComboBox a CustNameI want to retrieve all the orders corresponding to that customernameI use MySQL and I would l...

Here is my scenario.pls help me out of possibleI have an access database table containing 16000 rows and 24 columns and there is no primary key for the table(the main problem) although there is a index column which has unique values.I am using VS.net 2002 and language is vb.netMy actual program conc...

Dim objConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="path") objConnection.Open()rndnum = rnd(99999999)sql1 = "SELECT OrderID FROM Orders WHERE Orders.OrderID = '" & rndnum & " ' " Dim MyCommand As New OleDb.OleDbCommand(sql1, objCo...

hi, im having a problem binding data to a crystal report. but actually i think the problem is caused by ADODB from which i get the data. The problem is, when there are field names with an underscore, eg: U_IDADO doesnt bind it. I use .csv files as data source and use MS VC++ 6.0.How do i write the C...

Hi!I have some problems with my typed dataset, the dataset contains several datatables and the problem occurs when i try to load the dataset with the ReadXml function. The problem is that some of the tables won't load properly. For example:MyDataSet ds = new MyDataSet;ds.ReadXml("ds.xml");The t...

I am trying to use a single dataset to populate several dropdownlists on a page by using different queries to produce different results for each list. I had thought that I could simply specify criteria for the datatable (the only table in the dataset), but I'm been unsuccessful so far. My cod...

I created two tables that have relation one-to-many.I included them to a DataSet, created relation and assigned to DataGrid.Question:When a user click [x] for expanding table row he sees the link to child table.How do so that instead link user can see whole table immediately?Thanks...

This has to be simple but I can't find a way to do it. I have a temporary table that has unedited data in it. Then I have a vb.net form that reads these records into a dataset and allows user to navigate thru these records to edit the data. When all edits are passed the user clicks a button...

hi guys, i have big problem in datagrid updates,i am binding a datagrid from two tables. in datagrid i had one check box.if i checked the the check box i had to pass the information to the database.on click a button this has to happenMy code is given belowprivate void btnRoleSelect_Click(object send...

Hi!I have some questions about datasets in VS2005 and SQL Server 2005. I have added a dataset to my project and added all interesting tables in my DB using the 'data source configuration wizard', all works like a charm. But now to the interesting bit, i have changed the design of some of t...

hi friends,I new to .net.please help.i had a datagrid in c# asp.net.in this datagrid i had a check box.when i click on the check box,i want to get the row id of the checked row.is there any method in .net.my code is like thisthis.grdRoles.ItemCommand+=new DataGridCommandEventHandler(grdRoles_ItemCom...