how can I loop through rows in a dataview?
So i might have a dataTable with 100 rows and a dataView with 10 (because of the row filter applied)
how can I loop through these 10 rows?
I...
I'm trying to insert a datarow into an existing datatable in a dataset, but can't seem to get it to work
Dim ds2 As DataSet = DB.GetDS("select AffiliateID, Name From affilia...
Experts;
My first post in three years, so please bear with me!
I have a client based report (RDLC) which uses a dataset based on a stored procedure. I'm presenting the report to the cli...
I have a datagridview that I need to bind to a dataset that contains data from a Access database table. The datagridview needs to allow the user to edit existing data as well as add new data...
Hi, I have a query which craps out with the error:
"An explicit value for the identity column in table Table_Name can only be specified when a column list is used and IDENTITY_INSERT is ON....
I'm attempting to add the data from an excel file (that is formated the same way as the datagridview) into a datagridview. The probelm I'm getting is the xls data is being appended to the exis...
I have a VB.NET form checking the status of something in a database every 5 seconds. If TRUE I want the form to become visible over everything on the screen.
How can I do this? Right now it...
Hi,
Another VB.Net Novice Question for you.
I have a string 000xxxxyyyyzzz
I want to create a folder structure based on the string - e.g c:\000xx\000xxxxyyyyzzz.tif
I know how to man...
Help!!!
I setup a new computer for my development. I re-installed VS2005 and the service pack. All Windows XP updates have been applied. I am now getting the following error when I try t...
Good Day
Experts:
I have an issue that I came up with 2 solutions for. I don't know how to achieve either.
1) When I load a DatagridView, I want to select a value in it that is in a t...
Hi
I am trying to papulate ComboBox in my VB.NET 2005 Windows application...
from database i am reading 2 values one is UnitID and Unit Name
after that i added both values in to my ComboBox...
I'm new to vb but have some experience with sql server. I'm trying to learn to build sql server 2005 front end apps with vb.net 2008. I would like to create a login form for my startup form an...
Hi All,
I am converting a word basic project written in VB6 to VB.Net, referencing Microsoft.Office.Interop.Word.dll. I am using a *.dot file as a template set up. I need to populate this t...
I am new to Visual Studio and more experienced with VBA.
Let's say I have a file called test.csv in c:\myfiles which has 3 lines
1,antelope,55
2,bear,44
3,cat,33
How can I open thi...
I have a table setup in SQL called ActionManagement and am trying to query this table using vb.net. After querying this information, I would like it displayed in a datagrid on the same form. ...
I have another question open asking how to add multiple images to one subitem in a listview. I just realized that I can't figure out how to even add one image to a subitem! I've searched thi...
Sir,
I want the code to send sms message for mobiles using asp.net and C#.net and we are storing all the mobile numbers in database using sqlserver2000
First off...im pretty new with VB. Im using VB.net 2005. I would like to simply display the time and date in a specific spot on the page. Can I do this in a label or do I have to use the ti...
I am looking for a VB.net example that show how to access an snmpget function to poll snmp enabled devices. I am using vb.net and would like to see the code that would allow me to send an snmp...
Im trying to find a currency converter webservice. Google has a Finance API but I can't seem to figure out how to do currency conversion using it. Does anybody know if the Finance API can do c...
OK Here goes.
I have developped a VB.NET 2005 application which includes the fancy new "drag 'n drop" DataSet tool. When you first create a new dataset VB writes the connection string into...
I'm trying to build a VB.NET program that can lock or unlock the local computer's desktop (e.g. the equivalent of windows key+L).
It's easy enough to *lock* the desktop. There's lots of scr...
Hello,
I would like to be able to change this:
Dim lbl1 as label
Dim lbl2 as label
Dim lbl3 as label
lbl1.text = "Yes"
lbl2.text = "Yes"
...
I need to get the row count of an excel document. I will be reading in excel document and the row count will vary. I tried objWorksheet.Rows.Count, but it returned 65536 and I have 2077 rows o...
Guru's!
I am in need of a timestamp string. In the following format:
yyyymmddhhmmss
which would look something like this:
"20050728113805" = 7/28/2005 11:38 AM
How would one ac...