I created a database in SQL server compact 3.5 I have a few fields in that.Later when I tried to delete one column and added so more, change was not saved. I did it all using server explorer of VB.Net. when I make the change, at that moment I can see the newly added columns but when I make dataset for this table
View 1 RepliesI am using VS 2005 and MsAccess 2003. I am already having some fields in the table, and i want to add more fields from the .NET application. Is it possible to add more fields from the application to the Ms-Access Database. Also it is possible to change the order of the fields from the application?
View 1 RepliesI just need to edit coloumn 2 of row 0 of SSCE 3.5 database.I am using following code.It generates no error but database is also unchanged.[code]
View 1 RepliesLets say we have an Access file in a well known path (i.e. "C:MyFolderMyFile.mdb"). That file does not have a primary key set on the table we are interested in . Is it possible to set one of the fields as a primary key (for example the "ID" field , which is also an AutoNumber data) ? And one more thing : I'd like to change the name of a field on that table . For example , lets say there is a field called "My Field 1" (note the space characters) and we want it to be renamed as "My_Field_1" . If it's possible , I'd like both these changes to be permanent in the data base file itself , not just in the imported DataSet ,
View 7 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I'm trying to add a textbox to the initial step of the CreatUserWizard.Let's say it is tbMyTextbox.Now when I add an event on created user, I want to get the value in the field.I thought I could use dim mc as textboxmc = ctype(CreateUserWizard1.Findcontrol("tbMyTextbox"),textbox)mc.text should be the text of the field.But it can't find the control... so I trieddim mystep as CreatuserWizardstepmystep = createuserwizard1.activestepmc = ctype(mystep.findcontrol("tbMyTextbox"),textbox)But it also fails.The example just uses tbMyTextbox.text which just throws a compiler error.
View 6 RepliesI am attempting to customise the CreateUserWizard by following it in my book, but when I come to reference them in code behind I get an error saying 'FieldName is not declared' for each field i'm adding, they are present in the page with the correct ID's, am I doing something wrong?
I am only trying to add a firstName and lastName field to the bottom of the CreateUserWizard and remove the need to a security question.
Markup:
<asp:CreateUserWizard ID="CreateUserWizard1" runat="server" OnCreatedUser="CreateUserWizard1_CreatedUser">
<WizardSteps>
[Code].....
i have an SQL statement which i need to code in vb:
create
table r2 (salesno
bigint, prodno1
[Code]....
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
and so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
what should i do? is there an array or something that i can use here?
If i change any table definition after using the fields on a form VS stalls and doesnt allow to load the form
View 3 RepliesI have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets.Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?
View 6 Repliesi am having a trouble about adding a file location (e.g. c:/bla/blahblah)to a database i have my code here
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\WindowsApplication2\Database1.mdb"
AxWindowsMediaPlayer1.settings.volume = 100
[code]....
everytime i add a mp3 file to listbox it should get the file location and pass to the database but it seems my database is empty?
I have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets. Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?
View 1 Replies[code].....
View 4 RepliesI am having problem in opening and viewing data in my SSCE table. There are 3 tables in it, two are working fine but one is causing trouble. I dropped the table and created a new one (same name) but again, the problem is the same.Please see the problem message below:
The select statement:
SELECT [PK], [AdmissionID], [Session], [Medium], [DateEnr], [FeeStatus], GuardianNIC], [FatherOccupation], [FatherIncome], [Cast], [Religion], [MotherName], [Address1],
[code].....
After adding a UserControl to a form which access my database I get this warning:
Warning1The database file cannot be found. Check the path to the database.
[ Data Source = C:Program Files (x86)Microsoft Visual Studio 10.0Common7IDEDatabase.sdf ]
C:UsersUserDocumentsVisual Studio 2010ProjectsProject1Project1Options.Designer.vb2160
Thing is I never had a database at that location, my database is and has always been in MyDocuments in the Project folder itself. There is nothing anywhere in my code referring to that database! When I double click it I get sent to this line in the Designers window:
Me.Controls.Add(Me.BoxControl1)
Even though I get this error I can still access my database, so basically it does absolutely nothing except drive me mad! So how do I fix this?
[code]....I have a dialog that comes up and asks for a reason for declining the business.I don't want the code to move on after not enabling the "me" until the reason has been entered and saved into the database. Also, at that point where it says "I WANT...." I want to copy the textbox fields into a new database and then delete this entry from the database, how can I do that. I am using VS 2008 and SQL.
View 2 RepliesI am working on a timekeeping application, using Visual Basic 2008 Express edition with an Access 2000 database.The application requires the user to complete a timesheet by recording in tme and out time daily. Blank fields are perfectly frquent and perfectly legitimate.Using these lines of code it works perfectlywhen there is a time value in the database.[code]This indicates to me that the code to ignore a field containing nothing is not working
View 10 RepliesHow can I count fields in database (Any alternatives welcome)
View 17 Repliesi am making a project and in that getting storing and loop problems there are two fields serial no and quantity when quantity is entered serial number must be asked then only and the number of times quantity is entered that many times serial number must be asked also serial number is from to too like 1 to 6 or 1 to 5 so i have to taken 2 textboxes serialfrm and serialto to store but now the problem is that i am not able to write proper code for it either it doesn't get saved to the particular name to which both fields belong or it keeps saving without stopping.
View 2 Repliesi have a table named item_details.i have some field named item_id,item_name,quantity,supplier_name etc.i want to see all details as per the item_id given in a textbox.i also want to see details as per the item_name is given.i can use 2 forms to view this type of query..one for item_id..and other to view from item_name.but..i want to use tabcontrol..in 1 tab i want go give the item_name...and want to get the details.and other tab i want to give the item_id...and want to get the details....and whenever i gave wrong information.an error message will be shown.
[Code]...
This will actually be for a WPF app but how do I filter the fields of a SFD database so that I can use expanders with listboxes that contains last names from the DB ? The expanders will have headers of the letters A to Z with last names for example in the A expander listbox all starting with A .Coding4fun
[URL]
In a table I have news posts with these fields:
Title
Content
OwnerID
The OwnerID relates to the ID in the users table, how can I get the name of the user who's ID matches the OwnerID? I'm writing a website in ASP.net (VB).
There are 4 fields in my database(exlcuding the primary key)...only 3 fields can be successfully updated. the "Section" field returns an error pointing to da.Update(ds, "moreforengineers")?[code]...
View 1 RepliesI have a connection string set up and a data reader.I have two textboxes on my form for users to type in. One textbox (txtLogin) is a user name and the other textbox is a password (txtPwd). I'm trying to compare what a user types into those two boxes to a table in a vfp database. The table I'm trying to compare to is open about 99% of the time so I need to be able to read from it in some type of "shared" mode.
My Select statement needs to be something similar to "select * from sites where clogin = txtLogin.text and cpassword = txtPwd.text"I just don't know how to get this to work properly.
I have a database set up with 2 fields, FirstName and LastName, and i want to display both of them in a single combo box. Right now its only displaying the first name:
[
Dim dtFishermen As DataTable = objDS.Tables("fishermen")
Me.cmbFishermen.DataSource = dtFishermen
Me.cmbFishermen.DisplayMember = "FirstName"
Me.cmbFishermen.ValueMember = "id"
Everything works fine, im just looking for it to display "FirstName LastName" instead of just "FirstName"
I have a problem trying to copy 3 fields on a form to a database. The reason I cannot seem to do it is that the last field asks how many copies you want to save in a combo box. So lets say the user selects 3 I need to be able to copy three sets of the same data to the database.
View 2 RepliesIn one of my school assignments I am trying to count fields (that are strings) in a database and then publish them to the screen, however I can't seem to figure out how to count them.I've been trying to do something like this but I am having trouble with the bold part. I think the datatypes are the issue but if not this then what? What is a better way to try and do this?
Private Sub btnCalc_Click(sender As System.Object, e As System.EventArgs) Handles btnCalc.Click
Dim numRep As Integer
Dim numDem As Integer
[code]....
How do i find out the number, names and datatype of fields in an Access table
View 16 RepliesI am trying to enter a record into an Access database via visual basic programatically.I had this working fine when I had the datagrid bound to the database but now I have decided to do it all at runtime to save on resources at runtime.When I unbound everything and tried running it with my existing code
Try
ds.Tables(
"tblProduction").Rows.Add(row)
[code]....
This is the line of code that has to have another 30 entries in it.
I have been tasked with writing a program for our yearly reviews. We want all of the information gathered in the form to be submitted to an access database. I have created the form and the database. I can send info to the database but it is put on a new line everytime it is submitted. I would like to check the first column of the table to see if the user login is already there. If it is there I would like to update the information. If it is not there I would like to create a new row. This seems simple, but I can not figure out how to see if the user login is already there.[code]...
View 4 Replies