Search results for query: *

I'm looking for good code examples on updating and/or inserting new records into a SQL database. I've written an App for writing to an Acess Database but now am trying the same with SQL and am getting nowhere. I'm working with a Dataset, which I can insert new rows into fine and the changes...

I'm connecting to a SQL Database and would like to know how to call a stored procedure from my program. Or would it be easier to create the procedure in VB? My SP are simply, Update_Report, Insert_Report and where created in SQL's Enterprise Manager. Thanks

I hope I'm in the right place! I have installed SQL Desktop engine to develop with VB.Net. With the engine, there was no Enterprise Manager, so how does one create new databases or tables within exsisting databases? As far as I can tell, the only thing it lets me do is point to whats there...

Can the Standard version of Visual Studio 2003 be upgraded to the professional version? My goal is the ability to work with SQL and the Standard version is limited to connectin to the desktop engine.

I have the following code for filling a DataGrid. Dim myString As String = "SELECT * FROM Report WHERE ShiftID = 'Yellow'" Dim myDA As OleDbDataAdapter Dim myDS As New DataSet myDA = New OleDbDataAdapter(myString, OleDbConnection1) myDA.Fill(myDS)...

I'm a bit new at all this so please bare with me. I have a webservice and from that have 3 web forms. The webservice holds all the functions for calling and updating my tables. I would like to print one of the filled datagrids. On the .asmx design page is the only place I see to drag a...

I have the following query: Shift consist of Blue, Green, Red and Yellow Equipment consist of 7301, 7302 and 7303 SELECT Downtime, Shift, Equipment FROM Report WHERE (Shift = ?) OR (Equipment = ?) Lets say I ask for Yellow and don't put in anything for...

I am displaying the contents of a DataGrid into a label. Below is what I have so far and it works if the number of rows don't go over 4. Do Until count > 4 shiftString = CType(DsReport1.Tables("Report").Rows(count).Item("Shift"), String) equipmentString =...

I'm searching a Access DB through a windows form. It's pretty simple but it's not returning anything if I don't fill in both fields. Here's my code. OleDbDataAdapter1.SelectCommand.Parameters("Shift").Value = shiftTextBox.Text...

I'm trying fill a List box from a DataSet. It's for a WebClient. Below is the code I have. I can get it to come up with System.DataRow.DataRow.View in all the selections. If I go to the listbox DataBindings property and select the binding. I come up with my tables contents but each letter of...

Is there a proper way to close out a web page? I'm calling a WebClient app from our Company Intranet. Thanks

I'm requiring a user to enter data into various text boxes on a form. All is within a Try/Catch which simply shows a message box if they try to submit the data without filling out all of the fields. Right now, all the text boxes clear and the focus reset to the first box when the catch...

I'm writting to a Database. I have a form that I would like to use just one Rich Text Box that will fill 8 different Columns in a database. I've put 8 Radio Buttons in a group box. I'd like the user to select a button, fill in the text box, then select another button to fill in the text box...

For some reason my Table in my Access Databse is not updating although the dataset updates just fine. Am I missing something simple here? My first form updates another table within the database fine, but the second is not. I'm not getting any error message either.

This is really confusing me. I have a project with 2 forms. Form1 and Form2. I'm calling the second form from the first one by: Dim myForm2 As New Form2 myForm2.Show() That code is in a button click, the second form comes up fine from there. The problem is when I try to update a table...

I've created an Form that connects, reads and writes to a database. I would like to add an additional form for the user to enter additional information if needed. I'm unsure of where to start. My thought would be to create a new class and go from there. I'm not sure what to Inherit, I do not...

I have a program I've done in a Windows Form. What's the easiest way to convert it to a Web form/ASP.Net? It it possible with out re coding everything? Thanks

I have several comboBox's on a form. They are all loaded from an Access Database. One table with several columns. Each box loads one column. They all load fine but when I selected an item from one, they all change to that row of the table. If I pick the 4th one down, they all show the 4th...