[ado.net] Forum Topics

I have created an MS Access Query named **GetContactCategory** select GetCategoryNames(contactId) as CategoryNames from Contacts The Function **GetCategoryNames** is the function written in a module of same database. Now when i call this query in my c# application using ADO.net it throws error. Following is my c# code ` using …

hey all, i have a little issue here with the below however the wired thing that i encoutred is that the below code run only for one time perfectly and when i invoked it again it displayes the error : " The ConnectionString property has not been initialized. " private …

I made an online application to store employees information in MS SQL,I used Disconnected model and I made my class for "DataSet configuration" and call method in it in The "Form_Load" event. This is the class public static string constr = ConfigurationManager.ConnectionStrings["cnn1"].ConnectionString; public static DataSet GetDataSet(string stored_name, string table_name, params …

I have developed a windows application. My development environment is win7, office2007, C#, VS2010, Winforms. My application stores data in MS Access. Is there any way with which i can create a connection string based on Oledb driver version present in PC?

Hello, I had a very peculiar problem today which I am sure hundreds would have had and solved before. I have developed a VB.Net + SQL Server application and installed it in a few dozen places. All worked very well. Then I installed it in a persons computer in Middle …

Hi I have a big (working) software written in C++ that uses SQL database, using the ADO interface. I'm currently using old ADO libraries (prior to the Windows7 SP1 problem) and wish to upgrade. I'm considering taking advantage of this need and upgrade to ADO.NET. What do you think?

HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password …

I have a console application that I need to run a stored procedure in but I'm getting this error: a t S y s t e m . D a t a . S q l C l i e n t . S q l C o n n …

I have a bound datagridview and a dataset with tables. I have two sets of comboboxes bound to the same field "Restaurant" in the tables (mirroring each other). In the "NewEmployeeRestaurant" combobox I change the value and it reflects in the datagridview. I can shoot around clicking all over the …

Hi i have the following code. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection Dim da As New OleDbDataAdapter Dim ds As New DataSet Dim dsnewrow As DataRow Dim cb As New OleDbCommandBuilder(da) Dim a As String con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\DB.mdb;Jet …

Hello :) i intend to make a game in c# that will contain information of 10,000 people i dont familiar with db yet but i guess from a little reading that the best way is to use ADO.NET sql library... the game is not on the internet, it will be …

Hi daniweb first of all, sry my english. I have a problem with at update code, I was hoping that U can help me, im new to this. i have a code where i get an id from another page, from update.aspx?id=1 up to 6 ATM. my code works fine …

I have form where 4 buttons(Platinum, Diamond, Gold and Reset) are there, I have 3 Panel Control one for each of the first 3 buttons, what I want to do is that when I click on any one of the first three buttons the Panel for the respective buttons should …

I have added a panel control at the design time and I want to add some buttons in the panel at the runtime, the code for adding the buttons in working perfectly, but the problem is with the Panel control, when the Buttons are added at the run time, the …

I have a Windows Form where 225 buttons are added at the run time, also I have the database which have two columns (first column is the SeatNumber with the datatype nchar(4) and the other column is IsBooked with the datatype bit). The SeatNumber contains data like this, A1,A2,A3,A4................O13,O14,O15, The …

Hi there all, I am trying to get data from a sql view and bound it into the datagridview, after that, I add 4 more colums into the datagridview which are editable, finally pass the entered data into a new database and call that data in the future in the …

Hi there all, First of all, I need to say that I'm so happy to join you... Second, I have a problem... First I created a form page with a constructor that fills the listbox in it... As you can imagine all stuff begins after filling it... However, a friend …

Hi Experts, I have a windows service running every minute and has many database operations to perform. It runs perfectly for many days, sometimes it suddenly stops and throws this exception. Later when we start to debug it, the exceptions goes off, but if we don't debug, the exception continues …

I need a timer that will change the text of a combobox which is binded to a database. My Application which is based on hospital management wherein a doctor has to visit rooms within 6 hours. If 6 hours elapse the combo should show "need......" and if not something "......" …

Hi all. I'm new in .NET programming. I want to make an application using C# and Microsoft Access. I cannot found any good tutorial about C# and Access. I just want to know how to connect, insert, delete, edit, and update database. Any suggestion for a good site to learn …

Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column …

Dear Friends I have Developed a Successful Database Software, it include Datagrid, First, Last, Next, Previous, Add, Delete, Edit, Update, Search just Every Thing is Working Nice, But I need help from one of expert from you. my problem is that every time when i Start program its all functions …

Hello sir, I have add one listbox in my code. i'm assigning data to the list box at runtime from DataSet. The Value member of the ListBox is EmployeeID and Display member of the ListBox is EmployeeName. [B][U]User Can Select Multiple EmployeeNames at Run time [/U][/B]. Now I want to …

I am using the .Net 4.0 and excel 2003 How can i use an oledb connection to retrieve the cell format of an excel spreadsheet... I specifically want to find out if a cell column (or cell itself) is in a numeric percentage format. I cannot seem to find this …

I Want To Search Date From .mdb Database file, Table Name is Purchase, and The Field is Purchase Date, its Type is DateTime and Formate is ShortDate in MS Access Database File, I Conceted it to Vb.net Form, and Tryed to Search Date, but it Returns Error. the Code to …

My vb 2008 app uses Excel, but only briefly. Can I avoid referencing the Interop library Microsoft.Office.Interop,Excel?? Is there another way to link to Excel? In terms of its dealings with Excel, my app does little more than open a workbook and shade some cells. Many thanks

Friends I m working with RowFilter, its working good with String Data, and like statements, specially its Autometed functuallity with string data is good, just like in follwing code (it is written in Textbox "txtSearch"s TextChanged Event) [CODE] Private Sub txtSearch_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearch.TextChanged …

I have created simple database project, using vb.net, ado.net, oledb, datatable, datagridview. My program is working nice, I just need Help with how to add, delete, update and edit records. Can any one please and please help me in this case, or can provide any good tutorial or source code …

Friends I m workin on vb.net ado.net oledb, I have also added datagrid Control to my form for retriving database from .Mdb file i used following code [code] 'decleared Name Space Imports System.Data.OleDb 'Dicleared Variabls in Class Form1 Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da …

Help With Add, Delete, Edit and Update Record (with Datatable Method) I Created a Software with OleDb .mdb database previously Using Dataset Method, but I was unable to Connect Datagrid with it on real Basis, I mean when I Clicked Next Record Button it only Moves in TextBoxes (Which were …