|
hi
I want to make grouping in the data grid view. like
Table 1
pk col1 col2
1 ABC 51
2 DEF 74
-----------------------
Table 2
pk col1 col2 col2 col3 fk(pk_table_1)
1 abc 3 23 111 1
2 def 3 45 74 1
3 kki 8 23 871 2
4 qwe 2 15 5 2
5 eed 7 41 91 2
------------------------------------------
Now I want to show the data in the grid but in summarized form. like only the data that is in table 1 will be displayed first and at the left most a + sign will be displayed when we press that the data of table 2 will be displayed then.
Thanks
Syed Shahid Hussain
|
|
|
|
|
Syed Shahid Hussain wrote: Thanks
There's no question in this post, that makes it somewhat harder to formulate an answer.
AFAIK, the requested behaviour isn't standard available in the DataGridView. It might be best to look for a 3d-party grid that supports drill-down and grouping.
I are Troll 
|
|
|
|
|
I have written the simple code as below:
Addede reference (C:\Program Files\Microsoft Visual Studio 9.0\Visual Studio Tools for Office\PIA\Office11\Microsoft.Office.Interop.Excel.dll)
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application _objAppln;
Microsoft.Office.Interop.Excel.Workbook _objWorkBook=null ;
_objAppln = new Microsoft.Office.Interop.Excel.Application(); // To initialize excel file
if (_objAppln != null)
{
_objWorkBook = _objAppln.Workbooks.Add(Type.Missing); // To add workbook with sheets in excel file
//_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)_objWorkBook.ActiveSheet; // To get the current active sheet in excel file
}
string _fileName = "temp.xls";
_objWorkBook.SaveAs(_fileName,
Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, false, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
_objWorkBook.Close(true, _fileName, false);
_objAppln.Quit();
_objWorkBook = null;
_objAppln = null;
}
After the code is execuled, the instance of Excel (EXCEL.exe) is seen in taskbar. I have as many number of instances, as many times I click on the button.
The instance exists even when I stop the application.
What is wrong in the above code.
Gurpreet
|
|
|
|
|
Hi
I had the same problem
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForPendingFinalizers();
after setting _objAppln=null; worked for me
greets
|
|
|
|
|
Explicitly calling GC.collect is not recommended. Is there any other good way to handle it?
Gurpreet
|
|
|
|
|
Try releasing the Excel Application COM object by using the following code:
try
{
if (objAppln!= null)
System.Runtime.InteropServices.Marshal.ReleaseComObject(objAppln);
}
catch (Exception)
{
}
finally
{
objAppln = null;
}
|
|
|
|
|
KaurGurpreet wrote: What is wrong in the above code.
I'm missing the code to close the workbook and exit the Excell application.
Meh, they're there, just overlooked them.
This kb-article[^] might help. The only other alternative[^] that I can offer;
Marshal.ReleaseComObject(workBook);
I are Troll
|
|
|
|
|
Hi,
To compare two datarows, I used Equals method as shown below. But it returns false, though the rows are equal.
dtGridOld.Rows[i].Equals(dtGridNew.Rows[i])
Please let me know the correct way. Thanks in advance
|
|
|
|
|
Because DataRow is a reference item, the Equals comparison checks to see if they are the same instance. Since they aren't, the comparison always returns false.
Use the DataComparer instead:
IEqualityComparer<DataRow> comparer = DataRowComparer.Default;
DataRow rowOne = (DataRow)table.Rows[0];
DataRow rowTwo = (DataRow)table.Rows[1];
bool bEqual = comparer.Equals(rowOne, rowTwo);
if (bEqual)
Console.WriteLine("The two rows are equal");
else
Console.WriteLine("The two rows are not equal");Note: This will not work pre .NET 3.5
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
Thank you..
while comparing, it is looking case sensitive data also. Though I set false to caseSensitive property of datatables.
dtGridNew.CaseSensitive = false;
dtGridOld.CaseSensitive = false;
Had I missed anything?
|
|
|
|
|
Case sensitivity of the data tables is irrelevant: it does not apply to row data extracted from the tables, just to the table as a whole - just as you would expect.
I know of no way to force case insensitivity on a DataRowComparer: you will probably have to write your own derived class! See MSDN and be prepared to work at it!
It may be that it would be easier to write a specific comparison routine for your two data rows, given that you know the data format you expect...
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
Hi,
I am trying to display 2 relational tables ('authors' and 'titleauthor' tables in pubs database of NorthWind) in a single DataGridView. I have selected SQLDataAdaptor from toolbox and made the join query on 2 tables. I also added a DataGridView on the form and binded it to Dataset. I have the following code in my form load:
dataSetNew1.Clear();
sqlDataAdapter1.Fill(dataSetNew1);
dataGridView1.DataSource = dataSetNew1;
dataGridView1.DataMember = "authors";
My DataSet is getting populated, but i am not able to display the data in the DataGridView. Please help me out as i am new to Visual C#. 
Regards,
Priya.
|
|
|
|
|
Try setting AutoGenerateColumns on your DataGridView to true.
|
|
|
|
|
|
Hello i would like some help with creating video player for windows mobile in c#....
any ideas tips or anything ???
Thanks
|
|
|
|
|
Perhaps the Mobile Development forum would be more appropriate
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hey guys,
I'm trying to create a control which simply colors certain words in a string, when printed onto a control.
For example:
"This is a test statement to test the highlighting's ability to test."
In this statement, when printed on a control, I need all the words "test" being highlighted in say, blue, while the rest of the string remains the regular color. I've been trying to figure out an effective way of doing this for a long time. I have a graphics buffer, double buffering and some intensive graphic's performance boosting codes in place, but i'm trying not to implement nests of loops just to highlight words.
Can anyone point me in the right direction with this? I've been using Regex to find patterns (replacing 'test' with '\C[0,0,255]test') and then converting the '\C[x,y,z]' into a color and looping through word by word, and nesting inside letter by letter, but this is too intensive and simply won't work.
Thanks 
|
|
|
|
|
Hi,
a simple way to get this would be by using a RichTextBox; you can add text, select parts of it, and modify attributes (such as ForeColor) for selected text.
another way could be to have a Panel and paint all the text yourself in the Paint handler, using Graphics.DrawString with a Font and a Brush (hence color) you choose.
|
|
|
|
|
Well i'm trying to avoid using an RTFBox. It has some handy functions, but i'm really trying to focus on using this control without being dependant on the RTFBox.
I might just need to find a much more efficient way to process the highlighted words in a string of text.
|
|
|
|
|
when I create a text editor, I use a Panel and draw everything myself. Syntax coloring means looking for keywords and some delimiters and using some colors. For an IDE, texts are line oriented, so things are pretty much local; and the big trick is to only compute lines that are visible, which is say 50 lines out of a file that could span hundreds or thousands of lines.
If you want more specific help, you'll have to provide some concrete information; so far you have been very vague!
FYI: I avoid Regex when performance is important; IMO most of the time Regex offers comfort at the expense of speed.
|
|
|
|
|
I have created tables in SQL Server Management Studio which I want to use in a program I have in VS 2010. When you check the properties of the tables in Management Studio there doesn't appear to be an actual path that you can use as a connection string. Can anybody help me with this?
Thanks
Darrall
|
|
|
|
|
http://www.connectionstrings.com/[^]
You already have SSMS open and connected to a database and you can't figure out a connection string to use? 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
A fair enough observation except that it doesn't want the path to the database itself...it wants the path to the file that I created within the database and that path I can't find.
|
|
|
|
|
Darrall wrote: the path to the file that I created within the database
I have no idea what you're talking about
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I find that hard to believe. Are you sure it's not Access?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
