20,278 Topics
| |
Dear Experts Please modify UPDATE codes according to INSERT codes Style. 'Insert Codes [CODE] Dim cmd As New SqlClient.SqlCommand("Insert Into employees (sno,Name, city, phone,img) Values (@sno,@Name, @city,@phone, @img)", con) cmd.Parameters.Add(New SqlClient.SqlParameter("@sno", SqlDbType.Int)).Value = Val(Me.TextBox1.Text) cmd.Parameters.Add(New SqlClient.SqlParameter("@name", SqlDbType.VarChar)).Value = Trim(Me.TextBox2.Text) cmd.Parameters.Add(New SqlClient.SqlParameter("@city", SqlDbType.VarChar)).Value = Trim(Me.TextBox3.Text) cmd.Parameters.Add(New SqlClient.SqlParameter("@phone", SqlDbType.VarChar)).Value = Trim(Me.TextBox4.Text) cmd.Parameters.Add(New … | |
Hello, I've got a problem. I created a DataGridView, where a DataTable is it's DataSource. There is a column named "Age" i this DataGridView. It's format is string as I accept the value "unknown". The problem occurs when i try to sort it. After descending sorting the rows where "Age" … | |
Hello- I'm using VB.NET (visual studio) to create a chatbot (a program that mimics a human and has a text converstion with you). Two of my main classes are a word class and a sentence class. The sentence object is basically going to be a linked list of words objects. … | |
I'm trying to use the timer (not a Timer object) in a Do... Until loop. I want the loop to put a single variable into a label. When I do this it works and puts the value into the label (lblOxygenReading): [CODE] If btnGetOxygen.Text = "Get Oxygen Reading" Then Select … | |
I have Visual Basic 8.0 and Use Mysql 5.0 Database Table Test: Field type ID Integer (PRIMARY KEY) Name Char(10) Adress Char(15) City Char(15) ID Name Adress City 1 Andre Street 1 New York 2 John Street 2 Amsterdam 3. Joyce Street 3 Londen I have create a index on … | |
Hi, My project works fine with windows xp but when we run it in windows 7 some fields are becoming black as shown in the attachemnt Could anyone let me know the reason for that? It happens with some controls Thanks | |
I want to make something to read the text/strings sent to a server and maybe detect if the server is crashed or not and something to and some thing to send text/strings to a server maybe using winsock P.S. I also want to make something to crash my server. | |
Dear Sir, How to detect picture has a picture on empty? Suppose , I droped a picturebox control on form, there is no image loaded in it, what codes should I needed those will tell me that picturebox is empty? Please help | |
hi all, i have a program that change the look of the taskbar. But i have a problem, i want to set the start button position to the middle of the taskbar but can't find any code to do this. I know that its possible because there are some programs … | |
Can someone with LATE BINDING idea help me out in my VB.NET Project. Im working on an MDI (multople Doc Interface) project with some toolstrip buttons on my parent form (my menu form) from where I need to call some public procedures (like DELETEREC, UPDATEREC, CloseForm and so on) on … | |
i'm a beginner in vb.net i just want to know if it is possible to store the formatting of a text to ms sql so that the next time i retrieve a record that i've already formatted, it will display the format that i did for that record. if possible, … | |
I have six textboxes, and upon button press it randomly generates six numbers, one in eact text box e.g. [43] [85] [93] [1] [0] [17] Question: i create another six textboxes and at the same time allocate these numbers in ascending/descending numbers. [B]I am not looking for any codes whatsoever[/B], … | |
Hi All, In my VB.Net app, I want to read in a load of addresses from a database and then use word to create address labels on an Avery template L7163 which is then printed to the printer. However, I have two issues: 1. Before word prints, I'm asked to … | |
[CODE]Private sub button1_click( ) Data Set Dim ds as new dataset Ds = new dataset(“student”) Connectionstring Dim connectionstring as string = “provider =Microsoft.jet.oledb.4.0;data source = student”; Dim connection1 as oledb.oledbconnection = new oledb.oledbconnection(connectionstring) Command object Dim command1 as oledb.oledbcommand = new oledb.oledbcommand(“select * from student”) Command1.commandtype = command.text Connection1.open() Comand1.connection … | |
Hi, You probably got annoyed when you read the title, it must have been asked a million times. But unfortunatly I cant get it working for myself. Ive been using this code to highlight the word "var": [CODE]Dim search As String = "var" Dim index As Integer = RichTextBox1.Text.IndexOf(search) If … | |
I was wondering how such interface designs can be achieved? [url]http://img130.imageshack.us/img130/1286/49282415.jpg[/url] [url]http://img697.imageshack.us/img697/5835/11728532.jpg[/url] First image has the stylish tab control design and border. Second has a "dropdown" on each tab button. | |
Hi all, I'm pretty new to VB.net, having only recently migrated from VB5(!). I'd appreciate any help at all with the following problem that I have on a project; I'm reading data in from a comma-separated text file and storing the data in an array for later use. Some of … | |
Hi all, I hope someone can help me with this because it's driving me insane. I've spent almost two solid days trying to figure this out without much success. What I need to do is load in an XML file (which I have working fine) but then I need to … | |
im using : v.s 2003 sql server: 2000 [B]im creating this vb application and i took a coding from the inter net which uses 2005 i only have one error that is it's not supported in v.s 2003 can some one help me how to solve this my problem occurs … | |
Hi There, I am developing VB.NET 2003 window application having problem with the FORM KEYDOWN event. Problem with cancelling the keydown event when the data check function return FALSE due to duplicate Debtor ID. How to cancel the KeyDown [CODE][B]Private Sub FrmDebtor_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles … | |
is there a way to start your program from the sub main() like you could with vb.net | |
hello ppl, I need your small help regarding my approach.. Coding in :- VB.net database:- Mssql2005 I have an web application(Changepoint a tool for project management) whose database is in mssql they have provided us the web service API's by which we can load the data into their database. e.x. … | |
Dear Experts I use following codes to diplay data in combobox str = "SELECT sno,name,city FROM employees" cmd = New SqlClient.SqlCommand(str, con) da = New SqlClient.SqlDataAdapter(cmd) dt = New DataTable da.Fill(dt) With ComboBox1 .DataSource = dt .DisplayMember = "name" .ValueMember = "sno" .SelectedIndex = 0 End With Table has three … | |
I have a component which hooks up with the paint event of assigned control and draws on its surface, Whenever i make any changes to the component i need to resize the form or control at design time in order to see the changes. I want to ask if there … | |
I been at this for to long so I will give somebody else a shot at this. I have a text box that has a string in it that I will use for a SQL statement. Under the text box I have two trackbar controls. I want to be able … | |
Dear Experts Table "employees" has four fields as sno---name---city-----photo 1------a-----london---- 2------b----Tehran---- 3------c-----dublin---- I use following codes to pickup employees pictures, How to store photos into table "employees" column photo. [code] Dim OpenFileDialog1 As New System.Windows.Forms.OpenFileDialog Dim pic As Image Dim retVal As DialogResult Dim bExOccured As Boolean Try OpenFileDialog1.Multiselect = … | |
Dear Experts I have two textboxes I want textbox1 to accept any character except 0 (zero) When user enter 0 then it must not go to next control I want textbox2 only accpet character "Y" or "N" Please help | |
A datagridview control that bounds to ms access database. I am adding more rows to gridview control. How can i save these data to database? Any help would be greatly appreciated.. Thanks, | |
What I'm designing is a user control who's purpose is to gather a list of records from a SQL database based on criteria selected on the control and then transmit this list to various other systems or devices. To accomplish this I've defined a .Net interface which each endpoint having … | |
Hi experts, I am a student working on a project for my company. I work using Microsoft Visual Studio 2005. Language is vb.net. I also work using windows application. I have a form(EmailContacts) which contains a datagridview and a button to add the data to a textbox of another form. … |
The End.