I've got a database with the fields: tuneName, Artist, Sales and yearIssued I'm trying the load up just the first field (tuneName) into a list box. I've managed to load the database into VB but I dont know the code to do this specific thing.Also I want to be able to select one of the items in the list box and the rest of the fields to appear in text boxes on the form.
View 2 RepliesI have a form in whcih users will be able to select the required field that has to be printed.. can u tell me how to add field in CR at runtime ?
View 1 RepliesI am using VB 2005 pro and sql 2005 express.I have a form linked to a sql database. and linked a sql field to a textbox. All I get when the program is running is what is in the database displayed.
But what I would like to do is take a value from a textbox and add that to the chosen field database.
I am a beginner and looking for simple code.
In VS 2008, VB.Net, I am successful connecting to a local SQL Server (version 8) and seeing all tables/views/procedures in Server Explorer. The local OS is Win XP Pro SP3. I created an ODBC data source to a remote SQL server (also version 8) with a database of the same structure as the local one. The connection tests out ok. The remote computer runs Windows Server 2000 SP4. In the VS 2008 Server Explorer I add this ODBC source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears. Is it the old SQL Server version? Is it the old Server OS version? Something else alltogether?
View 2 RepliesI've placed this on a VB2008 project but it's telling me adNumeric,adVarChar & adBoolean are not declared, I'm assuming I need to "DIM" them, but what as? plus I need each field to accept NULL values, how do I do this? Also I'd like to add a field for accepting images.
Code:
Dim cat As New Catalog()
Dim col1 As New ADOX.Column
Dim col2 As New ADOX.Column
Dim col3 As New ADOX.Column
[code]....
This error has me completely baffled. There is no indication (that I ca FinD as to what field won't handle the information. Heres the situation:I am using an Accees query to insert a new record in a table with 49 fields. Of these fields, 1 is an integer, 7 are booleans and the other 41 are text fields. The text fields represent either Time of Day or a Timespan.
My field sizes are:
For time of day 8 digits(example 08:00 AM)
For a time span 5 digits(example 03:30) I will never exceed 2 digits for
hours
I have checked every field in the dtatbase and they are all as noted. I am at a loss as to how to proceed.
I have an open database (dataset) with two tables. It is binded to toolboxes, but I have one field, what I have to calculate about other parameters. I have binding navigator, and I can set field values from controls (eg. toolbox). I can step my rows, with binding navigator. I can update my database. But how can I set field value from code?
I want a code line:
database.fields("fieldname") = something - or something like this
I have a RDLC report with a list that contains a table. I require a calculated column whose value depends on values from previous rows. Outside of a report I accomplish the same thing using code in a DataGridView's DataBindingComplete method.
From within a report how do I refer to specific cell values from previous rows? embedded code, but I have not had luck (#Error).
I am using Visual studio 2008 to build a web application. What I am trying to do is retrieve data from a database and populate text boxes based on the results.
View 4 RepliesI am using VB 2008 and SQL Server 2005. I have a texbox in which I need to show the field 'domain' from the table x. I am getting the field in the format needed from a stored procedure.Below is the Vb code that I am using in which I am getting an error message: Invalid attempt to read when no data is present.at this line sDomain = sDomain & " " & v_DR!Search
[Code]...
I have a database and I wanna select a field ..I usually do this with access:
dim chosen as string
chosen = textbox1.text
Dim querysql = "select * from table where field = " & chosen & ""
But with SQL it doesnt work =S I really need to make this work .
I know this sounds simple to the majority of the database gurus out there but I am finding it difficult to find anything related.I am using Visual Studio 2008 VB.net winforms application.I have a form which contains a datagridview. what I want to do by push of a button is set the field "OnHand" either to default or 0. The 'either or' is really for you guys. Which ever one works the best in terms of reducing code or functionality is obviouls prefered.Once the 'OnHand' Fields in every record has changed then I would like to save all the data back to the database'This is more than likely very simple I just cannot find anything that discusses this kind of thing.
View 1 RepliesI'm using an access database in a program that I'm making for my school, the user is able to select an item from the menu, then it sends it to a list box, there is also a textbox to put a quantity of how much of the item you want. I have a field in my database called Amout Ordered, I want to update it with the amount of each item ordered, and I can't figure out how.
View 1 RepliesI have a crystal report that fails on a formula field but I cannot see why.
Here is my code:
Code:
Public Function CreateReportPDF(ByVal dsReport As DataSet, ByVal CrystalReportPath As String, _
ByVal reportSize As String, ByVal landScape As Boolean, _
ByVal dsParameters As DataSet, ByVal filePath As String, _
ByVal fileName As String) As Boolean
[Code]...
I've been staring at this and can't seem to come up with a solution. I've tried several different methods that i found on the web but to no avail. I'm hoping you all could take a look at the code below and give me some direction as to why I'm receiving the error "The INSERT INTO statement contains the following unknown field name: 'Deposit_Date' . Make sure you have typed the name correctly and try the operation again. Sorry if it's kinda jumbled below
Code:
Dim SQL As String = "INSERT INTO Deposits ( Deposit_Date, Deposit_Time, Location, Miscellaneous, " & _
"Miscellaneous_Adjustment, Dispense, Dispense_Adjustment, " & _
"Replacement_Card, Replacement_Card_Adjustment, Deposit, " & _
[code]...
I am working on a 1-page report, that basically consists to select 1 record from table and bind values to proper fields (eg. =Fields!name.Value).However, I have one field in the table that will be just "Y" or "N".When this field will be "Y" I would like to show in the report "Yes, I do."; otherwise I would like to show "No, I dont."
View 1 RepliesThis is the only code I could find and it doesnt work:
Private Sub DataGridView1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseUp
Dim pt = New Point(e.X, e.Y)
[Code]....
I wrote some code to update the count of a field in a table, but it is very slow. So I'm trying to do it in a subquery to speed things up, but I'm not very good with subqueries. I'm getting the error "Subquery returned more than 1 value".
[Code]...
Using VB2008, Access
I have 2 fields defined as date/time (short date).
I need to store dates fields which may at times be blank (null), how do I go about that?
I tried using:date.minvalue and that stores the value of 12/30/1899. I would like the field to be blank until the user enters a valid date.
I am linking to an SQL table with 'Money' field. When i try to update this field in VB.NET I get an error message that "Can not convert a character value to money. The char value has incorrect syntax".
[Code]...
I need this for displaying in my crystal report here's my code:
Code: cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'" and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
How to check if string entered in a text box matches a field in a data table.I have a form with two text boxes for users to enter their Username and Password. When they enter their details and click the 'Login' button I want their details to be checked against data in a data table to see if they match or not. I am using an 'if...else' statement but can't work out the syntax to use. My code is as follows:[code]The fields I want to match the textbox strings against in my database table are called 'Username' and 'Password'.
View 2 RepliesI have a matrix with rows indicating a name (Ex Store name) and I have data pertaining to that in the DATA cells. I also have another date field in this format (MM/DD/YYYY). I would like to use a cross tab between Store Names and Just the Month of the date field.
[code]...
is there any expression I can use to get the month format on the header of column.
I have a dataset; I want to create an equivalent record set. What I really want to do is create the XML that a record set can load; I have no other use for the record set per se. I want to be able to load recordsets on other machines (which use VB6 ins of vb.net) with this data. I found some code that loops through the columns in the dataset and creates the fields in the record set; that's executing. However, the code given to open the record set fails with "incompatible or incorrect parameters" or some such. [Code] I can see that a recordset is a construct meant to bridge between running code and a data store of some sort, but in this case the data is "stored" in the dataset, not anywhere else. I want to put that data in the XML form that the recordset uses, so that other code that can only use recordsets (ins of datasets) will be able to read it.
View 2 RepliesI'm working on a emulator program where I load all controls from a database. My database looks something like this :
Code:
IDPageTypeControl_Indexnr Property Data
1131Label 1 Text Lbl1
1161Label 2 Text Lbl2
[code]......
I have a problem with sorting in datagridview. I load an xml file in a datagridview and I sort the collums for check. when I try to sort it according to it's number the sorting goes like this:
[Code]...
i'm using an sql database, and on my application i load a listbox with data from table1. like:
Code:
dim sqlstr as string = "select name, code from table 1"
dim sqlcmd as new sqlcommand(sqlstr, conn)
dim dr as datareader
[Code]....
what i want now, is for the code also to be loaded to my listbox, but for it not to be visible to the user, so thet it can in the future be used in where statements.
i am new with visual studio 2008 and basic I have a combobox1 and combobox2 that are representing cities Combobox1 represents departure city and combobox2 destination city.Now i have a combobox3 that i want to load when i click it and run this sql query:
SELECT time_departure
FROM routes
WHERE (departure = Combobox1.value) AND (destination = Combobox2.value)
so when running the .exe of the application ,after selecting departure and destination ,when i click on the combobox3 ("hours") it will generate the results of the upper sql query as options to select.All i need is the code between this:Private Sub ComboBox3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox3.Click End Sub
Everything was working fine but suddenly started getting this error. I have the following code
ReportName = Application.StartupPath & "" & ReportName & ""
Dim ReportForm As CrystalDecisions.CrystalReports.Engine.ReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument
ReportForm.Load(ReportName) - I get error at this line
The path & other things are right. Till yesterday it was working fine & now I started getting this error, the only change I made in the report was I added a field.
I am using this code at the last line of my form load. I want the position 5,5 to have the cursor set at it. It works when then datagrid is already open:[code]However, when I use it on the form load, you can see that it was selected on the datagrid, but the cursor is set at textbox1...which happens to have the first tab order on the form, even though I have acceptstabs off. Can anyone tell me why this would happen? Basically, it is setting the cursor at the cell I want, but after the form loads, it jumps to textbox1 and highlights the text.
View 1 Replies