I'd like to utilize Select & Insert statements on a DataTable in VB.NET or C#.
Example:
Dim Results as DataTable Results = Select * from SourceDataTable where PlayerID < 10
Is anything similar to this possible?
I'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesIn a vb.net Windows Application, I have a datatable wich is not from a database. I want to add a new row, but when I add a new row only the new row is in the datatable, not the existing data.dim dt as datatable treelist.datasource=dt this is existing item here in any event i want to add the new row in the datatable so that new node is added to the treelist
View 2 RepliesI have a dynamic datatable, created from a database. I want to add a new row (blank), so there is an option to choose nothing in a combobx. Everything works ok without adding the new row. But when I add a new row, the combobox displays nothing. What am I missing?
Here is the code
Dim DT As New DataTable
DT = DS.Tables("CallStatus")
[code].....
I'm using VB.Net to create a windows form application. One form has a DataGridView that displays data from a SQLServer table via a TableAdapter and BindingSource whose filter is set as I need it. Elsewhere on the same form I would like to show totals for four columns of the same table, but from a totally different set of rows. All I've been able to figure out is to create another TableAdapter - but this seems foolish since the SQL table data has already been brought into my application by the first TableAdapter.Is there a way to run a query on the DataTable that was filled by the first TableAdapter, and how do I get the query results?
View 8 RepliesI'm trying to make a calendar in vb.net and I have come across this problem. I want to append some text into an existing datatable row. When I watch my debugger it says:"In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.".
Dim aantalRijen As Integer = 1
For x = 0 To 6
Dim dttopdrachten As New DataTable
[code].....
I have a table like this
col1 col2 col3
a b
c d
I want to fill the 3rd columns.
I am trying to import an XML file to an existing datatable created in Visual basic and saved as a dataset and as a mdf file. However I having problems writing code that will allow it to save and recognize what fields to go to from the corresponding xml file.
For instance I want all that start <Artist> to go in the artist field etc....
I need to get a text file into a blank datatable that already exists. The table has its column names already so I need to insert the data into the fields. The text file is set up as so for example:
[Code]...
I am working with two different connections because the information I need is stored in two different locations. One being Oracle, the other being Access. I pull all the information I need from Access with the exception of one field which I pull from Oracle. When I add this field to my datatable, it adds it to the end. I am wanting the column that I add to be between column 1 and 2 of my current datatable. Anyone know the best way to do this? From what I could find, there wasn't a way to re-arrange columns. Here is my code.
Dim da As New OleDbDataAdapter(" SELECT tblSummary.WorkOrderNumber, tblLabor.Crew, tblLabor.NumberOfMechanics, tblLabor.NumberOfHoursPerMechanic, tblTasks.TaskNumber, tblTasks.TaskDescription FROM (tblLabor tblLabor INNER JOIN tblTasks tblTasks ON
[code].....
I am working with VB.NET.. i have a DataTable called "QUESTION", containing 3 fields:
QuestionNumber (unique integer key)
QuestionText
QuestionType
In my SQL Server database I created a Table called "QUESTION" with the same fields.
QuestionNumber is defined as integer unique key, auto increment
Now, when i make a bulk copy to insert the DataTable into the SQL Server, the database overwrites my QuestionNumber from the DataTable and generates new ones (starting from 1 increment 1).
How do i have to change my database setup, that the original QuestionNumbers are copied into the database?
I am using Microsoft Visual Basic 2010 Express. I have a WPF-based project. I have a successful connection to a database in Database Explorer, and a working existing Data Source in Data Sources.
I created a datatable from the datasource using this code:
Dim roster_table As New DataTable("AGENT_ROSTER")
I can manipulate this datatable just fine, but I cannot figure out how to save its data to my database (agentroster.sdf) since the connection is on a global level, and isn't declared in this particular window.
How do I update this database from the datatable on this window?By the way, I tried creating a connection on this window's code, using the exact same connection string as the successful globally-connected database, yet it said that it couldn't connect.
I am trying to edit, add, and update my database. I have the code for updating and it updates fine (I can see the modified time on the file), but I was wondering why none of my changes were being saved when I closed the window. Then I realized I was an idiot and I don't have any code to actually accept edits on this form, I just have code for updating and adding new rows It wouldn't update without me telling it which rows have been edited and need updating, right I mean I can't just type a new value in the textbox, click save, and expect it to save the change.This is the update and new row code I'm using:
Private Sub SaveToolStripButton2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripButton2.Click
Try
[code].....
I've seen this great example of serial communication in VB.NET[URL]..I try to use it in a project I am working on but somethings are not clear to me.1: Now the send and received data is shown in one RichTextBox but I would like to split this into two RichTextBoxes (RtbSend and RtbReceived).It is unclear to me how and were data is assigned to the RichTextBox?
2. the received data is shown in the Richtextbox as one long line, I would like to get a new line for every send message.So for example: I I send "test" four times, I would like to see:The example describes that "comPort_DataReceived" is executed when data is waiting in the buffer. Where can I see the eventhandler responsible for this? How does it know data is waiting?The problem is this kind of coding is a bit to difficult for me. I want to understand the code before I implement it into my project. I understand most of the code but this is unclear to me.
I am working with some prewritten VB code ,and this portion of code opens a new excel spreadsheet . I would like to instead , open a existing excel spreadsheet that I would like to have a template that explains my data that is loading into it. Could you please give me an idea what I would need to do with this portion of code?
[Code]...
I've seen this great example of serial communication in VB.NET
[URL]
I try to use it in a project I am working on but somethings are not clear to me.
1: Now the send and received data is shown in one RichTextBox but I would like to split this into two RichTextBoxes (RtbSend and RtbReceived).It is unclear to me how and were data is assigned to the RichTextBox?
2. the received data is shown in the Richtextbox as one long line, I would like to get a new line for every send message.So for example: I I send "test" four times, I would like to see:
Test
Test
Test
Test
now I see: Test Test Test Test I've tried ctrlf but this does not work.The example describes that "comPort_DataReceived" is executed when data is waiting in the buffer. Where can I see the eventhandler responsible for this? How does it know data is waiting?The problem is this kind of coding is a bit to difficult for me. I want to understand the code before I implement it into my project.
As my latest questions have stated, i am in a process of researching on Silverlight 3 and its application as a suitable RIA solution to a pre-built project a client of ours wishes to webify. And my experience in .Net and silverlight is about 3 - 4 weeks.I have now become aware of .Net RIA Services. I require to use an existing VB class; which was created as a quick wrapper class to emulate a small piece of the client's application code. This is used as a proof of concept. It contains one function which uses the client's DLL files to return a simple data type This class has already been used successfully with Flex/Weborb combination.I unfortunately do not have enough knowledge or experience in Silverlight/RIA Services to grasp what it is i have to do to get the file working. All the examples I find online only specify the method where you use a database as dataSource etc.Could you please inform me how i would go about implementing RIA Services with Silverlight 3, using existing code/classes with no DB? Or could you point me in a direction for further research on the matter?
View 1 RepliesI have questions on this [FAQ's: OD] How do I open an existing Excel Workbook? I have playing around with the code little. Trying to mod the code to display the selected path and File name in the textbox I have on a form. I can to get it to work right
View 1 RepliesI'm using vb.net. Basically, I have a drop down list, text box and a submit button. You choose a movie director from a drop down list, then type in a movie, click button and it adds the data to my database.There's another button which hides/shows drop down list, text box and submit button using Visible = True and Visible = False, but what I don't like about it is when it hides the things I said before, it leaves some white/empty space like if they are still there, but not visible.Is there anyway to put some kind of holder/container and place a button which when clicked could add my drop down list, text box and submit buttons to that place?
View 1 RepliesI need to make a program in vb that takes a 1 page existing pdf that i specify and inserts that into another existing pdf that i specify.
View 4 RepliesMy system use to run on from a access database. Now I created the database on a MySQL server.
View 4 RepliesI have this code going into a datatable
"SELECT Sales.Quantity, Sales.UnitPrice, Sales.TotalExVAT, Sales.VAT, Sales.TotalIncVAT FROM Sales WHERE QuotationID=" & QuotationID & " AND Batch=" & arow("Batch") & ""
Dim thisbatchDT As DataTable = dataacess.getDatatable(QUERY, "TheBatchInfo")I was wondering how i could add £ OR $ Symbols to my data table, without them being in the database, using the SQL code.
I have connected my sql db with vb and I m trying to make a UI. My question is that when I write code in order to create datatables and I fill them with the results of queries I've created, where do these datatables belong? I'm wondering if I have to define a new dataset or do they belong to the existed dataset which is created by the dataset configuration wizard??
View 3 RepliesMy system use to run on from a access database. Now I created the database on a MySQL server.I can connect to it using the connection wizzard, but I prefer using my old methods as shown below.[code]...
Does anyone know how to hardcode a connection and selection like I use to do with access, but only in MySQL?
I need to create unit testing project for my current website. The currentw ebsite si written in VB. All unit testing examples are using interface to create mock object. My current VB class does not implment any interface. Can I add interface and implement it to my current class and functions without affecting or changing codes to any pages in my website that call the functions? For examples my current class is like:
[Code]...
make objects from the ToolBox using code instead of changing existing objects invisible then visible later?
View 7 Repliesjust wondering if it is possible to add a method to all forms in my project without having to do it on one form and Inherit all my other forms from that one
View 3 RepliesIn VB.NET:
DataTable.GetChanges(Not DataRowState.Deleted)
What is the equivalent in C#?
I'm very very very new to VB.Net and am doing a class project. I want the user to simply clicka print button and get a printout of an existing Word document. Is this possible and if so, can someone suggest the code?
View 7 RepliesI'm looking for a code snippet that will add graphics (lines, circles, etc.) to an existing pdf file & write it out as a new file.
View 6 Replies