133 Posted Topics
 | Group, I've been working for several hours trying to correctly write to a database file. Here are the parameters: Database Name: DATADESIGNSOLUTIONS Table Name: PRINTERMAINT Column Names: PrinterID (primary Key), PrinterName, PrinterNumber, PrinterLocation, PrinterAddress I've been working at this two ways: through the Visual Basic code and through SQL Server … |
| | Hi group, Within one form, I need to run a routine twice. Obviously, I can write the code twice in the two places it needs to run. Isn't there a way to write the routine one time and the call it in two places within the form? Would this be …  |
| | Group, In reviewing the data in one of my SQL Server tables, I noticed that my nchar or nvarchar fields have additional spaces added to the end of the record. Is there a way to stop this? Should I be using a different data type? In advance, thanks for your …  |
| | Group, I need to use Function keys within a form I've created. The problem I'm having is determing the correct routine to fire it off. Here's what I'm attempting to do: In Form1 (actually called "OrderEntry2"), I want to give the user the option of keying in a part number … |
| | Group, I'm thinking I may want to use the Date data type in SQL Server. However I'm still very unclear how to read, write and compare using this kind of data type. I realize this has a time component which is of no importance right now (it will be later … |
| | Group, I'm having an issue with SQL Server that has me baffled. I need help. When I originally loaded SQL Server 2008 Express and created my database, I called it "DataDesignSolutions". The tables were created through VB Studio 2010 Express. It's path was "C:\User\Don\Documents\DataDesignSolutions.mdf". I'm not sure how, but somewhere … |
| | Group, After asking what seems to be a thousand questions, clearly there is so much more to learn about Visual Basic. So this prompts my "Today's Question": Are there some good online courses or classes at a local college that I can take? By the way..... I live in the … |
| | While creating a module within my program, I created a second Dataset (and it's called DesignDataSet2). I would like to delete it from the database altogether. I have already removed the one datatable that was within this dataset. I now want to eliminate this completely. How do I go about …  |
| | Group, I've got several textboxes within a form that are set to link to a data column that are set to accept a "null" (blank) value. However, these columns are formated to receive numeric data. When the user bypasses entering anything within those textboxes (as they should do), what is …  |
| | Group, I see there are multiple "validation" type events to choose from in the "Declarations" drop-down box. I want to understand these choices better to see if one would work for what I want to do. I've got several textboxes that need to have either a number entered into them … |
| | Group, I'm stuggling to get values from an sql database table into several textboxes. I'm not getting an error, but I'm also not getting anything to show up in these textboxes. Can you offer some thoughts as to what I need to do to fix this? Private Sub btnUpdateOrder_Click(ByVal sender … |
| | Group, I've got part of my code started to populate the DataGridView with the data I need to return. When testing it, I have this long pause and no returned data. I finally have to kill it via <Control><Alt><Delete>. I've tried reading through mulitple websites to find some information to … |
| | Group, I've read through the tutorial regarding Listviews and SQL's (http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). Thanks for the article. It was very imformative. So I thought I might try this with the project I'm doing. I really like how these listview look and what they can do. But I realize I need to know … |
| | Group, I'm trying to change the "sa" password to my SQL Server Database via the 2008 SQL Server Manager Express. I have followed every instruction dillegently and can't seem to "complete" the change. Each time when trying to login with the SQL Server Authentication, I get the error message that … |
| | Hello Group, I'm beginning to understand the connections required to return information from your database. I'm now trying to return multiple lines from the database that have the same "prefix" within the part number. As my example, I have two records within my database that both start with "AO0025". I … |
| | I'm trying to read and return info from an SQL database. To ensure you have the details, here's the basic info: The database is called "DataDesignSolution" The table is called "INVENTORY" I'm trying to read the columns "INV-PART-NUMBER" and "INV-DESCRIPTION". I've written the following code hoping to SEARCH through the … |
| | Group, I'm discovering that the SQL Server tables don't like identical (in this case) Part Numbers, even though one of the columns will have different information in it (in this instance, it is the "Location"). FYI.... I'm using SQL Server 2008 Express for my testing. With this said, I'm trying … |
| | As state previously, I'm a newbie at coding in VB and have much to learn. I'll appreciate your input and knowledge! I'm creating a Order Entry form. I have the database in place with some "test" items in the in the table. I now want to begin creating a new … |
| | I'm trying to use the Import/Export Wizard to import data from an Excel File to the SQL Database. First, know that I'm trying to run it as an "Administrator". I've had issues because it wouldn't let me log in. So I'm trying it this way. I'm following the steps as … |
| | Group, In the classes on VB I took were some training on creating Parent and Child Forms. What never was clearly explained is why we would need to use such related forms. I ask this as I'm now working on a group of forms that will be the "order entry" … |
| | Here we go again. I've installed SQL Server 2008. I can't seem to find my database I've created (and there are two tables so far) that were created through Visual Studio 2010 Express (I'm coding in VB). If it helps, I've determined that the database is a ".Net Framework Data … |
| | Hi group, After reviewing notes, I think I understand how to write the code to save data in the SQL Server. With that said, I want to understand the best way to arrange the data and upload it. My project is creating an order. I'll have the usual part number, … |
| | Group, I may have messed up bad. I need help. I was having trouble loading a database I had created with data. So I downloaded SQL Server 2008 Express that included the management tools. I tried to find and open the created database and never could find it using the … |
| | Group, Via Visual Studio 2010, I've created a SQL Server database with the appropriate fields, data types, etc. I'm now ready to begin some testing, however I need to put some information in those datafields. I'm having trouble doing this. I DID NOT set the tables to display in the … |
| | Group, I have a form that opens with a panel and multiple textboxes displayed that I created via the GUI. Once the user enters the desired information within this panel, a button is click and a new panel appears with the same textboxes displayed as the original. This panel and … |
| | Group, I have 36 string names that I'd like to create. In general these string names can be very similar. I thought I'd try creating a loop to do this for me. But I can seem to find the correct syntax to do this. To clarify, these string names can …  |
| | Hi Group! I need to write the data from multiple TextBoxes (which I've moved to individual string names) into one text file (miscflds.txt). These individual strings will need to be written one on top of the other. To be clear, it will need to look like this: Item A Item … |
| | Group, The SQL Server (I'm using the edition that comes with Visual Studio 2010 Express) is different in every aspect form the database(s) that existed in the UNIX based program I work with over the last 15 years. There is much to learn and understand. With that said, I've connected … |
| | Group, I have about 36 TextBoxes within one form in which I would like save the users entry. There will no need for this data to be save within a database as it will be used only one time. If it needs to be changed, I only want to overwrite … |
| | Hello Group! I've created a fairly large database with approximately 170 columns. I now want to begin writing data to that database table and saving the data. I'm using a form I'm calling "frmInventoryMasterSetup". I've also created the individual textboxes that I want to link to the columns for saving. … |
| | I'm trying to create a form with multiple labels, textboxes and buttons within a panel. The user will fill in their data and click a button that will create a new identical panel with the same labels, textboxes and buttons. I read through the following thread in an effort to … |
| | Hello Group! I am writing my first complex VB2010 program that is a order entry and inventory management program. I know there are lots of these out there. However I'm attempting to write this for a specific type of business which creates its own set of challenges. However my question … |
| | Hello again, Group! I'm creating a panel with multiple TextBoxes, labels, buttons, etc., within it. One of these buttons will end the entry of info and is intended to recreate the panel at a location further down the form. To this, I believe I need a loop. But this loop … |
The End.