For some reason, the if statement below is not working ''# count if records with this user already exist in the database below objSQLCommand = New SqlCommand("select count(id) as record_count from table1 where user
[Code]...
Why is my bulk copy duplicating each row, so in my database table the row shows twice.
Label1.Visible = True
Dim tourid As New List(Of String)
tourid.Add(TextBox1.Text)
[Code]......
I did the following
Imports System.Data
Imports System.data.OleDb
Public Class Form1
Dim con As OleDb[code].....
By this i can fetch only one row(the last row) of the access....how to modify the above code to fetch all the rows starting from the begining from the database..........
I have a form that i want to be saved to my database. The form is adding a new record to my sql server 2005 database but it is not bringing the text over with it. The new record in my db is just an empty row. Here is my code.Add to database section ( i have removed the connectionstring for privacy reasons)
<%@ Page aspcompat="true" Debug="true" %>
<html>
<head>
<title>Form to database</title>
[code]....
frmAddUser is a simple form that is opened as a dialog by a command button on the primary form (frmPrimary). Once opened, it's only job is to collect information via textbox and combobox fields. Once submitted, the information is added to the database.
This works, or so I thought. If I open this form, fill it out, and submit the information; the record is created. However, if I turn around and do it all again with different information, another record is created but with the previous information (not the new). It will continue to make records as long as I keep submitted this form but no matter what information I put in, it always uses the original information that was used to create the first record.[code]...
This works like a charm... loading DropDownList2 with all the items from DropDownList1 without looping:
DropDownList2.DataSource = DropDownList1.Items;
DropDownList2.DataBind();
But, the data from the item text of DropDownList1 is copied into both the text and value fields of DropDownList2. Is there anyway to get both the text and the value fields to populate properly?
The "Details" fields keeps repeating itself for example its showing it 4 times instead of one!this is my code[code...]
View 7 RepliesI want to start a new development thread so I can maintain two versions of a solution. I set up a new directory next to the old and copied the contents of the existing directories into the new. That's all well and good but now I can't update references in the new project to the new directories. I remove a .DLL and when I add it again, it keeps including the .DLL from the old path.
I'm running VS2005 and the solution is made up of 5 or 6 different projects (if that makes a difference.)
I have a WPF application which has a listbox bound to an ObservableCollection which retrieves it's data from a Database. I am attempting to have the ListBox data refreshed every minute through the use of a DispatcherTimer.
Dim dispatcherTimer As DispatcherTimer = New System.Windows.Threading.DispatcherTimer
AddHandler dispatcherTimer.Tick, AddressOf getRoomMeetingDetails
dispatcherTimer.Interval = New TimeSpan(0, 2, 0)
dispatcherTimer.Start()
[Code]...
My code looks like this:
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="btnAddIsotope" EventName="Click" />
[code].....
so I have a template in Crystal reports using vb.net, I changed my data source location and that source still contains the needed tables for my report, the problem is this... My original template displays the exact report but when I changed its data source it duplicates the data in the details section(e.g I made a query that will show 1 item only,but instead I get 4).
Here is a screenshot of my problem: [URL]
I want to alter the template rather than to make another one
how to make a form quicker to fill out for my work, and it involves having a employee enter a patient's name in one text box, and then having that information duplicated in all other name text boxes.
function FillName(f) {
{
f.FillNameBox1.value = f.wholename.value;
f.FillNameBox2.value = f.wholename.value;
}
}
I have a windows form that is set up like one big calendar for the month of may.when you click on May 1st...another form (form2) opens up with some combo boxes and a datagridView on it. What I need to do is on Form 1 (my calendar form)when you click on May 2nd...I want to open a duplicate form 2..the one with all the combo boxes on it.do I have to make 30 duplicate forms ( for 31 days of May)or is there an easier way to make sure that when the user clicks on May2...they dont get a form filled with May1 stuff.I can see that there is going to be a problem as it sits now because I am going to be adding to form 2 some kind of date box, or a date field in my gridview..So I need each form to display the right date?
View 8 RepliesI have a issue with two breaks < Br /> appearing in IE,If I have a normal break placed like so.[code]Then looking at the source code for IE, it produces two Once which has a ID of brAddAnotherQuote and one which is simple "< br />" directly under it.This doesn't happen in Firefox
View 1 RepliesI'm designing an app that resets permissions on folders so I've made a treeview that uses GetDirectories to populate itself with all folders on a user's computer. The TreeView has the "checkboxes" property set to true so the idea is that users select all of the folders from this treeview that they want to reset permissions on and then click go.
So once they click go I need to loop through all nodes in the treeview and all subnodes etc and test to see if they are checked, then if they are I want to add each node to a list and then in the next routine I would loop through the list and reset the permissions.This is what I am doing at the moment but I keep finding that the objects added to my list are duplicated.For example if I select C:Test and C:TestTest2 in my treeview then I end up with my List looking like this:
[Code]...
I am new to vb-net and am self-teaching and developing an application to combine a number of tasks which use different apps at the moment. I have a routine to ftp upload files but I am duplicating effort by uploading even if the file exists. Is there a simple "file exists()" type solution similar to:
If System.IO.File.Exists(strPic) = True Then so that file is only uploaded if it does not already exist?
I don't want to actually MAKE the pong easter egg, but for anyone with Dreamweaver, try typing 'dreamweaver' into the color selection box to play a round of pong.The bit that I want to know how it works is the bit at the end once you lose.After your loss, it will immediately play a small tune, whether or not your volume is on. In fact, it plays whether or not you have speakers, which makes me think the sound card itself is playing the tune.How can you achieve a similar effect, playing notes without sound or speakers, in vb.net? I would imagine this requires P/Invoke, seeing as there is no obvious way inside the framework.I don't need a whole song, a simple beep or the ability to change frequency of the beep will suffice.
View 1 RepliesI'm gathering a list of files within a directory and then adding them to a ListView:
VB.NET
For Each f In Directory.GetFiles()
Dim lvi As New ListViewItem
lvi.Text = f.Name
[code]....
The exclusion list works great, but it duplicates each item in the ListView several times. How many depends on how many items that it excludes.
I understand why it's happening, but I can't figure out a way around it. I have to loop through the items in the ArrayList so that I can compare them to the other items.
how to add multiple rows in a datagrid from data base
View 6 RepliesUsing this code i cannot insert data in the database . it gives no error but no row is created in the data base
Imports System.Data.SqlClient Publi ClassForm1 SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=
[code].....
I have a list view which is populated with an MSACCESS database using ADO. I know how to import data from the database, and I know how to create new rows in the database. However, is it possible to save the contents of the listview to the databaes? Here's my code so far:
Adding A Row:
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow
dsNewRow = ds.Tables("Accounts").NewRow()
dsNewRow.Item("UserID") = txtUserReg.Text
[code]....
Load from database to datagridview
Call ConnectAccess()
Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT ProductName,Quantity,UnitPrice,Extention, InvNomer,ProductId, InvDetId " _
+ " FROM InvoiceDetail where InvNomer ='" & pbInvNomer & "' ", mConn)
[Code]...
I'm saving data to a database, data from a listbox and checkboxes.In the listbox, on the form, there are 20 records and then there are 20 corresponding checkboxes.I need to save all 20 records to the database so really I need 20 new rows. What I have managed to get working so far is that it will save the last record only.Here is the code that works:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
'setup the relationship
objDataSet.Relations.Clear()
[code]...
but that's not right.How can I get to save 20 new rows to the database table?
I have a student database in ms-access format with 3 tables
1) class ( classid, classname)
2) subjects ( subjectid, classid, subjectname)
3) students (studentid, classid, studentname)
now i want to create a form to enter exam marks for the students in the following manner:
studentid, studentname, classname, subjectname1, subjectname2, subjectname3, .... subjectname-n
1, student1, class1, marks, marks, marks, marks, marks
2, student2, class2, marks, marks, marks, marks, marks
3, student3, class3, marks, marks, marks, marks, marks
how i can i convert subjectname from row to column and how to write a new table to store exam marks for this purpose.
I am using a tableadapter to connect my project to an MS database. I need a a function which counts the number of rows in the table for something which I am doing. I have sucessfully used the count function to count the number of rows for my other tables, but when I tried to reuse it for another table, it wouldn't work. I get an error...
An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dllAdditional information: Input string was not in a correct format.Couldn't store <AH25> in ProductCode Column. Expected type is Int32.
and this is the code which I used
Dim record As Integer = TAProduct.GetData.Rows
Do Until record = TAProduct.GetData().Count
' other codes
loop
It only seems to work if the first column is an integer datatype, which is the case for my other tables, but the table which I am currently dealing with using a string datatype. Is there another way to count the number of rows without using SQL statements or can I adapt my existing code in some way?
I'm fairly new to VB.net and WPF (and programming in general), so please bear with me. I'm attempting to write a useful database app for my business as a learning project. I did a draft in WinForms, referring to the (very good) Murach book, but am now trying to re-write it with a WPF UI and cleaner code.
I think I understand the basics of WPF binding, but am tearing my hair out trying to find a simple way of binding to parent details - which I would have thought was a very basic scenario, but I can't find anything on it. For example, let's say I havea 'Customers' table with CustomerID, Name, various contact details and then foreign keys CityID and GroupID;
[Code]...
And then just moving to the first record (as there will only be one). Is this a normal method of looking up a customer? I could also use this method by getting the foreign keys from my customer row and filling the different tables in the dataset all using parameterised queries, then just binding to each table separately - but again, seems very messy.
I'm saving sometimes 1 entry into the database and sometimes 10 or more. I want to remove the rows from the DGV as their added to the database. There's no reason to keep them there. [code]...
View 5 RepliesI have a form with a listbox bound to a tableadapter. Users can select from a combox, that has a list of users in it, then click "Add" to add it to the listbox and remove to remove it. This part works fine. The problem comes when updating the database:
[Code]...
I am currently having trouble detecting the number of rows in the table in sql database. I have one column as auto increment, and one column that will show the blkname. But everytime I delete off one row, the program cannot run saying that there is no row at position "up to the latest number". Then, when I try to insert back the row again, the program also gives me the same error. I think the program probably cannot detect the number of rows correctly as it cannot like detect if there is 5 rows in the database and if you delete one row, it will give me the error. The above method is the same if I used the auto increament column and without.
The code that I have wrote so far is :
'AUTOINCREMENT
Dim n As Integer
Dim inc As Integer
Dim numbers() As Integer
Dim StartFrom As Integer
Dim EndAt As Integer
Dim MaxRows As Integer
MaxRows = ds2.Tables("CustDetail").Rows.Count
[Code] .....
I am new to VB.NET I have inserted multiple rows into dataset (ds). Now I want to save the dataset and the new rows into the database.
View 8 Replies