Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: richself
  • Content: Threads
  • Order by date
  1. richself

    SQL Insert Update

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

    Call SQL Stored Procedure

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

    Desktop Engine

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

    Upgrading 2003 Standard

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

    Query

    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)...
  6. richself

    Printing through Web Service

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

    Query

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

    Determining the end of a datagrid

    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 =...
  9. richself

    Query through VB.Net

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

    Filling DropDownList from Dataset

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

    Intranet application

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

    Easy Question! Try/Catch?

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

    Multiple entries... One RichTextBox

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

    Updating Dataset but not Database

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

    Multiple Form / Data access

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

    Multiple Forms

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

    Windows Form to Web Form

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

    All comboBox's change with one.

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

Part and Inventory Search

Back
Top