|
Hi, I'm creating a windows application for user to input inventory items. I'm using a datagrid for the user input. However, when I'm creating the SQL statement to insert it into the database, I couldn't figure out how to get the datagrid row count.
When i'm using datagrid.VisibleRowCount, only the visible items will be counted (therefore added to the DB). How could I get the total row count for datagrid. Anybody? Thanks! 
|
|
|
|
|
hello,
why do you need the rowcount? if your datagrid is bound to dataset you just have to call the update-methode of the dataadapter. the dataadapter have to be configured with a selectstatement and the db-table must have a primary key so the dataadapter can generate the insert, update and delete statements. or isn't this your problem..?
keep trying
|
|
|
|
|
Actually my datagrid is not bound to any dataset. I start the form with an empty datagrid, which let the user to input the data (it look somewhat like microsoft access). So once the user has fill in all the data, the user has to click a button to save the records.
To save the records, i need to know how many rows of data the user has entered. Therefore I need to know the number of rows for that datagrid.
And the only method that the datagrid has is "VisibleRowCount", which only count the visible rows.
|
|
|
|
|
it is much easier to handle data with a dataset. you can build the strucure of the dataset in memory and bind it to the grid. i think the grid is not a good container for data, it's just a input/output mask for something like a grid.
|
|
|
|
|
I made a simple database program. I wanted to use it at work. I used MS Access as my database. I have finished everything and made the .exe file for the program that i made. I'm wondering if you guys could help me connect my program to my database (MS Access), without going into like using the ODBC. I just want to connect my program to my database using some codes.
jct
|
|
|
|
|
Well, you've given us no details about what you want other than 'connect'. Besides, if you've already got the database done in Access and you've already written the VB code, what's the problem? You should have been testing the code against the database already...??
You can start with this[^] for a guide on how to connect to various data sources and use them.
Your connection string will probably look something like this:
Dim strConnect as String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Documents and Settings\username\My Documents\dbFile.mdb"
RageInTheMachine9532
|
|
|
|
|
Thanks so much for the reply. And to give you a bit of details on the simple program that i have created, well, i usually used ADO as my mediator between my program and my database (connection). The program is working fine. But when i try to create the .exe file and run it to my computer at work, it won't run since it tries to seach for msstdfmt.dll and i can't just install the dll file cause my computer has admin rights and i don't have access on it. So, i'm wondering if i could connect my program to my database without using ADO and just use codes to have it connected. 
|
|
|
|
|
Well, from what I can find, msstdfmt.dll is the Data Format object library. You could TRY recoding the app to use DAO, but I think without that file, you're out of luck as Access installs it when you install Office and I think no matter how you go about getting to the database, the Jet Database engine still needs this dll to do it's work.
RageInTheMachine9532
|
|
|
|
|
Thanks for the info. i really appreciate it. thanks again!;)
jjt
|
|
|
|
|
Try Planet-source-code.com
|
|
|
|
|
I want to be able to start my app (vb 6) by "throwing" a file on it (via sendto). When the app starts i want to catch the name of the file that triggered the application to start... Is this possible in vb 6...?
Or do I have to have my application running when "throwing" the file at it?
(I don't need to open or manipulate the file in any way: I just want to be able to catch the filename)
|
|
|
|
|
Simple, when that happens, your app gets launched with the full path and name of the file as it's command line parameter:
MyVBApp.exe C:\Documents and Settings\MyId\Desktop\TestFile.txt
All you have to do then is get the command line arguments from Command().
RageInTheMachine9532
|
|
|
|
|
RageInTheMachine, that was a peace of cake!
Thanks a lot!
|
|
|
|
|
I just added a .vbs file to my windows forms application. I was wondering how to invoke that vbscript from within my application.
Thanks.
|
|
|
|
|
let say i got 2 forms, form1 and form2, how i going to show form2 when i click one button in form1??
just like form2.show in vb6!! but i cant find that in vb.net!!
|
|
|
|
|
In the button click event handler in form1 create (or obtain) an instance of form2.
MyForm2.Show()
or
MyForm2.ShowDialog()
depending on how you want it to work.
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
Enumerators in .NET: See how to customise foreach loops with C#
|
|
|
|
|
thank you for replying me!
but i dunno how to create an instance of form2 in form 1!!
|
|
|
|
|
Dim MyForm2 as Form2
MyForm2 = New Form2()
MyForm2.Show()
[I'm not a VB/VB.NET programmer so I may have the syntax slightly wrong]
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
Enumerators in .NET: See how to customise foreach loops with C#
|
|
|
|
|
Dim frm As New Form2()
frm.ShowDialog()
|
|
|
|
|
Say if you want to display form1 from form2.
In the form2 create the instance of form1
- dim frm1 as new form1()
and then
frm1.show or frm1.showdialog will display the form
- Sunil
|
|
|
|
|
say suppose i want to develop a windows aplication that will connect a ms-access database over the internet using ado.net & vb.net
tbhattacharjee
|
|
|
|
|
I think you need ASP.NET web application for that not windows application unless you were to consider Web Service.
Sonork 100.41263:Anthony_Yio
|
|
|
|
|
at runtime i want to drag the column of datagrid but don't have knowledge now.please help me out and if it is possible then please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|
|
This is not possible in ASP.NET. You could inherit from the DataGrid control to and provide your own implementation (heavily augmented with a liberal amount of javaScript) to provide the functionality that you desire.
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
Enumerators in .NET: See how to customise foreach loops with C#
|
|
|
|
|
say suppose i have datagrid with three column and one column having check box and 'n' no of rows are there.now i want to read the content of all the rows in a loop when no of rows is not fixed.how to do it using vb.net.if it is possible then please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
