Search results for query: *

The problem with using the Wizard is I'm using VB.Net 2003 Standard Edition which does not allow you to use a SQL connection through the wizard. I had to make my connection string manually and am having to everything else manually.

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

Tried the osql. Works great! 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...

Below is how I moved to another form. Spoilage is the name of the other form. I did not have to use the NEW. If excessiveCheckBox.Checked Then reportDialogResult = MessageBox.Show("Would you like to fill out an Excessive DT/MR Report", "DT/MR Request", _...

Erics - I build the SQL statement when I configure the DataAdapter. Just by right clicking on it and going through the wizard.

The problem seems to be when I don't put in one or the other. Say I just put in Shift, it won't return anything. Is there an inputed wildcard? I understood that the % was it but I'm guessing that doesn't work when it's inputed instead of lets say 'yellow'.

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...

Works great. Thanks!

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...

That's where I get a bit confused. When to seperate the ASP / VB / SQL questions. I'm doing it all in Studio 2003 so I assumed it would be a VB.Net question. I'm starting to understand where to seperate the questions though. Thanks for the feedback. Richard

Just for the curious. I have finally figured this one out. When I hit the submit button on my form, the page was reloading, thus the listbox was reloading and sending the default index to my database, which was -1. I added If Not IsPostBack to the dataset load and it took care of the problem.

I use the server explorer and what I've found is that if I don't include the primary key as one of the items I drag over, then the Insert, Update and Delete SQL commands are not generated for you, only the Select is.

I tried using SelectedValue but now what's happening is that the value never changes from 0. During run time the list box populates and I can select an item in the list but adding a watch, the value stays at 0. Not sure what's going on.

My List box fill find but now I can't get the selected item into the dataset. This is the code I'm using. It works for the listboxes I have a "Collection" filled out for. cRow("Downtime") = downtimeList.items(downtimeList.SelectedIndex).ToString() Ideas?