Visual Basic

Operation Was cancelled Error

24-Aug-07 6:01

Exelioindia wrote:
Does anybody know how to merge cells in DataGridView

Not supported. You'd have to create your own version of the DGV to do this, supplying the property, drawing, and edit code to render the rows cells and still have them be editable. This will be a LOT of work to pull off.

Merging cells in DataGridView[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

ShuklaGirish23-Aug-07 23:18

ShuklaGirish

23-Aug-07 23:18

i am having my project in vb6.0,i have binded my controls at design time with Maindata(RecordSet).
Now i am binding DataCombo control at runtime(with new RECORDSET),when i am writing this code i am getting error in other events when my maindata(recordset)is getting updated.error is "Operation was cancelled" wt clould be the reason???????

This is the code,
Set PartyData = New ADODB.Recordset

PartyData.CursorLocation = adUseClient

If PartyData.state = adStateOpen Then PartyData.Close

PartyData.Open "select StkSuppliersMaster.name from StkSuppliersMaster join purinqparty on StkSuppliersMaster.code=purinqparty.suppliercode where purinqparty.mastid=(select id from purinqmaster where inqno=" & txtInqNo.Text & ")", db, adOpenStatic, adLockPessimistic

Set dbcParty.RowSource = PartyData

above code works fine if i write,
PartyData.Open "SELECT * FROM StkSuppliersMaster order by Name", db, adOpenStatic, adLockPessimistic

GIRISH

Re: Operation Was cancelled Error

BooleanTrue24-Aug-07 0:24

BooleanTrue

24-Aug-07 0:24

try adLockOptimistic.... May be then it works

colgateas900197

Re: Operation Was cancelled Error

ShuklaGirish24-Aug-07 1:51

ShuklaGirish

24-Aug-07 1:51

thanks for ur reply i will try and let u know.

Re: Operation Was cancelled Error

TomGarth24-Aug-07 11:39

TomGarth

24-Aug-07 11:39

inqno=" & txtInqNo.Text & ")",

You didn't include the character identifiers ( ' ).

Try:

inqno='" & txtInqNo.Text & "')",

Tom Garth
Developer
R. L. Nelson and Associates, Inc., Virginia

Using own cursors in MSVB2005 Express Edition

Manfr3d23-Aug-07 23:14

Manfr3d

23-Aug-07 23:14

Hi guys!
I'm using MS Visual Basic 2005 Express Edition and I want to add a self made cursor to one of my projects. There are already some cursors to choose but there is no option where I can use my own one.
Do you know any way to use a selfmade one (I'm using "IcoFX" and "Pixel Toolbox").

Thanks and best wishes

Message Closed

24-Aug-07 3:03

Nick Rioux

24-Aug-07 3:03

Message Closed

Re: Using own cursors in MSVB2005 Express Edition

Manfr3d24-Aug-07 14:20

Manfr3d

24-Aug-07 14:20

I tried your method but there only appeared a error message.
I found this way to use a cursor: this.Cursor = new Cursor(GetType(), "MyCursor.Cur"); int the MSDN2.
However, this also didn't work. I copied the *.cur file into the project folder, but I cannot add it to the resources, because the program seems not to know *.cur files.
Can it be that the *.cur files aren't reconised as such, I had this problem with icons I wanted to use and to solve this problem I used another icon creator, but I already tried two cursor creators.
Does anyone know what I'm doing wrong?

Thanks and best wishes

Re: Using own cursors in MSVB2005 Express Edition

Nick Rioux25-Aug-07 2:38

Nick Rioux

25-Aug-07 2:38

The method you found on MSDN is in C#. It translates to :
me.Cursor = new Cursor(GetType(), "MyCursor.Cur")
Which is the same method (just a different signature) that I gave you. What is in the error message?
You shouldn't need anything copied into the resources, just somewhere on your computer.
I suggest using the FULL PATH (C:\MyCursor.cur) of the cursor, as it looks like you didn't copy the file to the output directory, and the relative path (MyCursor.cur) isn't pointing to the correct folder.

Fluent in VB, Attempts to speak C#, Python, English Wink | ;)

---
File Association in VB.Net

Creating Custom Controls: Casino Royale

Re: Using own cursors in MSVB2005 Express Edition

Manfr3d25-Aug-07 11:16

Manfr3d

25-Aug-07 11:16

The error message says: "Unhandled exception in this application. Klick "Next" to to ignore the error and countinue with the application. Klick "Finish" to end the application immediately."
I translated it from German so this might not be the exact text.
I found out what I was doing wrong: Instead of single \ I used \\ (I think I know this from C++) and you're right me.GetType() isn't needed.
However, thanks much for your help.

Best wishes

suggest me a control

eyes200723-Aug-07 22:39

23-Aug-07 22:39

hi all

i m developing an application basically a text editor
1. which can able to open files having extension like *.txt, *.csv, *.xls
2. which can able to edit all file that can be opened .
3. which can able to search a string in whole file.
4. and get all these things done as soon as possible (even if the file contains large amount of data)

i try to use rich text box control but that's not satisfying me because the speed of search is down when the file size increases.

if some has any idea then please suggest me

thnx in advance

help everyone

Dave Kreskowiak24-Aug-07 1:58

24-Aug-07 1:58

Again, I ask, how much text are you trying to search?? Size in MB would help.

If you're writing a text editor (are you?), there really isn't going to be anything you can do to make if search faster using the standard controls in the ToolBox. You'd have to find a third party control, but there isn't any way to tell how fast the search is going to be unless you try it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

eyes200724-Aug-07 3:23

24-Aug-07 3:23

not much data
(01,02,03,04,05.....so on) (not known how much user can enter. i will take 5 the limit)

the text to be search is not more then 10 to 15 char long (as i think).

can u suggest me whether i use multi threading of some thing else ....

help everyone

Dave Kreskowiak24-Aug-07 5:40

24-Aug-07 5:40

Multithreading doesn't make code any faster.

If you're using the Find method of a RTB, the ONLY thing you can do to make it faster is to reduce the amount of text you're searching in, NOT the text you're searching for.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

eyes200724-Aug-07 5:48

24-Aug-07 5:48

is it possible to
1. divide the file in number of parts and then run each loop individually in different thread.

one question

how can windows word pad search faster on same amount of data.

help everyone

Dave Kreskowiak24-Aug-07 5:56

24-Aug-07 5:56

Because it's not a RichTextBox. The RTB you're using is a GENERIC RTB box that is not optimized for ANY particular use.

In your case, you'll have to implement your own code for representing the text and searching it. You cannot rely on the RTB to maintain the text string your searching and do the searching for you. You have to come up with your own representation and searching algorithm.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

eyes200724-Aug-07 5:43

What is Wrong in my Datagrid Search Style

24-Aug-07 5:43

The size of text file is about of 10 to 15 MB.

which may or may not contain numeric value.
(the demo file i m working on contains numeric data.)

help everyone

Vimalsoft(Pty) Ltd23-Aug-07 21:44

Vimalsoft(Pty) Ltd

23-Aug-07 21:44

Hi All, its me who is Stucked now Confused | :confused:

am using vb 2003. am searching the grid, i have a normal Search and a Advanced Search. my normal search is working fine and return the required results. on my advanced Search and using textboxes to search the grid. The following code is the SQl statement passed to the adapter.

SELECT Primary_ID, Boundary_area, Attrib_Code, Lis_Key, Func_Key, Actual_Extent, Improved_Value, Site_Value, Purchase_price, Purchase_date, prop_id, confidence_score, fin_ls_prediction, new_lis_key, new_func_key FROM Property_mass WHERE (SUBSTRING(Lis_Key, 1, 4) = @Num_key) ANd (SUBSTRING(Attrib_Code, 1, 1) = @Pair1_1) And (SUBSTRING(Attrib_Code, 2, 1) = @Pair1_2)

And the Following code is the code in my Search Button.

Dim strErrorMsg As String
        Dim strerror As System.Data.SqlClient.SqlError

        Try
            SqlDataAdapter2.SelectCommand.Parameters("@Num_key").Value = CStr(txtlisSearch.Text)
            SqlDataAdapter2.SelectCommand.Parameters("@Pair1_1").Value = CStr(pair1_1.Text)
            SqlDataAdapter2.SelectCommand.Parameters("@Pair1_2").Value = CStr(pair1_2.Text)

            'Filling the Dataset

            SqlDataAdapter2.Fill(Pairone1)
            If Pairone1.Tables("Property_Mass").Rows.Count = 0 Then
                MessageBox.Show("Property with Such Code in this pair was not Found")
            Else
                Pairone1.Clear()
                SqlDataAdapter2.Fill(Pairone1)
                DataGrid1.DataSource = Pairone1
            End If
        Catch ExSQL As System.Data.SqlClient.SqlException
            ''''All this will trap all data Problems and Network if available
            For Each strerror In ExSQL.Errors
            Next
            Select Case strerror.Number
                Case 17
                    strErrorMsg = "Missing server"
                Case 4060
                    strErrorMsg = "Missing database"
                Case 18456
                    strErrorMsg = "Missing user name or password"
                Case Else
                    strErrorMsg = strerror.Message
            End Select
            MessageBox.Show(strErrorMsg, "SQL Server Error: " & strerror.Number, MessageBoxButtons.OK, MessageBoxIcon.Error)

        Catch ExcpInvOp As System.InvalidOperationException

            MessageBox.Show("Close the connection first!", "Invalid Operation", MessageBoxButtons.OK, MessageBoxIcon.Error)

        Catch Excp As System.Exception ' generic exception handler
            MessageBox.Show(Excp.Message, "Unexpected Exception", MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try

In this code, there are Errors,but the bring incorrect results. i tried the SQL statement passed to the adapeter in SQl and replaced the variables with values and it working fine, now from my above code, i think the Problem should be here

SqlDataAdapter2.SelectCommand.Parameters("@Num_key").Value = CStr(txtlisSearch.Text)
        SqlDataAdapter2.SelectCommand.Parameters("@Pair1_1").Value = CStr(pair1_1.Text)
        SqlDataAdapter2.SelectCommand.Parameters("@Pair1_2").Value = CStr(pair1_2.Text)

        'Filling the Dataset
        SqlDataAdapter2.Fill(Pairone1)

but i cant understand how.So i have some questions.
1: IF the user has not inserted the value in e.g pair1_1 textbox, can it be ignored and run the query based on what it had been supplied.meaning cant we make this values optional?

Vuyiswa Maseko

Dave Kreskowiak24-Aug-07 5:54

24-Aug-07 5:54

Vuyiswamb wrote:
IF the user has not inserted the value in e.g pair1_1 textbox, can it be ignored

The only way to ignore the condition is it's removed from the SQL statement's WHER clause.

Vuyiswamb wrote:
.meaning cant we make this values optional

SQL doesn't support optional parameters.

You basically have to generate the SQL string dynamically, adding just the conditions that are supplied by the user.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Vimalsoft(Pty) Ltd26-Aug-07 20:06

Vimalsoft(Pty) Ltd

26-Aug-07 20:06

|Dave Kreskowiak wrote
The only way to ignore the condition is it's removed from the SQL statement's WHER clause.

how am i going to return the user's required results if i dont use where in my SQl statement?

|Dave Kreskowiak wrote
You basically have to generate the SQL string dynamically, adding just the conditions that are supplied by the user.

How dynamically, i dont understand.please post an example code or point to an article.

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding

Dave Kreskowiak27-Aug-07 12:09

27-Aug-07 12:09

Vuyiswamb wrote:
how am i going to return the user's required results if i dont use where in my SQl statement?

You said you want the statement to ignore certain parts of the WHERE clause. Since you can't do that, you have to REMOVE THOSE PARTS FROM THR WHERE CLAUSE.

By removing certain conditions from the WHERE clause, this:

SELECT someColumn1, someColumn2, someColumn3 FROM table WHERE condition1 AND condition2 AND condition3

becomes:

SELECT someColumn1, someColumn2, someColumn3 FROM table WHERE condition1 AND condition3

Vuyiswamb wrote:
How dynamically, i dont understand.please post an example code or point to an article.

Check each part of the UI for a value entered by the user. If each condition, add it to the end of the SQL statement. Greatly simplified, it looks like:

Dim mySQLstring As String = "SELECT someColumn1, someColumn2, someColumn3 FROM table WHERE"
If someCondition Then
    mySQLstring = mySQLstring & " condition1 "
End If

If someCondition Then
    mySQLstring = mySQLstring & " AND condition2 "

This logic will NOT work!! If makes certain assumptions about the presence of the "WHERE" in teh SQL statement and doesn't check to see if an "AND" is required between conditions!!

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007