Comments by Shahan Ayyub (Top 83 by date)

Please make sure you are not putting username and password or your live connection. It would be accessible to others and you might be in trouble.

ASP.Net ?

We need more from your side, we can not see your screen access your HDD. :) Please describe your problem in more detail so then we can assist you. Also, not the downvoter.

@saikishore1979007, beside this solution i just ended up a brief solution on how to append the new result set with the previous one here: http://shahanayyub.wordpress.com/2014/03/30/how-to-load-large-dataset-in-datagridview/ with a bunch of performance evaluation. Hope it helps!

Check out each point of the updates.

What is the type of `dob` and which namespaces have you imported? Which framework you are using and is it a compile time or runtime error ?

Thanks. :)

@akosibogart, I think it is more appropriate to use `String.IsNullOrEmpty` rather than `xyz = Nothing`. See the updates.

Hi! As you said "it doens't seem to work properly for whatever reason", what is expected to you. current code is expected to remove the whole row if it is completely empty. Cell is somewhat is an interaction of a row and a column so you can either remove row or delete a column. What else do you expect ?

You are still missing "Exit for" after "chkCOl = True" otherwise there will be a lack in performance. Every time your loop will run till the end when you are only interested in finding either checked or unchecked. Hope it makes sense :)

Is this Windows Forms ? or Web Form ?

I assume you are talking about DataGridViewComboBox column? You have three DataGridViewComboBoxColumn? Is this the case ?

Try using my approach...

What is the error ?

See without Windows credentials you can not even login to others system so this is not possible, if lacking Sql credentials, you can TRY using command line tool to take backup, http://www.howtogeek.com/50295/backup-your-sql-server-database-from-the-command-line/

I am a bit confused you are lacking of Windows account credentials or Sql Server credentials ? Are you trying to to take back from VB.Net of from SQL server directly ?

can you send the snap shot of the error screen ?

Can you please share your code with us ? I am still not clear that if you are already using these guidelines and having some trouble using them or the below guidelines resolves this thread.

Have you used "Timer.Enabled" property to stop timer ?

Try setting up SQL so that the system can have these supported files available, which is required to run your script(s).

Do you need an instant reflection in the DB or you can afford manipulation at the end of the day ? If yes then it will be easier for you to workaround this issue.. Is it possible ?

Will you also run this software continuously ?

Is SQL Server installed on client machine ?

Currently I do not have some sample code but I guess DataGridView.HitTest fucntion can help you to start with this.

hi!
Can you split it with ")>md" and access (n-1)th index, if it exists ? and use the pattern i have given to you ?

Which one regex you are talking about? have you taken substring ?

As per your provided details: " i want to find ticket number after last )>md and before )md " I was expecting that you are in need of last few ticket numbers(as per the given range in question), and i believe if you are going to make a substring it won't have an impact on your original string(so you still have a history) and above solution will give you the last ticket number between the MDs you have mentioned.

Reason for my vote of 5 \n Thanks for sharing it

In 2nd query, try enclosing value of "Dset3.Rows(0).Item("PaPeR_Type")" in "[ ]" something like the example in below link. Check out how they write [MON],[TUE],..... etc. http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx

Which of the above query causes problem ? can you post the query you get in 'strSQL3' and 'strSQL4' variables ?

can you please try:
1) datagridView1.CurrentCell = dataGridView1.Rows(MentionYourRowIndexHere).Cells(1)
2) datagridView1.Rows(MentionYourRowIndexHere).Cells(1).Value = "" ' or use String.Empty

In datagridView you can omit line 1 and directly use line 2.

Can you please elaborate more ? Please tell us about your intentions that is what you are trying to achieve. So we we can provide you a guideline or some sample code.

may I ask why a down vote, if it helps ? did you do that ?

Is your issue resolved ? If no, what is unexpected to you when running a case of UPDATE ?

Please also mention if its a Web application or windows based application

Is it clear now ?

If you noticed my updated solution you will see i have not cleared Rows of grid. so if "RetrieveDataTable" retrieves data for id=1 and filled grid, later user entered id=2, here rows are "as it is". So "DataGridView1.Rows.Add()" will add another row in grid with data of id=2. Now you have two rows in grid one for id=1 and one for id=2.

I assumed "RetrieveDataTable" is a method that will fetch data from database according to the id user entered. Say for example user enter id = 1. this method will retrieve all info related to id=1 in datatable using SqlDataAdapter.Fill method. In next step you can iterate using for loop on all rows exists in DataTable and call DataGridView1.Rows.Add() method to append these row at the end of datagridview. Is it clear now ? In case no please provide details about the issue which is still unclear.

How do you do :
>>according to ID data is getting filled in the DataGridview.
I mean to say how do you populate data in row ? Have you tried to add a new row in grid and target it to populate with data ?

Reason for my vote of 5
nice work!

Have you used "RemoveHandler" in designer.vb or .vb file ?

you have to add this line at the top of your .vb file:
Imports System.ServiceProcess

glad to see your issue resolved! :)

Any updates ?

What about now:

DateTimePicker2.MaxDate = DateTimePicker.MaximumDateTime ' reset range before setting
DateTimePicker2.MinDate = DateTimePicker1.Value
DateTimePicker2.MaxDate = DateTimePicker2.MinDate.AddMonths(5)

The code I suggested will take the whole month, say you have selected 25 jan 2012 in datetimepicker1 so datetimepicker2 will start from 1 jan 2012. Is it the desired case ?

My understanding is that the error should come here:

DateTimePicker2.MinDate = New DateTime(Yr, Mon, Days)

because "Days" contains the number of days in a month of a particular year. So if its a January it will be 31 and do not exists in February. Have you tried changing this to:

DateTimePicker2.MinDate = New DateTime(Yr, Mon, 1)

That is, take the month from start as mindate.

I have just re-checked the code it seems to working fine. Can you post your code ? Also, if you could provide few more lines other than the affected line. It would be great to troubleshoot the issue. Also, Can you tell us which date have you selected ?

What error did you get ?
Have you tried something like this :

Dim daysInMonth As Integer = DateTime.DaysInMonth(DateTimePicker1.Value.Year, DateTimePicker1.Value.Month)

It will print the days in month from the date chosen from datetimepicker1 control.

Do you mean something like "Windows Explorer" in which at the left pane we have a tree view and in other part we have a list view ? The better you will explain the more quick and accurate will be the response.

>>Can it cause so much flicker
Yes it can. It is never recommended to load large amount of data on form load. May be loading too many pictures at Form_load causing this issue. Have you tried Form_Shown event ? or Have you tried using Application.DoEvents() ?

Do you mean something like "WordArt" in MS Word ?

Have you used Application.DoEvents() some where ? or are you using loop to load something ? Does it flicker continues unless you close app or it flickers for some amount of time then becomes stationary ?

If "b" is an integer collection than what if some one enter "some text here" in textbox27 and this line:

b.Add(textBox27.Text)

will definitely fail to add it to the collection with following error:
"Conversion from string "some text here" to type 'Integer' is not valid."

So my understanding is to have a use of VAL function, IF the end result is going to convert in SQL int datatype, since the error "Error converting data type nvarchar to int." seems to be a sql error.

Issue is not to vote them up again issue is to find who have issues. I guess we should look other questions.

no idea who have down voted my 5 posts within one min or less ( How quick he/she is :) ). please suggest them to use "improve solution" link (if possible) since you are senior forum user.

It is not good if there are series of elements, but in case of two it can be used.

used your suggested code example and your suggested procedure. I have pointed that you should provide correct details rather than involving asker into another issue as you can see asker could not resolve the error message. For your point related to casting and its understanding what i mean is not you don't know better or i know more than you, but as an expert provide appropriate and direct solutions. I can run your code but not sure if asker can. If any one has issue with solution they have right to down vote.

Have you run your solution ? it says "Failed to convert parameter value from a String to a Int32." since @taxitemid is type of int. Also @val is not defined.

can we get more details (piece of code) about how you are dealing with the case ?

have you tried jQuery ?

how do you parse the string ? i.e., "strWaarde(0)" which is passed in "select case". Once you have this case:
"ADR;WORK;PREF:;;"
the substring till the next ";" will be your desired result. Have you tried that ?

More preferably, if nodes contains child node then a recursive lookup should be use like this: (only TreeView_ItemDrag event need to be changed)

Private Sub TreeView1_ItemDrag(ByVal sender As Object, ByVal e As System.Windows.Forms.ItemDragEventArgs) Handles TreeView1.ItemDrag
If (CType(e.Item, TreeNode).Parent Is Nothing) Then
Dim nodes As TreeNodeCollection = CType(e.Item, TreeNode).Nodes
DoRecursiveDragDrop(nodes)
Else
DoDragDrop(e.Item, DragDropEffects.Copy)
End If
End Sub

Private Sub DoRecursiveDragDrop(ByVal nodes As TreeNodeCollection)
For Each node As TreeNode In nodes
If (node.Nodes.Count > 1) Then
DoRecursiveDragDrop(node.Nodes)
Else
DoDragDrop(node, DragDropEffects.Copy)
End If
Next
End Sub

can you provide a sample of your expected text after processing ?

Superb Imran. This is what I need.

Thank you!

I maintains backup but I did not took backup since last week and I have a dozen of updates in it within this time period. So is it possible to get the data back with your suggested solution ?

Did you tried to use 'try...Catch' Block ?

Did you try step debugging on 'cancelDVD_Click' ?

I have read the whole discussion 'now'. Didn't see the comments along with the code. But still i was thinking from different point of view regarding iteration and exception on for loop and for each loop.

which one RaisKazi ?
I didn't see. Is this the copied ? I have seen the very first (all pages) now but didn't find a exact solution. :S

I did this kind of work when i removed empty rows from datatable. So placed here.

could you please provide more information? samples?

did you try setting:
i=i-1
after deletion?

Do you have a specific format defined for table name ?
Like:
t_Table1
t_Table2
OR
tbl_Table1
tbl_Table2

etc...

Kindly clarify your intentions a bit more, so that we could give you a guideline or solution.

>>>When I fetch the data from the data base

Are you working with ADO.Net and need help on that ?

In your question you have this at the end of each row:
38
20
83
0
Is this the "new column" ? or you have concatenated it to the second column with <space> ? Kindly mention it in you question.

Kindly let us know about at which point you have issues. Are you iterating over gridview rows ?