20,278 Topics
 | |
| | i have 2 tables : 1.Ms_Menu Menu_Id,Menu_Name 001 | Menu1 002 | Menu2 003 | Menu3 2.Tbl_User User_Id,User_Name,Menu_Id User1 |Name1 |001 User1 |Name2 |002 User2 |Name2 |002 i want to joined 2 tables using UNION(or other way if works is fine->left/right join) my coding : [code=sql] SELECT User_Id,User_Name,Menu_Id,'' Menu_Name FROM …  |
| | In an interface there are 5 tabs (Tab 1 to Tab 5). Each tab has a Binding Navigator to Add, Delete, Save, Edit items. For Tab 2 (subcategory for tab 1), the Delete button in the Binding Navigator has the following code. Tab 3 is the subcategory for tab 2, … |
| | An interface has a few tabs on it. (Tab 1 to Tab5). Tab 1 is labeled Item Category Level 1 and the following tabs are named accordingly. Tab 2 is Item Category Level 2, Tab 3 is Item Category Level 3 and so it goes. Item category level 2 has … |
| | Hello Everyone, I am very new to VB and currently using VB Express 2008 to create a simple program. However, I am running into a syntax error on my update code. I have done some research on the web but cannot find a common thread. I am hoping some of … |
| | hey guys. here is a scenario: i have a form named frm1 and a variable in it [CODE] private x as integer = 0[/CODE] and another form called frm2 that needs to be able to make a local copy of "x" from frm1 and any changes made to "x" on …  |
| | Part of my code for an Update/Save button in a Binding Navigator is as below : [B]dsInventory.inv_itemsubcategory.Addinv_itemsubcategoryRow(Trim(CatCodeTextBox1.Text), CatItemDescTextBox1.Text)[/B] When I move my mouse to that line of code, there is a message that says : Overload resolution failed because no accesible 'Addinv_itemsubcategoryRow' accepts this number of arguments. Why is this … |
| | Dim strSql As String strSql = " Select * from quazatoknitting where yarn_recchno= '" & txtchno.Text & "'" Dim strSql1 As String 'strSql1 = " Select rec_qty from recfromknitting where yarn_recchno= '" & txtchno.Text & "'" Dim da As New SqlDataAdapter(strSql + strSql1, objconnection) Dim dt As New DataTable da.Fill(dt) … |
| | hello, I need to register a new Employee's Car , In my database , there are two tables ( Car_info , Emp_Info ) and I created a relation between them : (Car_info table) Column [B]Car_no [/B]As [B]Primary Key [/B] and (Emp_info table) Column [B] Car_no [/B]As [B]Foreign Key [/B]. [COLOR="Green"]This … |
| | Hi all Im loading list box with availabel datetime formats . but it is loading all the date time formats twice... here is my code: Dim dateTime As DateTime = New _ DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, _ Now.Minute, Now.Second) Dim d() As String = Nothing d = dateTime.GetDateTimeFormats() lstdateandtime.Items.AddRange(d) how … |
| | Hi all, I am facing some error on the database: I declare a field in my database as VARCHAR(50), and i try to modify it to INTEGER(50), However i get this: ERROR 1264 (22003): Out of range value adjusted for column 'MP1T' at row 2 And the field with data …  |
| | Em, how to convert a blank data to INTEGER? I use the code as shown below: [code] MP1T(hour, 0) = Convert.ToInt16(rs.Fields("MP1T").Value) [/code] but then the field MP1T is previously in VARCHAR format. It runs smoothly until it found out that the field is blank and cannot be converted. How can …  |
 | Pls all, i want to search for data using two tables e.g search for date where location = nigeria and state = lagos. i want it to search for only student from nigeria and state from lagos. pls how will i go about it. expecting response soon |
| | I want to display multiple records from multiple table in datagrid Please help me, How I will use the datagrid in vb.net |
| | Hi, I'd like to know the easiest method, using VB (2005) of sending a local file to a remote location using any file transfer protocol in particular, FTP perhaps. Would like to know the quickest way of achieving this. Does anyone have any code, third-party code suggestions? Thanks Stoneferry PS: … |
| | A form has several tabs on it. The tabs are Item Category Level 1, Item Category Level 2, Item Category Level 3, till Item Category Level 5 . Item Category Level 2 is the subcategory of Item Category Level 1, Item Category Level 3 is the subcategory for Item Category … |
| | I'm trying to add a row to my dataset using the following: [CODE] Dim foundRow As DataRow = DsMembers.Members.NewRow foundRow("FirstName") = scannedMember.FirstName foundRow("MiddleName") = scannedMember.MiddleName foundRow("LastName") = scannedMember.LastName foundRow("Address") = scannedMember.Address foundRow("City") = scannedMember.City foundRow("State") = scannedMember.State foundRow("Zip") = scannedMember.Zip foundRow("DOB") = scannedMember.DOB foundRow("TDL") = scannedMember.TDL foundRow("MemberID") = scannedMember.MemberID foundRow("DateJoined") … |
| | I want to display multiple tables record into datagrid (challan number wise). Please help me. how will i can use datagrid. |
 | Hi all... I got problem here.. I want to search how much a certain characters in words in text box. Please help me to solve this... |
| | Okay so I want to be able to click a button in Excel and have the sort dialogue box pop up. Everything I've read so far only explains how to automatically sort with a macro. I need a macro that just makes the box pop up for the data that … |
 | How can i detect mouse button clicked? does i have to use api function? |
 | help me to make a factorial function. Please help. any help will appreciated much... |
| | can any1 help me to connect my project to ms access database. i'm a newbie in vb.net. this is my code in vb6 to connect to the database can any1 help me to do it vb.net..hope sumbody can help me.. this is how i do it in vb 6 1. … |
 | Please help me i try to display all instances of SQL Server in a combobox. Any help is greatly appreciated. |
 | does anyone know how to run any app that it write some vbscript or javascript or html from in vb??? |
 | [code]SearchString = "SELECT * FROM Breakdown WHERE BFrom = " & txtFrom.Text ' & " AND BTo = " & txtTo.Text Dim Con As New OleDbConnection(BCalc_ConnectionString) Dim Search As New OleDbCommand(SelectSearchString, Con)[/code] I want to stop users from being able to save a duplicate record in my Access database. I … |
| | I need to implement a search function button to my project where you click an input button which asks you to input a ID number then displays the details of that record in a form. Thanks. |
| | Each time I start debugging my application in VB.net, I encounter this error. I couldn't go through the application any further. "The application failed to initialize properly (0xc0000005). Click on OK to terminate the application." :sad: What seems to be the problem? |
| | How can i actually detect the time as shown below? If the user select the data from the database between 2008/06/05 12:00:00 and 2008/06/06 12:00:00 and the database type is varchar? I can select that particular data out, but i need to further categorize it according to hours, like this: … |
| | This is my vB.NET assignment and i have no idea what it requires. I have not done this practical before b'cause the lecturer has not taught us about the joining the SQL in VB.NET and I'm seriously dont know how to do this......so i need help and pls do help … |
| | Hey, I'm looking for someone to design a really simple VB program for me. It's for a psychology project I am trying to complete, but it has been taking me forever to develop since I have ben having to learn VB from scratch on my own. I am willing to … |
The End.