C#

FirstPrevNext

Remove Duplicates in Datatable kibromg10-Jul-07 0:52 kibromg 10-Jul-07 0:52  I have a various tables which gets activated as a user selects an option.I want to poulate the results in a datatable and check they are not duplicate data from each table.My datatable should contain a dataonly once no duplicates. How do i go about that? Is there a function that checks the data before writing it to datatable so that it cant duplicate? Please advice Thanks and regards Re: Remove Duplicates in Datatable Christian Graus10-Jul-07 1:20 Christian Graus 10-Jul-07 1:20  Not really, your database should have keys set so that it won't accept duplicates. The other way is to write a select to see if the data exists. Finally, you can insert with a stored proc that first checks if the data exists, and only inserts if it doesn't. Christian Graus - Microsoft MVP - C++ "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 ) Re: Remove Duplicates in Datatable Chintan.Desai10-Jul-07 2:19 Chintan.Desai 10-Jul-07 2:19  Every table must have primary key and the Domain of each column must matches with one another to get the correct type of data in a column of the datatable.Load 1st row from i(Option selected) table to common datatable, check whether that rows is exists in common datatble,if it is then dont add the row else add them and proceed further with next row in i table. Regards Chintan www.visharadsoft.com (Nothing is so purify as KNOWLEDGE) Re: Remove Duplicates in Datatable kibromg10-Jul-07 4:53 kibromg 10-Jul-07 4:53  THANK YOU ALL YOUR HELP IS VERY GREAT. Re: Remove Duplicates in Datatable AFSEKI10-Jul-07 6:28 AFSEKI 10-Jul-07 6:28  Have a look at DataColumn.Unique property. NEED CRYSTAL REPORT EXPERT Banjo Ayorinde10-Jul-07 0:47 Banjo Ayorinde 10-Jul-07 0:47  Kindly link me anyone who have successfully deployed a windows based application with crystal report, using C#.Net 2005. B'cos am bug with deployment issue on crystal report. Re: NEED CRYSTAL REPORT EXPERT Paul Conrad12-Jul-07 17:38 Paul Conrad 12-Jul-07 17:38  Describe your bug with the deployment and someone might be able to help. "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus listview with compact framework Sunshine Always10-Jul-07 0:27 Sunshine Always 10-Jul-07 0:27  hi the application is written in .net compact framework 1.0. i need to display a list of items with different forecolor for each item. the items get added to the list from a file. i have two problems: 1. the items get added but i get a horizontal scrollbar by default. i just want them too be added to the end like that in a listbox. 2. how do i set the forecolor of individual items? thanks. Re: listview with compact framework Sunshine Always10-Jul-07 0:44 Sunshine Always 10-Jul-07 0:44  i got the way to get view the items in a list with vertical scrollbar but the second problem still remains... does anyone have any suggestions??? thanks. Re: listview with compact framework Diana Fernandez10-Jul-07 1:14 Diana Fernandez 10-Jul-07 1:14  For each item in listview you have to set the color like this.listView1.Items[0].ForeColor = System.Drawing.Color.Red; this.listView1.Items[0].ForeColor = System.Drawing.Color.Blue; colourful context menu EvilInide10-Jul-07 0:22 EvilInide 10-Jul-07 0:22  hi How can i build colourful context menu for notification icon(System Tray Icon). Plz share any idea with u. I am getting sooo trouble on it thanks evilinside Re: colourful context menu Paul Conrad13-Jul-07 12:05 Paul Conrad 13-Jul-07 12:05  You are going to have to read up on custom controls. "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus Chat Coading Sathiya Narayanan10-Jul-07 0:20 Sathiya Narayanan 10-Jul-07 0:20  Hai friends I am working for one private software company where in i a need to do the chatting program. I am new to .NET platform. please help me by sending either an sample program or by sending the coding. I need the thing in ASP .NET using C# coading. Sathiya Re: Chat Coading EvilInide10-Jul-07 0:27 EvilInide 10-Jul-07 0:27  go to google.com and search "multithreaded chat application in c# " you may get your answer. evilinside Re: Chat Coading Chintan.Desai10-Jul-07 2:24 Chintan.Desai 10-Jul-07 2:24  go to www.questpond.com if you wanna need whole project on chat application. Regards Chintan www.visharadsoft.com (Nothing is so purify as KNOWLEDGE) Session time king2010-Jul-07 0:16 king20 10-Jul-07 0:16  What s session time? How to calculate the session time? wat s the duration of session? Pls reply soon... Thanx Re: Session time Christian Graus10-Jul-07 1:26 Christian Graus 10-Jul-07 1:26  session time relates to web dev, it means how long the web app regards you as being connected when you stay idle. It can be configured on the server. Christian Graus - Microsoft MVP - C++ "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 ) Crystal Report Error Syed Shahid Hussain10-Jul-07 0:15 Syed Shahid Hussain 10-Jul-07 0:15  The mysterious error i've found in the database that is. This group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field. Error in File C:\DOCUME~1\ADMINI~1.ABC\LOCALS~1\Temp\temp_ef660b00-652e-4d6f-ba7c-e56310031a98 {583537DD-DED3-4230-BB59-FC225EDD5F1E}.rpt: Invalid group condition. Can any one help me against this gaint i'd worked very hard for solving it out but failed..... . Help Help Help.... . Thank Syed Shahid Hussain Color Managment Stevo Z10-Jul-07 0:12 Stevo Z 10-Jul-07 0:12  Hi, I have a custom button, that can have any background Color. Now user can pick background color, byt I don't want user to pick it's forecolor (text color) . I want to calculate that color myself. Can you help me out with some algorithm to do this = to calculate a fore color that is diffrent enough from specified background so that it is perfectly readable for human eye ? I understand HSL Color scheme and tried to create something by myself but it was not good enough and I don't want to put it here so you won't be influenced by my sollution. My only requirement is to keep that text color in grayscale. thanx PS: I've tried luck at Graphics department but not much people visit that forum... Re: Color Managment Christian Graus10-Jul-07 1:23 Christian Graus 10-Jul-07 1:23  I would take the bitmap color, invert it and convert it to greyscale. So, go 255-x on each of the red, green and blue components, then google for the algorithm to convert that color to greyscale ( my first image processing article has it, but I don't know it off the top of my head ) Christian Graus - Microsoft MVP - C++ "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 ) Re: Color Managment Stevo Z10-Jul-07 1:42 Stevo Z 10-Jul-07 1:42  Thanx , I'll try that btw your articles are great, I've learned a lot about colors from them Re: Color Managment Luc Pattyn10-Jul-07 1:30 Luc Pattyn 10-Jul-07 1:30  Hi, I would compare the background brightness (Color.GetBrightness) with some middle value, say 0.5f; if larger (=brighter), choose ForeColor=Color.Black, else choose Color.White Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] } Re: Color Managment Stevo Z10-Jul-07 1:39 Stevo Z 10-Jul-07 1:39  Hi, thats basicaly what I did and the problem is that some Colors are at constant Saturation, Luminacne values (Hue differs) were diffrent for human eye e.g. : try constant Sat : 1f; constant Lum : 0.5f; ======= 0.66 Hue - pure blue - very dark color, perfectly fits with white text color event if luminance is about 0.6f. ======= 0.5f Hue - cyan (something between blue and green)- very bright color, perfectly fits with black text color even if luminance is about 0.4f. Re: Color Managment Luc Pattyn10-Jul-07 2:20 Luc Pattyn 10-Jul-07 2:20  Hi, the way .NET calculates brightness gives about 0.5f for those colors that have the three RGB components equal two one or two zero values and two or one 255 values (that is red, green, blue, cyan, magenta, yellow). For some of these colors you definitely want black foreground, for some it is more or less undecided. I suggest you use Black for brightness (not luminance!) above 0.4f or 0.45f Alternatively you can calculate a fake brightness (in range 0-765) by adding the RGB components of the background; if that exceeds say 500 choose black, otherwise white. This results in black foreground for cyan, magenta, yellow backgrounds (sum 510), but white for red, green and blue (sum 255). Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] } Re: Color Managment Stevo Z10-Jul-07 3:00 Stevo Z 10-Jul-07 3:00  I know what's the diffrence between HSL and HSB, and I thought Color.GetBrightness() corresponds to HSL luminance. When creating HSL from a .NET Color, i use : this.Luminance = color.GetBrightness(); this.Saturation = color.GetSaturation(); this.Hue = color.GetHue(); so, is this incorrect approach? Ii thought it's just naming diffrence, I never tried to compare values when created color from HSL values if luminance and color.GetBrightness() match. that fake brightness looks interesting, I'll try that, thanx

Last Visit: 31-Dec-99 18:00     Last Update: 18-May-24 2:50 Refresh ᐊ Prev1...8979898089818982898389848985898689878988 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.