int rowIndex = 10; var rowData = dataGrid1.Items[rowIndex] as DataRowView; rowData["LinkRPT"] = ""; dataGrid1.Columns[10].Visibility = Visibility.Visible; SqlConnection con = new SqlConnection("Data Source=WINCTRL-TNT3FMR\\SQLEXPRESS;Initial Catalog=Roamani;Integrated Security=True"); if (dataGrid1.SelectedItems.Count > 0) { for (int i = 0; i < dataGrid1.SelectedItems.Count; i++) { System.Data.DataRowView selectedFile= (System.Data.DataRowView)dataGrid1.SelectedItem;//Row is detected and stored in selectedfile object string str = Convert.ToString(selectedFile.Row.ItemArray[10]); string sts = Convert.ToString(selectedFile.Row.ItemArray[9]); string query = "SELECT Report FROM StudyTable WHERE StudyUID='" + str + "' AND status='3'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); try { while (rdr.Read()) { query = rdr.GetString(0); //dataGrid1.Columns[10] = query; OpenReport(query); } } catch (Exception ex) { ReallySimpleLog.ReallySimpleLog.WriteLog(ex); } } } con.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)