If you are using VS2005, after drop-down the datagrid in your aspx file, you should go to the property of the datagrid. There is a option ther to change the color of each row as you want to.
Regards! On Sat, Feb 13, 2010 at 11:34 AM, ricky <[email protected]> wrote: > I have an Access database with the following two tables. I've listed > the columns names under the cooresponding tables. > > Primary Table name: PhoneInfo Secondary Table > name: Out_of_Office > Col. name: Contact_Name Col. name: > Contact_Name > Col. name: Nick_Name Col. name: > Out_of_Office_Start_Date > Col. name: 1st_Choice Col. name: > Out_of_Office_End_Date > Col. name: 2nd_Choice Col. name: > Manager_Name > Col. name: 3rd_Choice > Col. name: Other_Info > > Basically, I want to compare the "Contact_Name" columns from both > tables for a match and then if there is data in > columns:"Out_of_Office_Start_Date" and "Out_of_Office_End_Date" > > I think my SQL would look something like this: > > Dim sSQL As String = "SELECT PhoneInfo.Contact_Name, > Out_of_Office.Contact_Name" & _ > "Out_of_Office.Out_of_Office_Start_Date, > Out_of_Office.Out_of_Office_End_Date" & _ > "FROM PhoneInfo, Out_of_Office" & _ > "WHERE PhoneInfo.Contact_Name = Out_of_Office.Contact_Name" & > _ > "AND Out_of_Office.Out_of_Office_Start_Date IS NOT NULL" & _ > "AND Out_of_Office.Out_of_Office_End_Date IS NOT NULL" > > But, I'm not sure how to change the color of the datagrid row to red > let's say if the SQL above is true. > > I only display table: PhoneInfo in my datagrid. Both tables are > updated and linked to Access via SharePoint. My VB 2005 application > just reads the data from Access. > > > Sub Routine below brings in the data from Access. The SQL above would > somehow be incorporated within the sub routine, but I need to figure > out how to change to color of the row???? > > Sub Update_Database() > Dim myBindingSource As New BindingSource > Dim sSQL As String = "SELECT * FROM PhoneInfo" > Dim cmd As OleDbCommand = New OleDbCommand(sSQL, conn) > adapter = New OleDbDataAdapter(cmd) > myDataSet = New DataSet > adapter.Fill(myDataSet) > myBindingSource.DataSource = myDataSet.Tables(0).DefaultView > DataGridView1.DataSource = myBindingSource > End Sub > > thanks, I hope I explained my question correctly?? > -- Eder Sousa Technology Information [email protected] [email protected] [email protected]
