20,284 Topics
| |
hi, I have a form and a button on that form.When the user clicks on the button an MS-Excel sheet is generated from MS-Sql Server 2005 and saved in a particular location.As this generation of excel tkes sometime to complete,what i want to do is i want to show a … | |
Hello, i need help to do the insert inside repeater, but when i debug the stock_code inside sql command is not declared. what should i do? [CODE] Protected Sub repeaterAlert_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles repeaterAlert.ItemDataBound Try stockCodeheader.Text = " Stock Code " plcNameheader.Text = " PLC … | |
Hi all I have a situation, i have a form that has a datagridview, on form load, it selects the data from sql db, now what i want is when i right click on one row, i should be able to delete that row and it should also get deleted … | |
Hi, I am trying to get the value from a field in my Access DB.Once the value is retrieved I need to be able to compare it to a condition I set. I still haven't figured out the right code to make this happen....i don't know if I should convert … | |
Private Sub ComboBox6_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox6.SelectedIndexChanged con = New SqlConnection("Data Source=DEW-D63D9D2D032\SQLEXPRESS;Initial Catalog=system1;Integrated Security=True") con.Open() sql = "Select Faculty_Id From Faculty where Faculty_Name='" + ComboBox6.SelectedItem.ToString() + "'" cmd = New SqlCommand(sql, con) rdr = cmd.ExecuteReader() While (rdr.Read()) fid = rdr.GetInt32(0) End While con.Close() MsgBox(fid) con1 … | |
Hello, i have just a simple question. Is there a way to select the next item in a listview by pressing a button? I have been using listbox for along time now and its pretty easy to do there [CODE]ListBox1.SelectedIndex = ListBox1.SelectedIndex + 1[/CODE], any idea how to do it … | |
I want to calculate the average of a column or rows of project #1, project #2, etc.... and Adding a new column with the grade of the students ....like the picture.. Im new using visual basic. Thanks in advance. =D [img]http://i41.tinypic.com/5z1xi.png[/img] | |
Hi, I want to Display My Table Data In Textbox I Have around 20 columns in my Table and I want to display each of that on particular TextBox. How Can I Do this ? I am using SQL Server as Database. Please Give me code for this Thank You | |
Hi, I have my application in VS2008 and coded Vb.net. My query is i want to save record from an excel sheet to my Database Table. But i dont want to insert the Excel sheet as a whole rather i want to insert the record in my database table Row … | |
i want to dynamically add the values in the column of a datagridview the row of which is also being created dynamically... [CODE]Form1.TextBox10.Text = total con.Open() cmd = New SqlClient.SqlCommand("select product,Quantity,MRP,Sale_Rate,Disc_Amt,Amt from sale_table ", con) adapter.SelectCommand = cmd adapter.Fill(ds) Dim r As Integer = ds.Tables(0).Rows.Count Dim counter As New Integer … | |
hh.. how can i get the value accumulated from the date i select from datetimepicker1 to datetimepicker2 in vb.net and mysql? the value here refers to the daily sales and i need to find the total sales between the range dates that i choose.. please help me..as im beginner and … | |
[CODE] Public Class aaMyForm Inherits Windows.Forms.Form [/CODE] Added some controls. Build it, add the .DLL as reference to my other project. In my other project: [CODE] Imports MyLib Public Class XForm Inherits aaMyForm [/CODE] The events from aaMyForm execute correctly but the controls added to it are not shown on … | |
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strsql = "delete from student_info where Student_No = " & ctrl & "" Dim sqlcmd As New SqlClient.SqlCommand sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqlcmd.ExecuteNonQuery() MsgBox("Student Deleted") Me.fillclasslist() When I try to delete a student in the list … | |
Hey Guys, I Want to Display Content of Database Into TextBox, i.e. i have column named "Ename" in "EMP" table of database1 , now i want to display "Ename" in TextBox of my form , so, how can i do this ? Thanks In Advance | |
I was wondering if there is a code i could add to my applicatio that will delete a data entry from a database. I'm designing a voting application as my project and i want a situation where an access code is good for only one entry. i put my code … | |
Hello By accident I named a report like a form that i already had example: Form Name: CheckIn Report Name: CheckIn And know I cant use the form, anyone know how to get back the code from that form Thanks In Advance! | |
i know crystal reports can access data stored database.. what I want is actually to create a report on the basis of a listview values..no database at all. how do I pass these listview items and subitems to crystal reports... please help guys.. | |
How can I add the prerequisite for Crystal Reports Redistributable . I only see Crystal Report Runtime on there. I used to have VS2008 and it was available as a prerequisite. BTW I have already installed CRfoVS_13 to the IDE. | |
Hi all, I have a datagridview in which I add programatically a combobox column with its datasource set to a datatable I fill from a query, then I populate manually (for good reasons) the DGV, but just when I try to add the first row, this error shows up: Fielld … | |
I'm just wondering guys if it is possible for me to go to the specified listbox item via searching. Example; Listbox1 items are Apple Banana Guava Pineapple Peach When I key in the word Apple in a textbox, the SelectedItem would go to Apple, is this possible? | |
Guys is it possible that I create a program whose functionality would be selecting a file, then gets the contents of that file (Word or text files). The program, of course, has a Richtextbox on it where the file content will be filled to. If it is, could anyone please … | |
I'm trying to make a form in VB.Net that takes speech input (not text-to-speech) on my Windows XP Pro computer. I've tried to install Microsoft Speech SDK 5.1 according to [URL="http://support.microsoft.com/kb/306537"]http://support.microsoft.com/kb/306537[/URL]. The problem is my Office 2007 does not have an Alternative User Input feature, as it says in the … | |
Hi, I have my application in VS2008 and coded Vb.net. My query is i want to save record from an excel sheet to my Database Table. But i dont want to insert the Excel sheet as a whole rather i want to insert the record in my database table Row … | |
A new issue !! I have a checkbox column in the datagridview and also a column named "partqty" which displays the quantity of materails available.. I would want that when the user checks on the checkbox, the quantities of checked rows should be added and displayed in the textbox.. I … | |
Hello !! I am stuck with an issue and need some guidance.. I am using visual studio 2008, vb.net Windows app and ms access 2003. I just wanted to know that there is a form in which i select an option from the list of options in combobox.. While the … | |
Hi again !! I am making a widows application wherein i have a form containing two datagridviews.. The first one( named dgv1) consists of all the data from the database and a checkbox column.. While the user selects the rows using checkbox, the data are displayed in adjoining datagridview(named dgv3).. … | |
Hi there, I need help regards to my sql statement. I am developing a system using vb.net but now i'm having trouble to insert all the data (where i bind using repeater control) into the sql statement. I didn't know how to declare the stockcode.Text, year.Text, quarter.Text and total1.text as … | |
I have to create a form that I enter the price of gas each month over a year. I enter the price in a text box and click the enter button to send the price to a list box immediatley and use an array. I have the following code but … | |
guys, it's been a long while since the last I asked about this and so far, no one yet has ever given me the right and helpful answer. My problem is, I have a program, I have published it, and I have been actually using it in my PC. Whenever … | |
Using VB Express 2010 in windows XP Pro 64. A ListBox shows the project forms names. On ListBox_DoubleClick [CODE] For Each F As Form In xFormCollection If F.Name = ListBox.SelectedItem.ToString Then Try F.Show() Catch ex As Exception MsgBox(ex.Message) End Try End If Next [/CODE] Works fine the first time but … |
The End.