[sql-connection] Forum Topics

Friends, I am making Consultantwise patient report application using VB.NET 2005/08, SQL Server 2005/08. this application i am making for reporting purpose only. I have taken 2 datetimepicker(from date & to date) and one listbox to select the consultant name on my .net form. but i am confused where i …

I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I …

[CODE] Create table Cameras (CameraID varchar (35), CheckOutDate varchar(10), ReturnDate varchar(10), primary key(CameraID), foreign key(CameraId) references History(CameraID)); Create table Borrowers (PsuID int not null, BorrowerName varchar(30), Email varchar(50), Telephone varchar(12), ReasonUse varchar(200), primary key(PsuID), foreign key(PsuID) references History(PsuID)); Create table History (PsuID int not null, CameraID varchar (35), BorrowedFrequency int, …

Hi friends, after a long time. i am developing a small tool by using VB.Net. I want to display data in comboboxes from a table which is in an access database. I using SQL query. Its a simple problem , I think the problem is in my COMMAND. I want …

I have a web app that when run locally runs as intended. Once published to my server it does not. The issue is related to sql's integrated security. The webservice/sql call is using "domain/machinename" as the login, instead of my active directory credentials. There is no sql security login for …

How to connect to a WAMP server database (located in default MySQL database location in WAMP) using C# 2010? I tried... SqlConnection conn = new SqlConnection("Data Source = C:\\wamp\\bin\\mysql5.1.36\\data\\testdatabase; User ID=; Password=;"); SqlDataAdapter da = new SqlDataAdapter("SELECT * from transactions", conn); DataSet ds = new DataSet(); da.Fill(ds, "Transactions"); DataGridView1.DataSource = …

Where should I keep connection object to database like ISession or SQLConnection? What's the best solution and why ? Is it Application, Session or Items ?

I am a bit (well, actually a lot) confused with how exactly I should use the Dispose() method on SqlConnection object in C#. First let me tell you what I have learned so far (I've been reading a LOT on the subject for the past 24 hours, and I'm still …