I want to make fill my database with 2 fields.1) a specific word2) the definitiontherefore I am using a blank database program in Microsoft Office Access 2007...the blank database has 3 fieldsIdfield onefield twofield one will insert the wordfield two will insert the defintionmy question is this:does the database grow dynamically with the insert or do I have to specify how much memory?
View 2 Replies
I want to automatically fill TextBox1 with three words from .txt file separated by sign
View 13 RepliesI've got a form here with a listbox full of words. I'd like to allow the user to insert new words and have it update the database it's getting the data from. Can I have it display a msgbox, the one that takes input from a user, and use that to update the database?
View 13 RepliesI am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesI'm attempting to setup a search function from a string a user types. (ex: "John Doe" or "Doe, John") I was thinking I would use Replace(SearchString, ",", "") to get rid of the commas the user might enter, and then use Split(SearchString, " ") to get all the words into an array. Once they're in the array I would execute a Stored Procedure on each of the terms and build a DataTable with the results.
Below is what I'm wanting to use for executing my stored procedure.
oCommand = DataAccess.GetSQLCommand("MyStoredProcedure", CommandType.StoredProcedure, SourceServer.ConnectionLocal)
oCommand.Parameters.AddWithValue("@MySearchString", SearchString)
[Code]....
Now I'm thinking the "SearchString" I will assign while looping through my array of words... but this doesn't seem like the right way to do this. Maybe it is but I don't know how to append my next result to the previous DataTable either.
I've got 2 RTB one is for input of text and one is output.The output one needs to read the words from the input and display it alphabetically and with their line numbers.I have partly done it and it currently reads it but here is my problem When the words are outputted let say for example there are 2 words the same on the same line e.g the word 'you' appears twice on line one,at the moment its coming up like this
[Code]...
I am trying to create a web-method to check whether a string contains a word which is in a list of 'not allowed' words. This list will be updated from time to time.
<System.Web.Services.WebMethod()> _
Public Function checkword(ByVal Id As String) As String
Dim returnValue As String = String.Empty
[Code]...
Something is wrong with this function. It verifies the first word of string. After that it doesn't return anything.
searching a database using multiple words from a textbox showing in gridview.
<asp:TextBox ID="TextBox1" runat="server" Width="382px" AutoPostBack="True"></asp:TextBox>
<asp:Button ID="Button1" runat="server" style="height: 26px" Text="Button" />
[Code]....
It works fine, i click button and the gridview shows all the right records. The problem is when i use more then 1 word in textbox. it shows nothing. The record in the database field may have several words, so i need to search using all words in textbox.
I'm not positive I'm going about this the right way. I've got a suite of applications that have varying types of output (custom defined types).For example, I might have a type called Widget:
Class Widget
Public name as String
End Class
Throughout the course of operation, when a user experiences a certain condition, the application will take that output instance of widget that user received, serialize it, and log it to the database noting the name of the type.
Now, I have other applications that do something similar, but instead of dealing with Widget, it could be some totally random other type with different attributes, but again I serialize the instance, log it to the db, and note the name of the type. I have maybe a half dozen different types and don't anticipate too many additional ones in the future.
After all this is said and done, I have an admin interface that looks through these logs, and has the ability for the user to view the contents of this data thats been logged. The Admin app has a reference to all the types involved, and with some basic switch case logic hinged upon the name of the type, will cast it into their original types, and pass it on to some handlers that have basic display logic to spit the data back out in a readable format (one display handler for each type)NOW... all this is well and good...Until one day, my model changed. The Widget class now has deprecated the name attribute and added on a bunch of other attributes. I will of course get type mismatches in the admin side when I try to reconstitute this data.
I was wondering if there was some way, at runtime, i could perhaps reflect through my code and get a snapshot of the type definition at that precise moment, serialize it, and store it along with the data so that I could somehow use this to reconstitute it in the future?
Trying to use a call recording API using sockets. We have the API documentation but the samples are all in C++.How would I declare the following in VB.NET or C#?
[code]...
Note from the documentation: message identifiers are unsigned 32-bit values (ULONG).
Does anyone know how to enumerate through the set of file attibutes that are part of Windows? How are Unions handled which have a sum of 28 in file attributes?
View 1 RepliesI am trying to match words driven from a database in a string input using VB .NET
The syntax I am using is so simple:
[Code]...
In VB 2010, you can use the implied properties like C# which turns this[code]...
What I want to do is replace the old style with the new style in a few file. Since Visual Studio's find and replace tool allows you to do regular expressions, I assume there must be an expression I can use to do this conversion.
[code] I dont really understand what the error-msg means. I've used this bit of code in many of my projects but this time I get this error: [code]
View 2 Repliesis it possible to collapse multiple definitions for organizational purposes.Here is an example, I have multiple Subs like below:
Private Sub B24B_Click ...
Private Sub B24H_Click ...
Private Sub B25M_Click ...
I want to be able to incorporate some constant definitions and enum types in multiple classes of mine.Something akin to including a header file in C++. How do I do this best in VB.NET? I'm having a hard time because the only way I can see to do it is to inherit a class with the definitions in it but there is no multiple inheritance in vb.net so I am having some issues with that.
View 6 RepliesI added a table to my program and it generated two errors and not it will not build. I have added quite a few tables and this has never happened before. The reeors are:
1. public sub new ' has multiple definitions with identical signatures
2. 'Protected Overrides Sub OnCreateMainForm()' has multiple definitions with identical signatures.
I have deleted the table that I added and tried undoing everything having to do with it but nothing works.
way that I can create a program that has the ability to check spelling that are being entered by a user or even displays a definition of a word? For example, when a user keys in a word in textbox then displays a definition into another tetbox but the main concern here is the source of the definition. Of course, it would be a very long task if i would manually encode words and their definitions in a database and retrieve them. I mean, can I just retrieve definition from a dictionary source, like maybe
View 1 RepliesI have been trying to use Subsonic 3 in a test application in order to understand how it works. However, when it builds the vb files from the database the files are full of '' has multiple definitions with identical signatures errors. I am using Visual Studio 2008 configured for VB.
View 1 Repliesi dont know what has happened to my project. it suddenly wont build and comes up with some errors regarding identical signatures. to the best of my knowledge i didnt do anything to it. i was testing some drawing stuff, but it now no longer builds on any of my back up copies either.the error list show errors at line 25 "public sub new() has multiple defs...." and line 34 "Protected overrides sub oncreatemainform() has multiple defs.
Code:
'------------------------------------------------------------------------------
' <auto-generated>
[code].....
Visual Basic gave me these errors:
Error1'Private Shared Sub AutoSaveSettings(sender As Object, e As System.EventArgs)' has multiple definitions with identical signatures.C:Documents and SettingsCatalinmy documentsvisual studio 2010ProjectsGame OS 0.2Game OS 0.2My
[code].....
I am having a problem with filling a combobox with unique values.Im not very good at vb either so I will explain what I have done so far.
1. I added a combobox to my form called Combobox1
2. I clicked the little triangle widget thing on the ComboBox1 set the dataset to MyDATASETDataSet1
3. Display Member: CurrencyCountry, Value Member: FCode, Selected Value = None
4. I fill MyDATASETDataSet1 when the form loads using:
PricesTableAdapter.ComboBoxQuery(CurrencY_DATABASEDataSet1.Prices)
ComboBoxQuery =
SELECT DISTINCT [CurrencyCountry], [FCode] FROM [Prices]
The form does not load, i get the error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.If I replace ComboQuery with Fill Query (which is the default fill command) it displays results....but not unique results, i see the same items being repeated throughout the list in the combobox.I guess my questions are:
1. when you fill a dataset do you need to select all the fields when you are creating your query?
2. if i simply wanted to perform the following lookup:
SELECT DISTINCT [CurrencyCountry], [FCode] FROM [Prices]and set the combobox Display Member: CurrencyCountry, Value Member: FCode how would I do this in the code?
3. how can i change my query to display only unique values, distinct doesnt seem to be working?
I use split button with ContextMenuStrip and i need to fill ContextMenuStrip with data in database like item name
View 2 RepliesI have Access database that I am connecting to as such:
Public dbE As DAO.DBEngine
Public db As DAO.Database
Public sql As String
[Code]....
While I can query for certain data, I want to know how to show a whole table in DataGridView. For example, I have a table called phoneNumbers and I want to show the whole thing in DataGridView3 instead of parts of it.
I'm trying to populate my textboxs with data from my database when the user name i
table
users (there is a textbox for each of these fields)
password
[code]....
fill in textbox1 and textbox2 with sendernumber and textdecoded,but when run it goes to the last record(not from beginning of record)what command should i do? here is the code is working with messagebox!
Private Sub cmdLogin_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles cmdLogin.Click
Using conn As New MySqlConnection("server=" & txtServer.Text & ";" _
[code].....
I'm getting a set of data by a datareader and assigning to a string. Now I need to fill the datatable columns with the Query fields. The datatable is connected to a grid to display the filled data.
query is : strSQL = "SELECT EmpCode,EmpID,EmpName FROM dbo.Employee"
Datatable columns are EmpCode,EmpID,EmpName.
I need to read the query and assigned to the columns of datatable and fill the table.
Me.DtShifts.Tables("NonAllocated").Clear()
Me.DtShifts.Tables("NonAllocated").Load(dr)
My problem is that i am trying to use a list box to display all the data from one column in one table of my database. and so, i dont know how to do that although someone hinted at using an array, i'm just not entirely sure how also when the list of data is displayed i aim to have a 'select' button that will take the user to the record of the selected item from the box.
View 2 RepliesI am using MS Access and i want to fill a combobox cmbFamily with data from a column called family in a dataset called availability and also a combobox called cmbModel with a column called model.
i have this:
cmbFamily.Items.Add(Availability.Columns.Contains("Family"))
cmbModel.Items.Add(Availability.Columns.Contains(cmbFamily.Text))
'and
cmbModel.Items.Add(Availability.Columns.Contains(cmbFamily.Text))
If you're not living on the edge, you're taking up too much room
For my project i want to i want to export form data to a new database so that i can send it by attaching it to email.
what i want that on click of a button
1) create .mdb file at c:est*.mdb, with the name = "textbox1.text"
2) create table, name = "demo" with column "id" and "job No"
and then i can use insert command to fill the data in the table and email it to client.
