|
hi,
I have allowed the users to enter data into the cells of one column only.
This is a price column so only prices can be entered. i.e. 123.4322 and no alphabets.
Do I validate the cell in _cellvalidating or _cellvalidated or cell_Leave events? If so, how do I do this please?
Thanks
|
|
|
|
|
Do it in the "validating"-event
|
|
|
|
|
|
The size of an empty class is 1 byte but it may be different 2 or 4 on other OS.
m i right
correct me if i'm wrong
|
|
|
|
|
To be ernest: I don't know but I doubt it (why do you need to know?) - but you can use the Marshal.SizeOf method to find out.
|
|
|
|
|
|
Ok:
<br />
<br />
class App<br />
{<br />
public static void main()<br />
{<br />
System.Console.WriteLine("empty class has " + <br />
System.Runtime.InteropServices.Marshal.SizeOf(typeof(Empty)).ToString() + <br />
" bytes.");<br />
}<br />
}<br />
<br />
class Empty<br />
{}<br />
<br />
Please refer to the help for more info on Marshal!
|
|
|
|
|
Friend it's throwing the following error
Type 'Empty' cannot be marshaled as an unmanaged structure; no meaningful size or offset can be computed.
|
|
|
|
|
Sorry - didn't try - seems the compiler just skips the Empty class.
|
|
|
|
|
Does not matter....
Can u let me one another question.....
Total Namespaces and Classes supported by .NET Framework
|
|
|
|
|
Are you still flogging this dead horse of a question? 
What does it matter how many classes/namespaces there are? Your time would be better spent learning how to use them rather than counting them.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
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()
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
