20,284 Topics
 | |
| | Dim cmd As OleDbCommand = Nothing Dim smd_search As String = "select * from Old_info where UG_PG='BSc'" Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Bavu's\project\vb files\dms\SPA_Database.accdb") Dim myDa As OleDbDataAdapter Dim mydataset As DataSet cmd = New OleDbCommand(smd_search, con) myDa = New OleDbDataAdapter(cmd) mydataset = New DataSet() Try If con.State …  |
| | Whenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly … |
| | How can I copy a datagridview to a gridview.. I only ask b/c I need to use the rendercontrol and its not available using datagridview. And Gridview is not an option for me to use in a windows application.. BUT the class is.. very odd but anyway. All the colors … |
| | Hi All, Don't know if this is the right forum for this query, but couldn't find anything more suitable. I have written a new app in VB.net as a front end to a mySQL database held on a PC on the LAN running Windows XP. This worked fine for a … |
| | Dear All, I have two arrays (array1 and array2)with double type data. I want to sort array1 to ascending order, and array2 with corresponding to the array1 indexes. Is this possible? Example below, Array1(0) = 2.30 Array1(1) = 4.20 Array1(2) = 1.90 Array1(3) = 0.20 Array1(4) = 0.88 Array2(0) = … |
| | I am currently working on a stock market monitoring application and I was wondering if anyone cold help me by giving me a guideline on how to create a new portfolio(sort of a personal account) for each user that accesses the system such that 2 different users do not have …  |
| | I am currently stuck on a project where I am populating a datagrid from a series of labels and textboxes. I have that part down. Now for the part where I actually add it do the database, I am having a problem. It is actually adding everything to the database … |
| | I was wondering if anyone knew of a good tutorial for parsing data from a text file and then populating the data into multiple text boxes. I have a text file with information pertaining to my form. The text file consists of key identifiers for each piece of information needed … |
| | trying to trying to get extract content from a web page in to a listbox and contents are in this format 107.2.71.168:1708 107.3.217.65:1580 107.3.217.65:51723 107.43.148.15:8651 107.8.39.163:57071 107.8.63.188:11244 107.9.254.237:17209 108.222.146.33:44973 |
| | How to allow the user to select the date from the DateTimePicker and store that selected date ,month and year in the database table? What is to be written inside insert query of code? |
| | How to retrieve the particular column row to the text box? I mean how to display it in textbox? The column has got different rows. The code I wrote in vb net is : cmd = New SqlCommand("select ida from Issue where aname='" + TextBox3.Text + "'", con) In the …  |
| | hi! I've searched for backup and restore codes. I've also tried them out but they won't function as I want them to. I think the main problem is that, the database that I want to backup is contained inside the visual studio project under App_data. Can anyone please help me … |
| | Hey guys, I have a form that is used to navigate through records in a table one at a time. The form generates the number of textboxes required automatically. Navigating through the records is easy enough, but when I click the update button it comes up with the error: Object … |
| | The user will click the book name in the combo box. **Note: The combo box is separate from gridview i.e. it is not a part of gridview.** Then the gridview for Issuing books i.e. with the columns bid,bname,aname,data of issue,date of return shoudl be** displayed.** The row that will be …  |
| | i've been all over the internet to solve this problem, but i've found no solution to my problem.my concept is this. Based on selected value within a combo box, the datagridview will populate with values from the database. For test = 0 To containerdetaildatatable.Rows.Count - 1 DataGridView1.Rows.Add() DataGridView1.Rows(test).Cells(0).Value = containerdetaildatatable.Rows(test).Item("Roundtrip") … |
| | I have a problem im my order form the user enter the order he chose the customer name and the product name and they should print in the list box the user should click on next product so he can enter another product for the custmer and when he finish … |
| | Hello my fellow DaniWebbers, I have a discussion topic for everyone. Winforms VS. WPF ITT: Your opinion on the two Your reason for coming to that discision Your approval/disapproval of Microsoft abandoning WinForms How this impacts your vb.net skills |
| | Hi, I have a MS Access 2003 (.mdb) database called "Assets.mdb" which I display in a datagrid. When I edit entries on the datagrid and click my save update/save button upon reloading of the application they have not been saved. What am I doing wrong? Private Sub btnSave_Click(ByVal sender As … |
| | I have created a project in which i am printing Hall ticket for an examination. i am using visual studie 2008 as front end and sql2008 as backend. I have created a report in crystal reprot. I have photographs of students in a local folder. how do i access or … |
| | the coding will works if the data type of my primary key is integer.but when i try to change the primary key in string data type i cant delete oe edit. below is my coding for that 2 button that is working. coding for edit button ` Private Sub Button4_Click(ByVal … |
| | Hello everyone. I'm trying to work with this kind of file: http://www.mediafire.com/?da0ad07pzfogdl0 (you may use Notepad++ to open it) I think it's a binary data file but I'm not sure. Anyways what I need to do it's to edit some of the text part inside it. Example: http://img403.imageshack.us/img403/8017/94022290.jpg I'd like … |
| | Hello Everyone,I'm new at DaniWeb I have a problem with my file download function. This's my function Private Function download_files(ByVal _URL As System.Uri, ByVal _SaveAs As String) If InternetConnection() = True Then Dim _WebClient As New System.Net.WebClient() Try AddHandler _WebClient.DownloadProgressChanged, AddressOf _DownloadProgressChanged lblStatus.Text = "Downloading File :" & _SaveAs _WebClient.DownloadFileAsync(_URL, … |
| | how to deduct qty from data base i have used this sentex to deduct...... cm1.CommandText = "update inventory set qty=qty- " & cust_gv.Rows(i).Cells(3).Value() & " where item_name='" & cust_gv.Rows(i).Cells(1).Value() & "'" this sentex is giveing error |
| | Dear Experts, I am able to develop a service and Start it into services window; but i am unable to show form from this service. Actually i have to develop a project (run as service) in which form will be display when end user close this form service will be … |
| | As the beginner I want to know Is it necessary to add MDI parent for Library management System? Can this be done without MDI Parent too? And also is it necessary to add the below code for mdi parent of every project? Private Sub ShowNewForm(ByVal sender As Object, ByVal e … |
| | Hi i want to join two tables,'Employee' and 'Dispatch'. Dispatch has column 'DispatcherID' and 'TechnicianID' which are both foregn keys to EmployeeID in Employee table.I want to join these two tables using EmployeeID so that i can obtain the matching name to each id.but it only works when i make … |
| | I'm trying to print the selection of my picturebox as the background of the image. I can get the image to show, but it's not the height and width of the background. Any help would be appreciated. Thank you. ' Fig. 15.24: CheckWriter.vb ' Printing a paycheck. Imports System.Drawing.Printing Imports … |
| | I am trying to create a sort of code library in visual studio 2010 where the form displays a list box of certain project files in vb that i have made in the past and when selected, a button can be pressed that launches the .exe files of those visual … |
| | Hello Friends, I m Developing an windows form application. i have a winform on which i have datagridview and i am saving the data to Sql Server database from datagridview directly . i m using the following code for connecting & saving data of datagridview to database using button click … |
| | Hi Guys, I am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname … |
The End.