|
Get it
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
|
Hi! Fridnes...
This is Ahmed and iam a new to c#.net so i have a problem in creating Themes in Windows Application for DataGrid, Lables n Textbox. So please its a reques to All of friends that please please help me...
Thank a lot in Advance.
Ahmed
|
|
|
|
|
|
That's a VC++ MFC control... Look nice, though.
|
|
|
|
|
I want to make a group of common data.
Suppose i have a table having feilds cNo, cName as
cNO cName
---- ------
1 A
2 A
3 B
4 C
5 A
. ..
. ..
Now after searching the common 1n's, the result should be like:
1,2,5 have A.
3 have B.
5 have C.
& so on......
Will anyone please suggest me?
Any link or code will be great help.
Thanks & regards.
|
|
|
|
|
Are you trying to do this is SQL, or in code?
|
|
|
|
|
Bardy85 wrote: Are you trying to do this is SQL, or in code?
Let me explain with reference to my previos message.
I have 2 tables in database 1 have cNo feild & 2 have cName feild,
I have to make pair from these 2 tables.
Now, what i thought to carry out this,
using foreach loop on cNo and getting cName feild from 2nd table.
Now i have both cNo & cName feild
then make 3rd table using both these cNo, cName feild.(Need a bit suggection here, as i will make this thru code(not creating this in DB) so can i perform operation on this table)
After that making pair of common entries,
But How to make pair??
The way i am using is correct?
Need some advice How to do this?
|
|
|
|
|
You could use a hash table where the key is the cName and the value is a generic List<int>.
For each cNo, cName pair:
1. If cName isn't in the hash table, insert it with the value new List<int>.
2. If cName is in the hash table, add cNo to its list.
Then for any cName, you can look up the list of all numbers associated with this name.
|
|
|
|
|
You could first get all the distinct cNames from the database and save them into a list:
SELECT DISTINCT cName FROM table
Then loop over the list and issue a second query for the numbers that match these names:
Dictionary<char, List<int>> list = new Dictionary<char, List<int>>();
foreach(char c in list.Keys)
list[c].Add(...);
The second query might look like:
SELECT cNO FROM table WHERE cName = and append the current character there.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
See this[^] thread from last week.
|
|
|
|
|
This is a small part of my code, i am retrieving conditions used in conditional formatting in excel.
Excel.FormatCondition formatCondition = formatConditions[1];
string formula1 = formatCondition.Formula1;
// Here in the below code problem arises
if there is no formula2 the system gives COMException
string formula2 = formatCondition.Formula2 ;
i tried,
if(formatCondition.Formula2 == null)
{
}
but still didn't work and still goes in catch block
So how do i compare if there is no formula2 value.
i am strucked here.............
|
|
|
|
|
Try adding a break point by string formula2 = formatCondition.Formula2 ; and see what it returns.
Also you can try
formatCondition.Formula2 == "" OR
formatCondition.Formula2 == String.Empty
Hope this helps
|
|
|
|
|
Hi all,
I have two lists as mentioned below, and I'm trying to select a result based on the following condition: where the items in the fruits list matches with the items in the match list.
List<string> match = new List<string> { "a", "b", "apple", "c", "grape" };
List<string> fruits = new List<string> { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" };
IEnumerable<string> query = fruits.Where(fruit => fruit ....
Can anyone please help?
Many thanks in advacne
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's
Programm3r
My Blog: ^_^
|
|
|
|
|
This was driving me NUTS! cuz i knew what to do, just not exactly how
found the answer after an hour or so of trail and error... the following seems to work
static void Main(string[] args)
{
List<string> match = new List<string> { "a", "b", "apple", "c", "grape" };
List<string> fruits = new List<string> { "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" };
var query1 = from matchList in match
select matchList;
var query2 = from myFruits in fruits
join matchList in query1 on myFruits equals matchList
select myFruits;
foreach (var item in query2)
{
Console.WriteLine(item);
}
Console.Read();
}</string></string></string></string>
Hope this is what you wanted
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.passion != Programming)
|
|
|
|
|
|
Your welcome
did it work for what you wanted to do?
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.passion != Programming)
|
|
|
|
|
Use HashSets rather than Lists
System.Collections.Generic.HashSet<string> match =
new System.Collections.Generic.HashSet<string>
{ "a", "b", "apple", "c", "grape" } ;
System.Collections.Generic.HashSet<string> fruits =
new System.Collections.Generic.HashSet<string>
{ "apple", "passionfruit", "banana", "mango", "orange", "blueberry", "grape", "strawberry" } ;
System.Collections.Generic.HashSet<string> intersection =
new System.Collections.Generic.HashSet<string>
(
match
) ;
intersection.IntersectWith ( fruits ) ;
Though it's even easier with my Set[^] class.
|
|
|
|
|
I have strings of type
"23"
"23 cm"
"45in"
I want to split them into numeric and text parts.
Can I do this using Regex.Split
What pattern to use ?
|
|
|
|
|
Why do you need regex for that?
I would do it 'by hand':
- remove spaces (if any) with string.Replace(" ", "")
- foreach character in the string, if it is numeric, append it to the numeric part, else append it to the letter part
|
|
|
|
|
The Match method would be more appropriate. Use a pattern like "^(\d+) ?(\w*)$".
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Dunno, but you could catch the groups with a Regex
^(?'Value'\d*)\s*(?'Unit'\S*)
If there's match, look in:
Matches.Groups [ "Value" ].Value
Matches.Groups [ "Unit" ].Value
|
|
|
|
|
Hi,
I need method/example of said subject.
Thanks in advance
(Riaz)
|
|
|
|
|
Try add an Attribute KeyPressed to the cell of the DataGridView
|
|
|
|
|
private void MyDataGridViewInitializationMethod()
{
...
dataGridView.EditingControlShowing +=
new DataGridViewEditingControlShowingEventHandler(dataGridView_EditingControlShowing);
}
private void dataGridView_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
e.Control.KeyPress +=
new KeyPressEventHandler(Control_KeyPress);
}
private void Control_KeyPress(object sender, KeyPressEventArgs e)
{
if (char.IsNumber(e.KeyChar))
{
}
}
|
|
|
|