20,284 Topics
| |
Hi I want to use an id reference that had just been created in a different table I have an insert query that adds a new user to the users table the t_id is auto generated I want to use the t_id value in a new query that runs after … | |
I am running a stored procedure and presenting the data back to users in a simple datagridview. I'm unable to figure out a way to filter my data through the SQL side, so I wanted to see if I could filter data through the datagridview. Basically my sql query returns … | |
for example i have 2000 picture box and i have a array the lenght of 2000. and my picturebox names is like pb1,pb2 .... pb1999, pb2000 so if my arrays 1393th item is not null i want to change 1393th pictureboxs color. is there any easy way? i know i … | |
[CODE]newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"[/CODE] I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ; | |
Hi I am trying to submit a date value from a DateTimePicker1 using short date format 05/02/2011 I get an error on submission .NetSqlClient Data Provider:conversion failed when converting date and/or time from charecter to string this is my insert [CODE]cmd1 = conn.CreateCommand cmd1.CommandText = "INSERT INTO tenant(firstName, lastName, Email, … | |
Here is, basically, how my application works: When windows starts, my app starts. Whenever my app is running, it hides the desktop, taskbar, etc... When a button is clicked in my application ("Start program"), then my application will set its visible property at false and another application will start. Everything … | |
k we're working on a billing system Currently I am working on the categories module. Here's the thing: I need a dynamically changing UI. So the user can add categories, delete them and teh UI would accordingly add or remove controls automatically. I used DataGridView, but since the fetching and … | |
Hello, How to reset the properties of the form as well as all of the control properties values when i click a button. Thanks in advanced.. | |
Hi, Actually I don't know if my question belongs in this topic or in the VB.net topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I … | |
is there any code for opening a file without using any dialogbox? directly | |
Hello all, Im currently doing a project which is a system that adds booking records to it it loads the database from a module [CODE]Set Db = OpenDatabase(App.Path & "\cihansol.mdb") Set RS_Staff = Db.OpenRecordset("EPHS_Staff") Set RS_Customers = Db.OpenRecordset("EPHS_Customers")[/CODE] im very new to visual basic so i dont know much anyway … | |
Hi all, I want to create code to delete row in datagridview based on checkBox selection. I've managed added the checkBox Button using code below: private void FormTampil_Load(object sender, EventArgs e) { DataGridViewCheckBoxColumn checkboxColumn = new DataGridViewCheckBoxColumn(); checkboxColumn.Width = 30; checkboxColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns.Insert(0, checkboxColumn); // add checkbox header Rectangle … | |
help please..help me in my timer like the time they use in computer shop and when the player is already time out it will alert...[COLOR="red"]the idea like this if the player start 3:00:00 then it will appear in the textbox for the time - in and in the time - … | |
[CODE]Dim line(10000) As String Dim log_ctr As Integer Open App.Path & "\data\log.txt" For Input Lock Read As #1 Do Until EOF(1) Line Input #1, line(log_ctr) log_ctr = log_ctr + 1 Loop Close #1 If last_log <> log_ctr Then For n = last_log To log_ctr - 1 Text1.SelStart = Len(Text1.Text) Text1.SelText … | |
Not quite sure if im in the right section but lets try ... In my project i want to use a "Local Database Cache" and sync it with my online MYSQL server. Problem here is, the MySQL data-provider is not showing up when doing the wizzard for the Server/Client properties. … | |
Can anyone tell me how to auto load data content from a file (primarily containing rtf) when the file is opened. I want to create a system like Microsoft word where you create docx/doc files and double clicking them opens word software and loads the files. I know file associations … | |
i have a generic list of type datarow. i have to split this list at an index and then use both parts of the list. Eg: list = 1,2,3,4,5 i want to split it at index= 2 i.e at value =3 . then list1=1,2,3 and list2=4,5 how can i do … | |
Hi i have problem with my timer. when application run it does not go to the timer at all.I have no idea where do i need to troubleshot anymore. Please help if anyone know ! [CODE] If CheckStatusStr = "0" Then Update_CurrBal() SuccessfullySave() ElseIf CheckStatusStr = "1" Then timercount = … | |
[COLOR=#008000]command.Parameters.AddWithValue("@number", TextBox1.Text) can i do this from another way? [/COLOR] | |
MS strikes again. In my tiny little mind this should be a no brainer but I just don't see how to make this work. I have an unbound DataGridView control where I have defined the columns at design time. Currently to add a new row I use a like this: … | |
Hi All, I have a requirement to create n Access 2007 database & some related tables from my application at runtime. I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010. Any pointers would be gratefully accepted. Thanks Charles | |
Hi, I have a collection of (String, Integer). I have taken it into a String() Array and then added to a List(Of String()). I then need to find the duplicates in this list and if found, then add up the corresponding integers. How do I do this? Am I using … | |
Hello guys, I have been thinking if I can develop my personal application using my VB 2008 IDE. I have created different software but all of those are only for PCs. How about for phones, is it possible? If yes, how? | |
Dear Friends How can i convert file into its hex in vb.net or any programming language??? | |
Well my datagrid so far has the edit,update,cancel feature and it can get info back from database after entering a number into a textbox. All i need now is to get it to where I enter a number the data comes up which works and I want a blank row … | |
hi guys i have problem with my code here is my code [CODE] Public Sub increment() Dim dr As SqlDataReader If con.State = ConnectionState.Closed Then con.ConnectionString = (strconnection) con.Open() End If Dim str As String = "Select CUSTOMERID from tbl_Customer" cmd = New SqlCommand(str, objconnection) dr = cmd.ExecuteReader While (dr.Read()) … | |
i have a datagrid and want to format the cell background colours which is working fine. as you can see if the value of the cell is > 95 the cell goes green if the cell value is < 90 the cell goes red. i need help with anything between … | |
I am writing an application that pastes unformatted text into various fields in an application called cerner. Cerner runs via a VPN that is setup by Citrix software (I think). All the cerner applications seem to run under the same windows process. Does anyone know of a good resource online … | |
What happens if a value from hex editor is deleted but not modified ... Friendz plz help | |
I am working on something for school as a final project before graduation. I am using ASP for the website and VB as the back end to code. I keep getting the error "Object reference not set to an instance of an object" and can't figure out what is wrong. … |
The End.