|
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))
{
}
}
|
|
|
|
|
Hello,
I have a program written in Ansi-C, and I want to use the functions in a C# program.
How can I do this?
|
|
|
|
|
u acn call c program through DLLIMPORT functionality of c#
rahul
|
|
|
|
|
But therefore I have to create a DLL of the C-Programm?
|
|
|
|
|
|
Is it possible to make two projects in one workspace and make in the C# project a referenc to the C/C++ project??
|
|
|
|
|
strizi wrote: Is it possible to make two projects in one workspace and make in the C# project a referenc to the C/C++ project??
Why would you want to do that? Why not just use one language?
|
|
|
|
|
Because the C-Program is used for a "DOS-Compiler" and should also be used in a C# Project for a new Windows Application...
|
|
|
|
|
Try creating a C#, and a C/C++ class library project under the same solution, and link them.
Personally, I'd be searching for ways to do it all in one language if it were at all possible.
|
|
|
|
|
Meanwhile I have tried to link a C# and a C++ project in the same workspace. I can make the link in c# to the C++ project, but I can not use the functions from C++.
Please, can you give me a description how I have to link tht projects.
|
|
|
|