c0deFr3aK

Im trying to display data in a datagrid then once a row is selected show a different column of the database in a text box. I use the unique primary key in the datagridview as not visible so once the row is selected, i can get that integer and populate …

hello there, anyone can help... is this possible? i have a string value of form names in my DB so when my condition passes, the variable string will take over the value , then that value will call the form(variable) as string. i got an error when i use this …

Hi Can you change the alignment of text ion a datagridview column programmatically ? i.e. Columns(0).?????????????????.MiddleCenter as I dont want to centre align all of the columns in the datagrid. Thanks Andrew

Hi guys, i am facing problem when i need to create an excel file and insert some data inside. Can anyone help me? i am using vs 2005 and excel 2003.

Hello, I have a newly created ASPX Website with Default.aspx and a Masterpage. on the master page i created a navigation menu i.e Home, News ect. then i created a folder inside the site and put some pages i.e page1.aspx. My problem is when im at page1.aspx (/mysite/folder1/page1.aspx) then hit …

Hello everyone, I'm trying to connect to a access 2007 database with VB 9 and am having some problems. I went to Data and then selected add new datasource. Then I clicked on database and selected Next. I click on new connection, change the datasource to access database file and …

Hi everybody please help me on how to code this in C#. I have an ASP.Net Web project and needs some C# code behind. Working some variables: In my VB.Net it looks like this: [CODE] Dim str1 as String Private Sub Button1_Click(...) str1 = "some text" 'This will be assigned …

Thought I'd share my code for populating the AutoCompleteCustomSource in a textbox with data from an Access table or other ODBC datasource. This works, though perhaps others have found a more elegant way. In this example, I am adding a list of city names. - Jeff Dim sStringColl As New …

Sir, I am using front end as a VB.net 2005 and I am a beginner in this language. I am creating Desktop application and using controls TAB controls 1st tab control is Contact in contact I am using one text box, two button and one datagrid while I am using …

Hello all, I would like to make the Tab movement can also pressing the "Enter" Key. I have google and found the code which possible to used. But I found its not running fine with me. When I press "Enter" key,it runs fine for the tab movement. But if I …

hullo frenz, i am designing an employee database. the records are displayed on a master (emp.vb) form whereas the search button is on a seaparate form(emp_search.vb). hw do i code the search button on the 'emp_search.vb' page so that this form closes automatically and den the records are displayed on …

Hello i got trouble to add data i got error saying: OleDbException was unhandled here's the code: [code=vb.net]Private Sub cmdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdd.Click Dim com As New OleDbCommand com.Connection = con com.CommandText = "insert into Watches values(" & txtWatchId.Text & ",'" & txtWatchBrand.Text & …

Ok, I am pretty new to Visual Basic 2005. I am taking a course in it and we are creating a Department Store program right now. I pretty much have 90% of the program done, its just that when I try and move information as strings (name, province, postal code, …

Hi guys, One form1 I have 2 command buttons - Add new record and other to view/edit existing record (the user can enter record id and click view/edit existing record button). If the user clicks Add new record, the user is taken to the next screen where the record id …

I am using datagridview in vb.net 2.0 I want to execute 2 queries. in the first query --- 1. Can anyone tell how to check that whether the query is fetching records from the database or not.Like i want to put a condition that if query is returning record then …

I'm trying to calculate a column from a database called rogaine.mdb. I've been using an SQL statement to do this as I only want to calculate the points for certain teams. This is the code I've been using: Dim teams As DataTable Dim da As OleDb.OleDbDataAdapter Dim sql, connStr, teamName …

Hi, How to connect visual basic program with mysql database?I need a sample program of retrieving the data and also inserting the data into the table using mysql database..........I dont have any idea..... please help me ....... Regards, Santhanalakshmi.

Hello, i'm making a small little app that pings all ips on a network from 192.168.0.1 to 192.168.0.255 and populates the active IPs into a listbox. Then from there i want you to be able to select one to look up the machines name on the LAN. [CODE] Private Sub …

Hello, I am using OLEDBConnection and OLEDBDataAdapter and connected to the MS-Access database. how can i add the textbox value to the table in database on a button click and want to display it in datagridview??

Hi im very new to all this programing lark but was wondering if some one could tell me what im doing wrong, I am tring to creat a login box so you have to enter the corect details to use my form but it keeps filling in the textboxes with …

Hello, I need to autocomplete for a textbox. If i type 'a" in textbox means, it must show the dropdown list showing all words starting with a. Like that for all the alphabets. It must show the words based on the user typed words before. Suppose when the user first …

Hi All, I'm very new to VB, and I've been working a project for a class for a while. I'm trying to link totals from three different forms to a final form, but I'm getting stuck w/my coding. Someone suggested that I use the first form to set up the …

[code]Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As String = "Provider=Microsoft.Jet.OLEDB.12.0;Data Source=G:\Visual Studio Projects\test\dbtest.accdb;Persist Security Info=False" Dim cmd As String = "SELECT * FROM Table1" Dim adapter As New OleDbDataAdapter(cmd, conn) Dim topics As New DataSet("Table1") …

I have attached my question. I am having some problems with the attached question. Well here is my code: Dim Name As String Name = TextBox1.Text If Name = TextBox1.Text And radLT20.Checked = True Then txtDisplay.Text = "Name is aged below 20" ElseIf Name = TextBox1.Text And rad20To40.Checked = True …

I am connecting an access mdb format and cannot display the values from the database table onto a form in vb . I need also to enter values to the same database. I appreciate any help anyone can provide as I am new to all this. I did the same …

I am developing a project in which i have combobox in that there are list of station and i want that when i type the words that will match to that station and that station is selected in combo box

Hello Frens, I tried to update change made in database shown DataGridView1 of Visual Studio 2008 with the following codes. But an error message comes as "Object reference not set to an instance of an object". Public Class Form1 Dim cmd As Odbc.OdbcCommand Dim adp As Odbc.OdbcDataAdapter Private Sub Form1_Load(ByVal …

I want to update data using DataGridView in Visual Studio2008 with the following code. But it is not working. Plz help me. Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click cmd = New Odbc.OdbcCommand("UPDATE Table1 SET Name") Me.Table1TableAdapter.Update(DataSet1.Table1) MsgBox("Updated") End Sub

help please, how to save a data between the time of what user input in the 2 textbox. 1 textbox is for intime and the 2 one is out time. for example if the user input 7:30 - 9:30 Am Intime all i want is this is the only time …

ok i understand some basics of vb but am still relatively a new... my problem.. code is for saving values into a database and displaying on the same form on a datagrid which is connected to the database... Imports System.Data.OleDb Public Class Addbooking Inherits System.Windows.Forms.Form Public cN As OleDbConnection Public …