Im trying to change the information on each row depending on the result from the query. Im thinking that at the minute my problem is that I'm only returning the first result from the query into the result.
e.g. query returns row 1 with '1232' row 2 '1243' but result is only ever set to '1232'
I have a query which is pulling values from a table in MS Access
SELECT
tblInstructor.InstructorID,
tblInstructor.Football AS InstructorRole,
[code].....
i have 2 tables assignment and feedback, in a gridview it displays all the assignments, the assignments then get feedback. im then wanting to change the view feedback button in the gridview depending on if there is new feedback for example:the feedback table has a state field in it so when its 1 i want that image button to change to the one with the +
View 1 RepliesThis is just an efficiency question really.. I'm interested to know if there is a more efficient or logical way that people use to handle this sort of scenario.
In my asp.net application I am running a script to generate a new project my code at the top level looks like this:
Dim ok As Boolean = True
ok = createFolderStructure()
If ok Then ok = createMDB()
[Code]....
I create a boolean and each function returns a boolean result, the next function in this chain will only run if the previous one was successful. I do this because an asp.net application will continue to run through the page life cycle unless there is an unhandled exception and I don't want my whole application to be screwed up if something in the chain goes wrong (there is a lot of copying and deleting of files etc.. in this example).
I have a small section of a windows form that allows users to select when a customer should be called (i.e. day of the week, time and inbound or outbound)When the form is loaded I will extract the information using a dataset and bind to form controls. I want to use a combo box for call stautus - inbound or outbound - however wish to give the user the choice at runtime.My thoughts are I would need to set a static list (so the user could choose) and set the default or displayed value to the info the dataset has extracted.This code to select the index doesnt work when I am comparing the dataset result to the "Outbound" string even though I am using the ToString method.
Private Sub TestTelesalesForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.Telesales_DEV004016TableAdapter1.Fill(TelesalesDataset1.Telesales_DEV004016)
Me.comboCallStatus.Items.Add("Outbound")
[code]....
I have an application that i am writing that polls machines every 40ms and depending on the result of the poll sometype of action is taken. i have each machine that is polled run in a separte thread. this all works fine.
what i want to add to it is to use a timer and either on a tick or elapsed time fire inside of each thread at lets say a 1 minute interval to update a file with stats about each thread and the machine it is connect to. for example below if a start polling 3 machines on com1 2 and 3 and poll them. machine 1 may have 102 copies machine 2 200 copies and machine 3 400 copies. i want a timer theat ticks every 1 minute that will fire within each thread and record those results
[Code]...
Hey, Just trying to loop through my gridview and change the color of the row if the first cell equals a given value. This is the code I am trying but does not work.
vb
With gvItemList
For i = 1 To .Rows.Count - 1
If .Rows(i).Cells.Item(0).ToString = stValue Then
.Rows(i).BackColor = Drawing.Color.CadetBlue
End If
[Code]...
I am working on Treeview control and Gridview Control VB.NET08. In the Treeview i have Parent and Child Nodes. Like:
- 31
3101
3102
[Code].....
I am working on Treeview control and Gridview Control VB.NET08. In the Treeview i have Parent and Child Nodes. Like: [Code] Comparing the Parent Node text and first two digits in the Column values. I want to add rows inbetween the gridview rows based on the parent and Child Nodes. If i expand the First Parent Node Called "31" then according to the Number of Child Nodes (for first parent node(31) there are 5 child nodes.) add rows in the gridview.
These New rows should be add under the 31-xxxx. If i expand the 32 Parent Node based on number of Child Nodes, add rows under the 32-xxxx. [Code] I am getting the rows in the end of the Gridrow not in the Specific row.
I am currently using DevExpress 10.2 within Visual Studio 2010. In a previous question I was trying to print the current user view of a DevExpress GridControl with the user's choice of expanded or collapsed master rows and/or group sections. I was told this was not possible at this time. I have now decided to use the following code:
[Code]...
I am creating a WEB report in Visual Studio 2010 in VB.net. The report needs to display a table (please see the attached image). I am thinking to use the GridView component which i think it's the most appropriate one to choose. In the database there are students' data and marks. I can't alter the database in any way and i have to use Visual Studio 2010 with VB.
What i need to do is to show 3 different pictures(for example) depend on the student's marks. I got the pictures file in PNGs but this can be flexible.For example, over 70 will be a Smile picture. over 60 will be the Normal face. and over 40 will be the picture with no smile. I bit difficult for me to explain but i hope u get my point.
So pls advice me how can i achieve this. I am quite a newbie to this pls put as detail as you can. if there is a choice between client and server side script, i prefer server side script. Data source can be flexible (sql, or linq or anything).
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
I have a datagridview created for my windows app in 2005 and I'm not sure how to get it to grow and shrink, depending on the number of rows that are displayed. The form contains several filters for the user to use in order to get their desired recordset displayed in the grid and therefore, the size of the grid will be constantly changing. How is this usually handled?
View 10 RepliesI need to write a method in C# to save all rows in a given datatable back to the database, but I cannot depend on the rowstate of each row. I can't think of how best to do this without extensive looping through the database table data or constant database querying.
I want to essentially perform the following insert / update for each row in the datatable, but more efficiently:
[Code]...
I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
VB code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
I want to display the result of this row a & " " & b in GridView.How should i change the code to make this work properly.
i am trying to make a search form with 1 label(surname) and textbox. i have 1 gridview on the form aswell. can you plz provide me any code so that when i type in textbox i should c the result in the gridview. wat i have done right now is. i have added data source and i than dragged the dataset.but when i load the form i already can see the data loaded on grid view .it than filters depending on the textbox. i want this gridview to be empty when it gets loaded.
View 4 RepliesI try to make my datagridview rows change colour depending on value on a row cell. I ve tryed everything i found on the web but nothing..
View 3 RepliesI work with VisualStudio 2008 and write my codes in VBasci.Also,I use Microsoft SQL server 2008 for my database and here is the question;I ve curently been doing a simple hotel software, the step that I ve got stucked in is that, I take the reservations by clicking on buttons those represents rooms in the hotel,buttons have green colour on them because they are available until I take a reservation for that room,and they must be staying green until a customer checks-in..On a check-in day,that room must go to colour of red or somethıng and must'nt be able to take another rezervation into it until the customer checks-out, I ve got 2 people comıng for that room for tomorrow who will stay for 1 night,so today it should stay green whıch means it s available,but by the mid night it must go red and must be not available to take rezervations for tomorrow,once they check-out on the day after tomorrow ıt should go green,so,available again.
View 6 RepliesI have a gridview with two cells cell(0) is a IP-number and cell(1) is a resultTxt. I have X number of rows. I want a solution that check each row and do a ping to the ip and write result to result. I want to do the ping in a new thread and i want to be able to do more then one at the time. So I want a loop that keeps checking the ones that are not online until they goes online. It's the thread-part I have questions about, looping gridview and doing a ping I can manage, but it I don't do it in a thread the interface freezes.
View 2 RepliesAm migrating VB6 to VB.Net and am stuck once again. We use App.HelpFile in vb6 to set Path and Filename of current help file.Current help File can change depending on which form is displayed.How do we assign help files in VB.net?
[Code]...
I have a page with a form on it and needs a range of dates. Thus I've placed a number of textboxes on the page into which users can type dates. When the user clicks the save button I want to trigger a LINQ update to the SQL Server...all the rows already exist, so I'm just updating existing data.
For example, lets say my table looks like this:
Column Names: Description dateValue
Column Values:
Birthdate 1/1/1990
Anniversary 1/10/1992
Death 1/1/1993
I want to do something like this:
hupdate.Description("Birthdate").dateValue = TextBox1.Text
hupdate.Description("Anniversary").dateValue = TextBox2.Text
hupdate.Description("Death").dateValue = TextBox3.Text
hconfig.SubmitChanges()
Is there a way to do this with LINQ?
I have a list of 12 buttons on a form. I want to label each of them representing a month from left to right starting at the most recent month. So if today is the 12/3/12 my buttons will be in THIS order MAR12,FEB12,JAN12,DEC11,NOV11 ETC UP TO BUTTON 12. I have already written code for it and it works but it is long winded.
Here is my long winded
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
DTPicker1.Value = TimeValue(Now)
End Sub
[Code]....
In my datagridview, I want to be able to change the value of comboBox1 depending on what the user selects in comboBox2
I had this working correctly, however if I move onto a new line in my gridview and select a different value in the second row it changes the previous row also. For instance, on Row1, if comboBox1 = A, combox2 = B
Then on Row2, if comBox1 = Y, comboBox2 = Z
However, when I change Row1, Row2 is also changed to reflect what was chosen in Row1. Is there a way I can tailor it to each specific row?
I have a program where I want my picture box to change depending on what number comes up in a textbox. Lets just say, my picturebox is called PictureBox1. I'd imagine I'd use an IF statement followed by the path type in to change the picture. My question is how do I display a new picture in the picturebox? Whats the code used?
View 6 Repliesbasically my problem is my program i made is fine on my screen, but when i port it to my mates screen some of my listboxes and buttons are not visable. because of his resolution i want to me able make my prgram adaptiable to specific screen resolutions.
View 9 Repliesi was wondering if it's possible to load a listbox with files from a folder and depending on the file extension , the file name color would change ex.. if it's a .txt file , then the filename would load as blue , if a image (.jpg) the color would be red , and so on...posibility in a listbox ?
View 7 Replieshow to display result in gridview according to textbox only if textbox2 date value is greater than textbox1 ?i have two textboxes and gridview ... if i type in Textbox1 : 2-Jan-2011 and in textbox2 : 1-Jan-2011 then in label1 the eroor message display else ..if textbox2 value is greater then textbox1 value then gridview will display records according to textbox1 and textbox2 from database
View 1 RepliesI have a ContextMenuStrip that is attached to a DataGridView, how can I change the text of an item in the ContextMenuStrip depending on the value of the cell in which the strip is activated over?
View 1 Replies