20,278 Topics
 | |
| | Hello my application have a main form. i have set the isMDIcontainer to true on the form properties. How do i set other forms to child form of the parent. i need to do this because the other forms start position is CenterParent. but as it is now when i … |
| | i want to populate a listbox from a sql database and foll is the code i encountered error with: Dim con As SqlConnection Dim cmd As SqlCommand Dim lrd As SqlDataReader Dim dsitemlist As New DataSet con = New SqlConnection("Data Source=DHAVAL-PC\SQLEXPRESS;Initial Catalog=final;Integrated Security=True") con.Open() 'cmd = New SqlCommand("select Stud_RollNo from …  |
| | why is it sometimes i get an error? it doesn't highlight the error [B]CODE[/B] [CODE]Dim SqlQuery As String = "Select UserName from Login" Dim SqlAdapter As New MySqlDataAdapter Dim SqlCommand As New MySqlCommand Dim Ds As New DataSet Dim i As Integer With SqlCommand .CommandText = SqlQuery .Connection = sConnect … |
| | I have multiple datatables containing multiple columns. I need to combine all of them to a single table. Here is an example: TABLE1 ================================================== -ID---NAME---AGE---ACOLUMN3---ACOLUMN4---ACOLUMN5- ----------------------------------------------- -1---JON----23------TRUE------FALSE-------TRUE -2---JANE----29------TRUE-----FALSE-------FALSE- -3---JOE----32------TRUE------TRUE--------TRUE ================================================== TABLE2 ================================================== -ID---NAME---AGE---BCOLUMN3---BCOLUMN4---BCOLUMN5- ----------------------------------------------- -1---JON----23-------TRUE------FALSE------TRUE -4---JOEY----34------FALSE-----TRUE-------TRUE -3---JOE----32-------TRUE------TRUE-------FALSE ================================================== COMBINED TABLE ================================================================================= -ID---NAME---AGE---ACOLUMN3---ACOLUMN4---ACOLUMN5---BCOLUMN3---BCOLUMN4---BCOLUMN5 --------------------------------------------------------------------------------- -1---JON-----23------TRUE------FALSE------TRUE-------TRUE------FALSE-------TRUE -2---JANE----29------TRUE------FALSE------FALSE------FALSE-----FALSE-------FALSE -4---JOEY----34------FALSE-----FALSE------FALSE------FALSE-----TRUE--------TRUE -3---JOE-----32------TRUE------TRUE-------TRUE-------TRUE------TRUE-------FALSE ================================================================================ Can someone … |
| | hi! i'm having a project in school regarding vb.net and i badly need your help! it is about connecting vb.net to access. i need to be able to add, delete, edit, and save data to a table in access using a form in vb. i am also required to view …  |
| | Help.. Why is that everytime i add an imagae in my project (add resource) and use it as my image background i always get this error in dialog box saying.. "There were build errors. Would you like to continue and run the last successful build?" before.. i was able to … |
| | i have a form with a listbox. the listbox can be edited (things added/deleted) and when the form is closed i would like the items in the listbox to be saved when the red "x" in the top right corner is clicked any ideas? |
| | Hello, I'm back again with the same code however I have tried everything and I am still stuck. The message box works, and all of the values are correct but the last value. I would rather not change the message box code, but maybe just the last line where the …  |
| | This is my login form [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:/Users/Space Era/Documents/User.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = '" & TextBox2.Text & "' AND password = '" & TextBox1.Text & … |
| | I have two forms; I'll call them frmReturn and frmReturnItem. FrmReturn is bound to data in a SQL table; data entered in frmReturnItem is stored as a child table in SQL. In the database, there is a one-->many between Return and ReturnItem. frmReturnItem can be opened only from frmReturn. frmReturn … |
| | Hi, I've got two tables ina database which I'm trying to update at the same time. I'm using the code below to update: [CODE] Conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=KingfisherDB.mdb;") Conn.Open() 'Define data adaptor and fill data sets DA = New OleDbDataAdapter DS = New DataSet Cmd = New OleDbCommand Cmd.Connection … |
| | Below is the code I have been working on in VB.NET What basically happens is that when the user presses the calculate pay button, a message box is supposed to appear with all of the information in it, however the error comes up with: 'InvalidCastException: Conversion from string "Total pay: … |
| | I sence victory been battling the this code for 2 days now. the code i have generated is [CODE] strsql = "delete from cg_security_user_right where user_id= " & TextBox1.Text & " role_id=" & TextBox2.Text & ""[/CODE] it comes up with this error Syntax error (missing operator) in query expression 'user_id= … |
| | hi i have a simple relationship which is shown in the link below [url]http://www.flickr.co...N06/6948010043/[/url] after doing much research i cannot find a proper way of deleting rows which are linked in all 3 tables. could someone guide me on the best way of doing this. This is the code i …  |
| | Hello i want to have a txt file on my application final .exe the .txt is located at C:\Users\Timhook\Documents\Visual Studio 2008\Projects\WWTBAM \WWTBAM \bin\Debug\hask.txt thats my project bin\Debug folder will it include the this hask.txt file after publishing the application? thanks |
| | I start my project in vb.net backend is sql server i have completed my design now i start my coding but i am confused for connectivity code whether i used dataset or datable which is good? please give me best connection code for retriving,updating and deleting data from database.. |
| | When I enter a vb.net textbox, if there is data in it, I want it to be highlighted. I looked around and couldn't find a property that would do this so I do the following: I built a little subroutine that does the highlighting and then call it from the … |
| | Hello All, Can someone please help me with this? I converted from C# to VB.NET and get this error : [B] A namespace cannot directly contain members such as fields or methods [/B] I appreciate you looking at this. Regards Imports System.Collections.Generic Imports System.Linq Imports System.Text Namespace UsedCarsSales Public NotInheritable … |
| | [CODE] Dim wri As New IO.StreamWriter("e:\test.txt", True) wri.WriteLine(ListBox1.SelectedItem, true) wri.Close())[/CODE] etc in llistbox1 items , "1" "f1" "f2" when i click for example f1 that code will save it and when i want you save the same item it wit will save it in other line and in test.text file … |
| | how to create crystal report using sql quary in vb.net step by step. |
| | hi, all i need to add combobox in datagridview. actually i have 3 fields in database which are Sid Fee status what i want to add combo column in field [status] with two option PAID or UNPAID which a user can select and update it . i am all clear … |
| | i am working on a project for booking management system for photographers.. can anyone suggest some tables and content for the project....! |
| | Hi to all, I want to pass the below statement to a report... Kindly help me how to do it ... select a.po_number,a.mr_number,b.item_code,c.item_desc, b.qty,b.rate from po_head a,po_detail b,item_master c where a.mr_number=b.mr_number and b.item_code=c.item_code and po_number = ' & combopo.text & '; kindly help...  |
| | Could anyone help me, we're currently working on a webbrowser for thesis. We want to have the google chrome seetings in vb2010. |
| | When Creating a query using the sear Criteria Builder . I keep getting the error : " The schema returned by the new query differs from the base query " I no this means that the error is due to the query attempting to return too little columns i have …  |
| | i had to take someone elses project this year because i failed to complete my project,however im having troubles with the one i picked up.i cant even change it now because ive already submitted synopsis and software engineering journal on that new project.its on gymnassium system. the main form had … |
| | Hello friends, hope you guys are dong well. problem again and really looking up to my expert friends here. I'm new and trying to write Edit code in VB.NET. the problem is [B]Select * From Application Where Sl_No='" + txteditno.Text + "'", con) [/B]is not displaying and record although it … |
| | Can somebody here teach me how to print in a current row in Gridview? Am using Crystal report, ms access 2007 and Vb.net 2008. This is for receipt matters. To be able to print a receipt after a transaction is made. To be able to print a selected row in … |
| | hi, i am facing with the ambiguous problem. and i don't know how to solve it. kindly advice. i try to search the solution for this at [url]http://msdn.microsoft.com/en-us/library/aa479312.aspx[/url] , it provide me below solution: Issue 22: Ambiguous references and naming conflicts The .NET Framework 2.0 adds a host of new … |
| | please help me on my school project it is called "faculty evaluation system" my project is used to evaluate faculty members,i will use the following softwares, visual basic 2008 editon, ms sql server 2000, and crystal reports, what i want to do is their will be a question and it … |
The End.