|
This is C#, on a different OS, you must be using Mono. So what ? I believe you keep asking about this, why are you asking ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I'm trying to search a DataTable, with .Select(), to find all rows with a certain string in any of the columns.I basically want to match a string *string* with the data in any of the columns in a particular table. I've tried, simply,
table.Select( "'*' LIKE '*" + searchTerm + "*'" )
and while that runs with no errors, it also returns nothing. Had one idea, it's selecting fom all columns, but all columns do not have the sarchTerm, thus nothing returns. How can I tell it to return rows where ANY column has the searchTerm, while not excluding because the other columns do not have the searchTerm?
A soft glow comes from the pit in the darkness.
The clicking noise become faster - and louder.
A wind begins to stir up from the pit, as the
creature flexes it's wings, preparing for flight.
You stare into the pit, and hear a voice say
in your mind, "If you survive the encounter,
declare it to the world."
The Code Demon Rises.
|
|
|
|
|
First: the wildchar '*' in SQL is '%'
Second: you will have to provide the names of the columns (yes for all) with OR between - for example:
<br />
<br />
DataRow[] Rows = table.Select(string.Format(<br />
"'Name LIKE '%{0}%' OR Phone LIKE '%{0}%'",<br />
searchTerm) );<br />
<br />
|
|
|
|
|
I have a repeater with two dropdownlist in it. I created the ddl in HTML.
I have fields in a SQL table. Field1 populates ddl1 and field2 populates ddl2.
This is what i want to do: I want to make a selection in ddl1 and depending on what i have selected, ddl2 should be populated.
Please help,
|
|
|
|
|
You need to use server controls to do this, so they can postback, or you need to write AJAX code to do it for you.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello Everybody,
Please reply of my question :
How to read and write into a specific cell of MS Excel File?
Please reply
Thank You 
Dipak
|
|
|
|
|
Hi Dipak ,
Try these Steps !!!
Step 1:
Add EXCEL Assembly To You Project !
Add a reference to the Excel 10 Object Library (Excel XP) by going to the Project-> Add Reference -> Go to the COM tab Select Excel 10 Object Library.
Step 2:
Using Excel ;
Step 3: Now create ExcelApplication, and WorkbookSheet to access any Excel file To read and Write!!!
private Excel.Application ExcelApp;
private Excel.Workbook objBook;
private Excel.Worksheet objSheet;
ExcelApp = new Excel.ApplicationClass();
ExcelApp.Visible = true;
objBook = ExcelApp.Workbooks.Add(missing);
objSheet = (Excel.Worksheet)objBook.Sheets["Sheet1"];
objSheet.Name = "SampleSheet";
objSheet.Cells[1, 1] = "Roll";
objSheet.Cells[2, 1] = "Name :;
Change Font Style
objSheet.get_Range("A1", "A1").Font.Bold = true;
Hope .. now you can Go Forword !!!!!
Good luck !!!!
|
|
|
|
|
// Thank you for reply
objSheet = (Excel.Worksheet)objBook.Sheets["Sheet1"];
//it is not working so i have used
objSheet = (Excel.Sheet)objBook.Sheets["Sheet1"];
//it is working
objSheet.Name = "SampleSheet";
objSheet.Cells[1, 1] = "Roll";
objSheet.Cells[2, 1] = "Name :;
//There are no any property Name and Cells for objSheet
//
//Please reply soon
Dipak
|
|
|
|
|
|
Hi,
iam using (ms-access database) with c#..
i have textbox and datagridview control..
i entered "productid" in textbox ,it can fetch the productname,units,cost from database and displayed in datagridview...
2nd attempt:again when i enter "productid",it can also fetch the records and displayed in 2nd row of datagridview...
so i able to see 1st productid details and 2nd productid details...
like that how many times i enter the "productid" in textbox ,that no:of rows displayed in datagridview....
please give me some solution..
murali krishna
|
|
|
|
|
I guess, you want to display only one record on your grid everytime you enter one productid and search for it...right??
if thats the case, then if i assume you are using a dataset object to fill up your grid, you essentially need to re-initialise the grid which you can do by refreshing the Dataset object each time your search code executes.
like you can write
DoSearch()
{
DataSet dsProducts=new DataSet();
//code to fill your grid
dsProducts=null;
}
this way you always have single value in your dataset and hence your grid. I think you can try this, it should work.
|
|
|
|
|
Hi,thanks for reply---
upto this ok..
but when i enter another "productid" in textbox ,the data can be
displayed in another row of the datagridview...
so i can able to see 1st productid details and 2nd productid details
like that how many times i enter "productid" in textbox that no:of rows
created in datagrd view..
murali krishna
|
|
|
|
|
Hi every body,
Any specific procedure is there to identify a active com port.
means if a connect a device to com port, how to identify device is connected to which port.
Thanks
|
|
|
|
|
Hi,
your subject line and message body do not match: what is it you want to identify, the port
to which something is attached, or that something itself?
in any way, it will need some cooperation from the attached device.
Here are the two basic ways to get information:
1. through the control lines
Some devices, when powered and enabled, pull one or several control lines (see SerialPort
properties CDHolding, CtsHolding, DsrHolding)
2. by actually communicating
send commands to the device and look for the responses, if they fit your expectations chances
are the expected device is on the port you are talking to.
If you want to find the port, you probably need to loop over all available ports (see
SerialPort.GetPortNames()
|
|
|
|
|
Good Day,
With recent outbreaks of USB Flash Drive viruses on our campus, I am planning to write a utility that will "Write-Protect" the flash drive. (Since most flash drive here in our country does not come with a "Hardware Switch" to enable the write protection)
Is there any article that will help me to accomplish this task? Or this is fairly impossible?
Thanks,
Ian
|
|
|
|
|
It seems that you don't know how this viruses work!
Even if you find a way to write protect you flash memory, the virus needs you to unprotect it just for a second to write a little thing on it and the virus is there!
In solution of this, I have written a semi anti virus that protect the computer from being infected by infected flash memories and also rescuing the infected flash memory.
As all these viruses infect in the same scenario, my program works well for all even new versions of these viruses.
It is almost finished, but the interface needs a little work.
I will submit my work on codeproject after it was finished.
Sojaner!
|
|
|
|
|
I'll be waiting for that then.
But all I want to know is how to "Write-Protect" the flash drive (Or any other removable media). 
Thanks,
|
|
|
|
|
I'm having 500 hard coded records in a database. Now I thinking about to make a XML for that..So Which one is faster...? A XML file or a database table ..?
If a XML is faster then what is the best way to retrieve the data from it...?
A dataset or make a XML parser for that...? 
Regards
Pankaj Joshi
If you want to shape your dreams into reality, please wake-up...
|
|
|
|
|
If you store all your data in one single xml-file you will have to query wich data to show by using xpath (I guess you wont show all data at once). Another way is to create some xsl-files. But use a database if you can. It's much easier to work with data stored in a database and I think it's faster too.
If this data is static and performance is a big issue you should consider generating static html-files (if it's a webapplication)
|
|
|
|
|
Serverside wrote: If you store all your data in one single xml-file you will have to query wich data to show by using xpath...
Not really. If you use the class XmlDataDocument, you can manipulate XML data through a relational Dataset, so in a similar manner to that used in regular databases.
If there are only 500 records I would recommend either using XmlDataDocument or using an Access database file. The need for a database server like SQL Server or MySql is not justified in such a scenario.
|
|
|
|
|
blackjack2150 wrote: If there are only 500 records I would recommend either using XmlDataDocument or using an Access database file. The need for a database server like SQL Server or MySql is not justified in such a scenario.
What if SQL Server is being used for other data in the application? In that case it becomes a valid candidate. Adding Access to the mix in that scenario would be a very poor idea.
|
|
|
|
|
Database, ie SQL CE.
Faster or not depends on how you use it. Do you load the XML into memory once and use the data from memory? or do you have to query the XML every time? If you load them into memory, you will be hogging a lot of memory.
You won't know if you wake up one day, the requirement has been changed to 6000 records, must be able to add or delete, and changes needs to be deployed to 500 users.
|
|
|
|
|
darkelv wrote: If you load them into memory, you will be hogging a lot of memory.
How do you know? He hasn't said what the 500 records are! It might be 500 IDs with a string value consisting of a few words (lets say 20 chars average). That is 24 bytes (or 44 for Unicode). So that is a whopping 22K. Wow! That's a real memory hungry application.
darkelv wrote: You won't know if you wake up one day, the requirement has been changed to 6000 records, must be able to add or delete, and changes needs to be deployed to 500 users.
Where did he say he had 500 users? And why couldn't the XML file be located in a central location on a network?
You are making a lot of assumptions that were not in the original query. If you are going to do that then you should say that these are your assumptions and therefore they may possibly not apply to the situation.
|
|
|
|
|
Feeling cranky, eh.
That's what the "if" for.
Since he didn't supply more information, I am giving him something to ponder before he decide what he want to do.
|
|
|
|
|
darkelv wrote: That's what the "if" for.
No, it wasn't. You said: "If you load them into memory, you will be hogging a lot of memory." That indicates that you have already made the assumption that the data set is large, not IF the data set is large. I pointed out a fairly reasonable scenario where the data set wouldn't really take that much memory.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
