|
If you're not willing to do it the way that has been suggested, then I'd recommend black magic, it's as likely to work as anything else, once you've excluded the right way of doing things.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
I am using an SQLDataadapter in my app, with a query. Something along the lines of:
SELECT * FROM MyTable WHERE MyTable.MyField IN ('ABC', 'DEF', 'GHI')
The number of items in the IN bit is variable as well as their respective values.
Usually with a parameterized query I would use @MyParameter in the query and then
SDA_MyAdapter.SelectCommand.Parameters("@MyParameter").Value = "ABC"
This doesn't work however when I try:
SDA_MyAdapter.SelectCommand.Parameters("@MyParameter").Value = "ABC, DEF, GHI"
Can I use this principle at all in this case, and if yes, then how?
If not, then how else can I do it using good VB.NET practices?
All help and suggestions appreciated,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Not sure, but is the problem occurring in any other test cases, such as ones without the , being used...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi Paul,
I have tried the following variants:
- "ABC,DEF,GHI"
- "ABC, DEF, GHI"
- "'ABC','DEF','GHI'"
- "'ABC', 'DEF', 'GHI'"
In all cases the hard coded query will return results but not the parameterized one.
How would you propose to do it without commas?
Best Regards,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi,
I have coded a small desktop based windows app which parses a flat text file and generate a word document with some values from the said file. The code contains lots of loops and huge string manipulation and its 438 lines of code. The problem is when I checked task manager, its eating memory worth 20MB !!
So, any ideas, suggestions, checklists in this situation how to decrese occupied memory by the program from string manipulation perspective?
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
|
Arindam Giri wrote: The problem is when I checked task manager, its eating memory worth 20MB !!
And.... If it was eating 20Gb I'd be worried, but 20Mb is nothing. Also, remember that what you seen in the task manager is the amount of memory the application has reserved from the OS. Not what is actually used.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
Thanks Colin.
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
|
intensive programs use 150 +, you've got nothing to worry about, if it was that i'de be worried, but 20 is ok. Task manager also isn't always accurate, as was said, it is what is eserved and often a little extra as a buffer.
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
Thanks.
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
|
Make sure you use stringbuilder instead of string where-ever it makes sense ( like when you're building a big string out of lots of little ones ). But, as the others said, 20 MB is not a whole lot.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks Chris for the info.
--------------------------------
**** JOB23743 Submitted ****
|
|
|
|
|
Hi,
I have a control, which contains a flow panel, with textboxes being added dynamically at runtime.
The flow panel docking is set to fill the control, and its flow direction is set to TopDown.
I want the control to be scrollable, incase there are more textboxes added at runtime than fit the original size.
So I enable Autoscroll for the FlowPanel.
However, I get both updown and leftright scrollbars.
I simply just want the updown scrolling.
Anyone know how I can force this, or find a way around it?
Any response gratefully appreciated
|
|
|
|
|
If the contents of the panel fit within the width of the panel then the horizontal scrollbar shouldn't appear. I just tested this out of curiosity.
Are you sure the contents aren't being clipped horizontally? Perhaps an overhanging label?
Otherwise you could expand the panel until all contents fit.
I'm largely language agnostic
After a while they all bug me 
|
|
|
|
|
my application should copy specfic row at click event
and i used find method to search rows
my code as follows:
for each dr as datarow in sourcetable.rows
dr=sourcetable.rows.find(textbox1.text)
r=destinationtable.newrow
r("column1")=dr("column1")
r("column2")=dr("column2")
r("column3")=dr("column3")
destinationtable.rows.add(r)
next
but when the code executed the destinationtable rows exceeds according to the source table rows count .
all i need is to copy the displayed row (one row at time)
many regards
|
|
|
|
|
The reason for this behavior is quite simple. In your code you loop through all the lines in the source table, and you always add a new line.
dr=sourcetable.rows.find(textbox1.text) seems a bit strange to me. dr already represents a row from sourcetable (because of the loop), but you try to assign it a value from that same table.
If the line dr=sourcetable.rows.find(textbox1.text) even works at all you need to forget about the loop. Otherwise try something like:
For Each dr as DataRow in sourcetable.Rows<br />
If dr.Item("Name_of_the_column_you_are_searching") = textbox1.Text Then<br />
'create the new row according to you code<br />
'so a new row only gets created when<br />
'textbox1.Text is found in the sourcetable<br />
next
Hope this helps,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
thanx johan
i'll try your code
regards
|
|
|
|
|
i want to grid control for a form for backend of xml can i able to do ?
pls explain if yes means how ?
sathish
|
|
|
|
|
Why would you want to use msflexgrid ? .NET is full of grids, which can take XML as a data source.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I want to multiple entries like record type and i want to store it in xml that only i want to use flexgrid with xml
sathish
|
|
|
|
|
That made absolutely no sense at all. MsFlexGrid doesn't handle XML and neither does the DataGrid or the DataGridView in the .NET Framework. The XML is handled by the DataSet and DataTable classes, which are bindable datasources for the DataGrid and DataGridView classes. They won't work with the older-than-dirt FlexGrid.
|
|
|
|
|
hi all
i am using notepad to make a web page
so please tell me how i can connect to database mysql from notepad
thanks![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
hi
|
|
|
|
|
You can't connect to a database from notepad.
If you mean how to write code to connect to the database, there are thousands of examples out there. Just google for something like "vb.net connect mysql". When you have looked at some of the examples, you can come here with more specific questions that are more suited to be answered in a forum.
---
single minded; short sighted; long gone;
|
|
|
|
|
paras_s12 wrote: how i can connect to database mysql from notepad
It cannot be done.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i have a textbox for user key in the value, but i need to convert the data into two decimal place, for example,
user input: 123
then i will put this input to a function to convert it into 123.00
user input: 123.456
then i will put this input to a function to convert it into 123.45
how i code this function ?
Regards,
Chee ken
|
|
|
|
|
Dim Result as Decimal = Ctype(FormatNumber(UserInput,2), Decimal)
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
