|
Hi all,
I have a dataset which has 3 tables. They have relation by ds.Relations.Add(...)
Now I want a filtration like a master table i.e. ds.tables(0) should be filtered by one column like ds.tables(0).Select("Site_ID = 5")
(which will return datarow array now) and I want its children rows should be filtered appropriately.
Instead of table.Select(...) is there any other way?
Thank You
|
|
|
|
|
Please don't cross-post. It's rude.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Stick to one forum and wait for a reply, rather than cross posting and pissing people off.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
i am using .net 2005.i am doing my project in vb.net 2005.In my project,in crystal report,if i set parameter is number means succesfully execute,but if i set parameter is character means the following error is display.
if i give value as bri means,the following error will shown
failed to open a rowset.
Details:ADO Error code:0x
source:microsoft OLE DB provider for SQL Server
Desription:Invalid Column Name 'bri'.
SQL State:42S22
Native Error:
failed to open a rowset.
Error in fileC:\DOCUME~1\WELCOME\LOCALS~1\Temp\temp_be37e2d6-f284-4eaf-8f96-30f6261f3023{58B7B619-8e98-4EAB-941F-B85471A5CEA8}.rpt:
failed to open a rowset.
if i give value as cbe means,the following error will shown
failed to open a rowset.
Details:ADO Error code:0x
source:microsoft OLE DB provider for SQL Server
Desription:Invalid Column Name 'cbe'.
SQL State:42S22
Native Error:
failed to open a rowset.
Error in fileC:\DOCUME~1\WELCOME\LOCALS~1\Temp\temp_be37e2d6-f284-4eaf-8f96-30f6261f3023{58B7B619-8e98-4EAB-941F-B85471A5CEA8}.rpt:
failed to open a rowset.
if i give number instead of characters means,successfully execute.so how to set parameter as characters and how solve this problem?
|
|
|
|
|
Without seeing the actual code, and based on the error message, my guess is, that you are trying to retrieve values the columns named 'bri' and 'cbe'. When you pass a number in the parameter, the code will search by the index, so it works. Apparently you would like to get the column by its name (which is usually the better way to do it).
This means that either the method you are using does not allow retrieving columns by name, or you need to adapt the quotes around the characters you are feeding to the parameter (means more of those or less of those, or single quotes instead of double quotes or vice versa).
good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
hi i am creating an program which have an list and is populated by an database there are multiple fields however i trying to make the display nicer
currently i am doing it like listbox.item.add("data")
however my data is always crampled together i would like to split them up nicely and accordingly
anyone got any idea or advice how todo it?
|
|
|
|
|
neodeaths wrote: however my data is always crampled together i would like to split them up nicely and accordingly
'crampled'?
Your question makes no sense. What is it that you want to do? Listboxes are typically used to display a single column of values. If you want multiple columns, use a ListView control.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
I'm building an XML app in the Windows CE 5.0 environment. But it seems that XPath queires don't work.
For example:
xmlDocument = new xmlDocument()
xmlDocument.load(xmlPath)
xmlNode = xmlDocument.selectsingleNode("//System[@pos='133547']")
And this doesn't return anything, actually it returns Nothing.
This Node and this attribute exist in the file 100%. I can with no problem execute this kind of query ("//System/Specific/Type/") or ("//System/Specific").firstchild.innerText etc...
Any help greatly appreciated.
Thanks!
|
|
|
|
|
code for receive messages in windows form from mobile phone in vb.net
|
|
|
|
|
What sort of message ? Is the phone on the internet ?
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 )
|
|
|
|
|
Hi there,
I'm new to VB ... I want to know how to restrict the values typed into a text box.
for example, i want to allow only numbers to be entered into the text box. If any other character is entered the program should not allow it ... How do I do this ??
|
|
|
|
|
Handle the key press event and reject all non valid values
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 )
|
|
|
|
|
source code present on the same site. check out!
|
|
|
|
|
Ok ... how to handle TextBox.KeyPress events? I mean, what is the syntax for this!
I want to accept only numbers 0-9, Tab, backspace, Delete, and directions only
Thank You,
|
|
|
|
|
http://www.codeproject.com/vb/net/ControllingTextFieldInput.asp
article named:ControllingTextFieldInput
u will have to modify code according to ur requirement
|
|
|
|
|
I am using a web user control with infragistics spell checker to spell check a text box. When I click the image button to invoke the spell check method the screen refreshes and the spell checker form is not displayed. What am I doing wrong?
|
|
|
|
|
1 - asking an ASP.NET in the VB.NET forum
2 - asking here instead of asking Infragistics
3 - asking us to help you without posting any code, so we don't know what you could be doing wrong
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 )
|
|
|
|
|
timescale wrote: What am I doing wrong?
Without seeing any code snippet, who knows.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
It's three files. One is the asp code for the ascx file and the last is the aspx file with the infragistics spell checker designer.
I really wanted to know if you can invoke a method (the aspx file) from a web user control?
|
|
|
|
|
The code works fine when the first file is an aspx file and the second file is an aspx file. When the first file is the aspx file and the second file is the ascx included in the aspx file and the aspx file that spell checks is started from the ascx file the form just refreshes.
|
|
|
|
|
Does anyone know where I can find some sample code that demonstrates a screen capturing routine where the user goes to an area on the screen holds down the left mouse button, drags the mouse over the area they wish to capture and on the mouseup event saves the selected area into a bitmap file?
Thanks,
Quecumber256
|
|
|
|
|
Has a google search brought anything up?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi
I have a large multithreaded Windows Forms application and its leaking GDi objects (VB.Net). The application has a single MDI and multiple forms with multiple tab pages in each form. At any time there is only 1 MDI Child loaded. In the application there are no explicit GDI calls, we do have new fonts getting created but no images etc or any enhanced graphics drawing.
Every time a new form is loaded, the old form is disposed and the contained tab pages are also disposed. We are disposing even the classes. We ran the application with Memory Profiler and have not found any left over objects in the application name space.
Inspite of that the GDI count keeps increasing by ~50 handles every time a new form is opened and closed.
Any help in tracking down the culprit object which is leaking the GDI resources is greatly appreciate.
Thanks
Balakumar
|
|
|
|
|
Balakumar Ponnusamy wrote: we do have new fonts getting created
Do you dispose of them ?
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 )
|
|
|
|
|
Hi
Thanks for the reply.
We have new fonts created like this in the INITIALIZECOMPONENT section of the New Form.
'
'Label46
'
Me.Label46.Font = New System.Drawing.Font("Tahoma", 8!, System.Drawing.FontStyle.Bold)
Me.Label46.Location = New System.Drawing.Point(840, 51)
Me.Label46.Name = "Label46"
Me.Label46.Size = New System.Drawing.Size(32, 16)
Me.Label46.TabIndex = 40
Me.Label46.Text = "S/L:"
Are we expected to DISPOSE of these Fonts too? It seems counter intuitive, and its strange that if we just use the Microsoft Sans Serif (the default font) no New is added.
Thanks
|
|
|
|