20,278 Topics
| |
hi can anyone tell me how do i put load linq query into datatable then populate into datagridview? my codes are as follows: Dim dt As New DataTable '' Create 3 typed columns in the DataTable. dt.Columns.Add("ConflictingPaper", GetType(String)) dt.Columns.Add("Numberofstudents", GetType(String)) dt.Columns.Add("AdminNo", GetType(String)) 'Dim query1 = (From a In dt3 Group … | |
Private Sub btnload_Click(sender As Object, e As EventArgs) Handles btnload.Click Dim sqlquery As String = "select frmStudentReg.regno,nursery.rollno,[nursery.nepali(writing)],[nursery.nepali(oral)],[nursery.maths(writing1)],[nursery.maths(oral)],[nursery.maths(writing2)],[nursery.english(writing)],[nursery.english(oral)],[nursery.physical_edu(oral)],[nursery.creative(oral)] from frmStudentReg,nursery where frmStudentReg.regno=nursery.regno" Dim sqlcommand As New OleDbCommand Dim sqladapter As New OleDbDataAdapter Dim table As New DataTable With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With With sqladapter .SelectCommand … | |
How can I get data in a datagridview and put it in a textbox ?? "using .accdb file format" .. T.T please answer me | |
this code in form load event... Dim sqlquery As String = "select * from frmStudentReg" Dim sqlcommand As New OleDbCommand Dim sqladapter As New OleDbDataAdapter Dim table As New DataTable With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With With sqladapter .SelectCommand = sqlcommand .Fill(table) End With For … | |
I need to get the sum of two numbers but i do not know how example > **what the result should be:** 1,000,000 + 2,000 = 1,002,000 > **my code's result:** 1,000,000 + 2,000 = 3 > It seems that my code only adds the numbers before comma (,) My … | |
Hi all I have a Products table which has a description and a size column the description is a string value and the size has a double value. What I need to do is after reading the data it converts the decimals value of the size column into a fraction. … | |
| I have a VB project that allows a user to create folders and projects on the network. How would I deploy this to the users computer so that they can run it without needing to have Visual Studio installed? |
I want to format certain columns to allow only a certain number of numbers like you can only input number 0-7 and if not a message box shows up.. can someone lead me in the right direction | |
I am currently working with a website that is very difficult to navigate and you have to open up multiple tabs. I have no access to the website or the database. Just seeing if I could perhaps query through the website to bring up the info on my application. | |
I am a college student developing a local chat application using VB.Net and SQL 2005. I have multiple clients connected to a server via local ip. My first problem is, how will I know which users are online. Each user has their own username and password in order for them … | |
Dim connect As String connect = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & Application.StartupPath & "\segdata.accdb" Dim conn As New OleDbConnection(connect) Dim sr As System.IO.StreamReader Dim entirefile As String sr = File.OpenText(Application.StartupPath & "\SEG1.txt") entirefile = sr.ReadToEnd() ' Read the whole file Dim OriginalValue As String OriginalValue = vbTab Dim ReplaceValue As String … | |
I want my code to affect column 5 and 6 to, but everytime i add it i get an error this is wat i have so far Private Sub DataGridView1_CellEndEdit(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEndEdit If (e.ColumnIndex = 4) Then ' Checking numeric value for Column4 … | |
Hello, Please any one to guide me through. was a VB 6.0 programmer 3 years ago. Now I want to use Vb.net how to I migrate/upgrade my projects to VB2008 | |
Hi all! i have a problem from my program in vb when i click the delete button.... EXAMPLE : |QTY| NAME |PRICE 2 1st FOOD 250 1 2nd FOOD 150 TOTAL AMOUNT IN TEXTBOX >>>>> 400 >>>>>>>DELETE BUTTON<<<<<<<<< then when i click 1st food and click delete button THIS IS … | |
I need to show the values in my datagridview as currency, I can do the currency format but that uses my default system currency. I load projects that are in many different currencies, at the moment I have it as 1,000.00 and I look at currency name I set up … | |
| Hello everyone, I'm a making a BAT file creator and I can't find a way to add a 'Test' feature (open without saving) This is the code I tried using: Shell("command.Text") *Doesn't shell start DOS? command.text=that's where users wrtie a code Can someone give me a working code on how … |
Hi , I am able to add Label, button,texboxes into Dictionary. However I am getting problem to add values of Combobox into dictionary. Here is how I was trying to do. Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Try Dim myLabel As Label Dim myButton As Button … | |
Probably already know the answer to this problem, but perhaps i am wrong. My datagrid is being sorted by Id which is Autonumber. So if i add a new entry its added at the bottom of the list. Is there any way to change the sorting to a different nummeric … | |
how can i parse files from notepad and transfer it to textbox with delimiter of newline? | |
While going through the Publishing process, I'm encountering some odd behaviur. I select my path to publish as my desktop of the computer I'm writing the code on: C:\Users\RossS1\Desktop\ In the next window, I select "no web updates" Next it gives me a "read only" window with a web-like path: … | |
I would like some one to help me how I can generate reports through vbnet 2010 but related to the database that I have in access 2007, I wish to make report that will require to select some columns of different tables for better making the repots. I have another … | |
I am beginner for Vb.Net, My project used some external files (Ex. Word, Excel, PDF, and JPG). Where should I copy these files..? in Same folder Project already saved (D:\TTC) or not. If different path, what is it. (Ex, When I click Button1, Names.docx file must be opened) I want … | |
Hello, help me please. I have a db sample ( http://i.imgur.com/JRZ2ojP.png ) I have 1 combobox and 1 textbox If the combobox select "Notebook" then on the textbox it must be display the corresponding itemStock (3) Please :( By the this my simple code for my combobox Try Query = … | |
I have a login form that asks for credentials for access to select areas of a large app I wrote. I am trying to add a form to allow for password changes via that app instead of me having to update the SQL DB manually. DB has 1 table called … | |
Hi all, I am pretty new to VB.NET programming, and I am having trouble with a few tasks I am trying to attempt. Firstly, I have to (using Visual Studio 2010) access an MS Access databse, read one of the tables and ouput the 10 numbers which occurred most often … | |
I need to to this: If the selected option / item is "Enabled" I want to preview a textbox. I've tried this: If ComboBox6.SelectedItem = "Enabled" Then TextBox10.Visible = True Else TextBox10.Visible = False End If And also this: If ComboBox6.Text = "Enabled" Then TextBox10.Visible = True Else TextBox10.Visible = … | |
I'm trying to make a program that has a world map on it and when you click on a continent you get some basic information about that continent in a textbox. However I am trying to figure out how best to do this if all continents were perfectly square it … | |
What are the additional features can be added to the web browser which is developed in visual basic | |
i really need a quick help with my code. when i debug the program no matter what the numbers in milage and Rate are the result is always 0 and here is my code: Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click Dim … | |
hi frnds, i have a window based datagridview with examdate as one the editable datetime column .Now i want user to update or change the date to a fully valid format(dd:mm:yyyy) just on pressing enter key within the datagridview. A popup message must appear when user enter wrong date. Any … |
The End.