|
Hi,
I have a Datagrid.now i generate a store procedure(suppose "select * from employee").now using the SP i generate a DataSet and bind a Datagrid.The Datagrid have 1000 records.Now can i find the duplicates records only from the front end.without using any store procedure. (like dataview or etc)
|
|
|
|
|
Hi,
To find duplicated records use the above code sample :
DataView v = myDataSet.Tables["YourTable"].DefaultView;
v.Sort = "YourPrimaryKey ASC";
Dictionary<int, list<int="">> duplicatedRecords = new Dictionary<int, list<int="">>();
for (int i = 0; i< v.Count -1; i++)
{
int j = i +1;
object iValue = v[i]["YourPrimaryKey "];
while (v[j]["YourPrimaryKey "] == iValue)
{
if (! duplicatedRecords.ContainsKey(i))
{
duplicatedRecords.Add(i, new List<int>());
}
duplicatedRecords[i].Add(j);
j++;
}
i = j;
}
HTH.
Hayder Marzouk
|
|
|
|
|
hi friends
I have a query regarding vertical scroll bar. how to use vertical scroll bar(vscroll) with a label. that is when the contents in the label increases, a scroll bar should appear. I dont want a default scroll bar like in the rich text box control .... I want to work with the vscroll control.
thanks in advance
-- modified at 1:33 Friday 30th March, 2007
|
|
|
|
|
You need to write a control to do this. You would just use the MEasureString method on the graphics class to work out if your text is going to be oversize, show a scrollbar accordingly, and redraw the string offset by the scrollbar position when a scroll event occurs.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I am using a DataGridView as an EventLog viewer. At the moment I just bind it to a DataTable I get from my LogQuery class. However, one of the columns is EventType, an integer, but I would like to transform this to the descriptions corresponding to event types, such as Error, Information, Warning, etc. I can't change the query used by the LoqQuery to include a join, as the data provider doesn't support this. Short of iterating the DataTable result, changing one column from int to string, and doing the lookup there, I have to do the lookup transform in the grid.
I think a good start is switching off auto-creating columns and manually binding columns, then I can insert an extra column and do some slights of hand. This is the crux of my question: what can I do here? An expression column, handling a populating event and doing a lookup, iterating the grid and fixing everything once populated, etc.
|
|
|
|
|
Sorry about the cross post - the "Message Boards" drop down does not include this forun in it's list so I didn't see this forum until after I had already posted this question to the C# forum.
I am a C# programmer with mostly ASP.NET experience. I have done very little Win32 (WinForms) programming. Any suggestions for a good book on Windows Forms? I don't mean a general C# or .NET book, but one that specifically addresses the topic of Windows Forms.
|
|
|
|
|
|
Another great (advanced) book is: "Pro .Net 2.0 Windows Forms and Custom Controls in C#" by Matthew MacDonald (long title) But with over 1000 pages it definitely covers a lot of GOOD material related to windows forms.
Cheers!
Richard
|
|
|
|
|
hi,
i want to create table in runtime like ms word table,how can i create table?
or can any one tell how to create new control which is not in toolbox i have to create new control plz help me its urgent
B.N.Thorat
9881215484
Mumbai
|
|
|
|
|
Unless you write some custom code to simulate a table, the closest control to use would be the DataGridView control. Creating the DataGridView behind the scense pretty difficult so I would advise you to drag one onto a windows form, set the properties and appearance like you want them then see what code Visual Studio has written behind the designer page.
To add the dynamically created control to a form, reference the form then it's "Controls" property which has an "Add" method:
//C# Sample
this.Controls.Add(myControl,xPosition,yPosition);
' VB Sample
Me.Controls.Add(myControl,xPosition,yPosition);
If you are wanting a completlely new custom control, your in for a lot of graphics coding. A fairly advanced but great book on this subject is: "Pro .Net 2.0 Graphics Programming" by Eric White.
Cheers!
Richard
|
|
|
|
|
Thanks,
but my requirement is not datagrid i have to create table just like in microsoft word table in which user can write text & with the text size of cell will increase like MS word table.
can u suggest what should i do for such type of table?
i will thankful to u
thanks for ur reply.
B.N.Thorat
9881215484
Mumbai
|
|
|
|
|
If you are wanting to create the control yourself you better have some nerve pills on hand. 
All of the functionality you mentioned will have to be created from scratch which will require a lot of paint and logic code. You will also need a good reference book. Check out: http//www.apress.com for a custom controls book.
Good Luck!
Richard
|
|
|
|
|
hello,
i have made a window service for my some xyz purpose and its working fine.but the problem is that
InternetExplorerClass IE = new InternetExplorerClass();<br />
IE.Visible = true;<br />
IE.DocumentComplete += new DWebBrowserEvents2_DocumentCompleteEventHandler(IE_DocumentComplete);<br />
isDocumentComplete = false;<br />
object empty = "";<br />
IE.Navigate("www.google.com", ref empty, ref empty, ref empty, ref empty);
when i'm using this Code with Window Service this code is not working even IE.navigate function is not navigating the site or not openning the IE browser..while when i use use this code with simple asp.net with c# project
its working fine.
suggestion are most welcome.
thanks and regards
Amit Agarwal
Dotnet
|
|
|
|
|
Why dont you try this approach.
System.Diagnostics.Process.Start("www.google.com")That way you allow their default browser to open up the web page based on file associations.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
hi, thanx for the reply,
i cann't use this approach becoz i have to further use InternetExplorer Class Properties, why is n't working....
Dotnet
|
|
|
|
|
Look I have a widnows service,
which gets installed and uninstalled programmatically.
Now I am using advapi32.dll to install and uninstall the service.
But when I uninstall the service, It doesnt remove the entry from Services. It removes it only when I close the running application which has called uninstall method.
What to do? how can I remove the entry without closing my application?
I working on it since loooooooooong time. but 
Nana
|
|
|
|
|
I have seen some issues with uninstalling windows services where if you delete the exe before you uninstall it, the service will still show up. So I would uninstall first then delete the exe. Just a guess.
Hope that helps.
Ben
|
|
|
|
|
There can also be problems if the Services control panel applet is running when the service is removed. It will sometimes "persist" until a reboot occurs.
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
SALAM SIR;
I AM NEW USER OF THIS FORUM.PLEASE HELP ME HOW CAN MADE CALCULATOR APPLICATION IN C#.NET WINDOWS APPLICATION?
THANKS
mohammedali
|
|
|
|
|
mohammedali2006 wrote: PLEASE HELP ME HOW CAN MADE CALCULATOR APPLICATION IN C#.NET WINDOWS APPLICATION?
1. Don't use ALL CAPITAL LETTERS
2. Don't click "Post" twice.
3. Write your C# code. Then use the C# compiler to build the .EXE file.
led mike
|
|
|
|
|
1 - fix your caps lock key
2 - buy a book
3 - work through it
4 - ask *specific* questions when you get stuck
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I want to watch a ftp directory, where users will upload documents, using a windows services in .Net. BUt the directory watcher in .net hav serious problem, its event get fired when the file is not completed yer, can someone suggest better solution or an alternative. i hope u guys will.......
many thanks,
adnan
Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com
|
|
|
|
|
Will you guys plese put some light on my problem.many thanks,
adnan
Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com
|
|
|
|
|
|
Hi,
I need to make dockable forms like the Visual Studio toolbox, property box, etc.
As i can see there are no such type of controls in the Visual Studio toolbox.
Where can i get them?
Thx,
Nuno
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
