Visual Basic

FirstPrevNext

Re: Help for efficiently populating a listview jan larsen1-Dec-05 9:48 jan larsen 1-Dec-05 9:48  DON'T put 60.000 rows of anything in any sort of control You mention that your control is a custom control. I advise that you find some way of paging the data. I recall that there are some good articles here on CP on paging that you could moderately easy tweak to suit your control. "God doesn't play dice" - Albert Einstein "God not only plays dice, He sometimes throws the dices where they cannot be seen" - Niels Bohr Re: Help for efficiently populating a listview eatwork2-Dec-05 6:34 eatwork 2-Dec-05 6:34  Hi Mr.Larson, Thank you for your response. I have begun recoding my form to only populate the listbox after an event has fired to limit the # of rows that will be populated. Thank you for your help. eatwork Re: Help for efficiently populating a listview Joshua Quick1-Dec-05 11:54 Joshua Quick 1-Dec-05 11:54  Hmmm... that's a tough one. It looks like your doing all the right things. You have your BeginUpdate() and EndUpdate(). Also, AddRange() is the fastest way to add items to your ListView. I measured this several months back, and AddRange() was about 20 times faster than individual calls to Add(). The ListView is really just a wrapper over Window's list control. Perhaps the thing to do is to make direct win32 calls via P/Invoke, which would avoid the overhead. However, the marshalling involved with doing P/Invokes adds overhead too. So that might not be fast enough either. (I don't think you can make unmarshalled/unmanaged calls to win32 libraries in unmanaged blocks in C#, but don't quote me on that.) Of course, the easiest solution would be to add a progress control here. That is if you can get away with it. Re: Help for efficiently populating a listview eatwork2-Dec-05 6:32 eatwork 2-Dec-05 6:32  Hi Mr.Quick, THank you for your response. The reason I asked this was that I can add the records to a combobox via its datasource way faster and was curious if there was a method to add a datasource to a listbox in the same way to improve the performance. Thanks for your help. eatwork quick newby .NET compact framework question garbeechio1-Dec-05 8:04 garbeechio 1-Dec-05 8:04  I'm a newby to mobile development and was needing a hand figuring out how to load images into a pictureBox control at runtime, I had originally solved the problem using an imageList but decided the constraint of having a uniform size for each image in the list was not even close to ideal. Thanks a bundle in advance for your help. BMW mannual crystal report smdbt1-Dec-05 7:23 smdbt 1-Dec-05 7:23  i am trying to fetch the data for the crystal report at the runtime by adding a crystal report viewer and ten givin OleDbDataAdapter1.Fill(DataSet11) DataGrid1.DataSource = DataSet11 Dim cr As New CrystalReport1() cr.SetDataSource(DataSet11) CrystalReportViewer1.ReportSource = cr also i have created manuual connections , but no data is getting fetched in the report where as it is working fine vth a datagrid. What is the problem? also please help me in using parameterized qurries for crystal reports???/ updatind data from a datagrid smdbt1-Dec-05 7:07 smdbt 1-Dec-05 7:07  i have created a datagrid on a windows form using vb.net. It is showing the data after retrival from a table. but now i have added a button --update changes and now i want that when the user changes anything in the datagrid it should get updated in the database. how can we do this? UNBOUND OBJECT FRAME IN MICROSOFT ACCESS PROGRAMMING Jkkenzie1-Dec-05 7:03 Jkkenzie 1-Dec-05 7:03  Would like some code to find an image or a picture from a folder in the computer and place it on a form or an unbound object frame in Ms Access Application. Thanks in advance. Regards Joseph Joseph K. Mckenzie automatically click a button in datagrid row wsturdev1-Dec-05 2:59 wsturdev 1-Dec-05 2:59  I have a web form with 2 datagrids. DataGrid1 has a few columns, the first of which is a button that, when clicked, causes DataGrid2 to be filled accordingly. The logic works fine. Upon entry into the form, and immediately after filling DataGrid1, which will always have at least one row, I would like to "auto-click" the button in the first row. How can I do this? Bill Re: automatically click a button in datagrid row lavanya_satheesh1-Dec-05 18:50 lavanya_satheesh 1-Dec-05 18:50  u mean when the from is loaded datagrid2 must b filled with the data that corresponds to the value of the first row of the datagrid1 right? i am not sure but i think you can retrive the desired cell of the datagrid using the code: datagrid1.item(rownumber,columnnumber) using this write the query to fill the second grid at the form load event itself. this is what i can think of. pls let me know if this works. Re: automatically click a button in datagrid row wsturdev2-Dec-05 1:34 wsturdev 2-Dec-05 1:34  Your summary of what I was trying to do is correct. This is what I found that works: Dim button As Button = DataGrid1.SelectedItem.Cells(0).Controls(0) varWhatever = button.Text If I get the chance I will try your suggestion and get back to you Saving data of datagrid for VB.NET Pravin H1-Dec-05 1:52 Pravin H 1-Dec-05 1:52  I have populated my datagrid and made some changed in our data now I want to save it to my database, don't have any idea how to? I am using dataset. serial no. in datagrid row header. abhinish1-Dec-05 1:31 abhinish 1-Dec-05 1:31  Hi guys! need some help from u guys can any one tell me how to add serial no in datagrid row header in vb.net datagrid as same as in sql2000 results pane when viewed in grid view .. need it urgently. bye. abhinav Re: serial no. in datagrid row header. lavanya_satheesh1-Dec-05 18:53 lavanya_satheesh 1-Dec-05 18:53  can u eloborate it a bit? Re: serial no. in datagrid row header. abhinish1-Dec-05 20:50 abhinish 1-Dec-05 20:50  i'll try actually i have a datagrid in one of my window form. what actually i want is that when the data grid is populated there should be a serial no. before every row of grid like we have column names in Column header property of datagrid. is there any way to add serial no in row header property like it is in sql 2000 result pane when viewed in grid view with ctrl+d + f5 with any select statement. abhinav Can we send a datagrid's records directly to the database? lavanya_satheesh1-Dec-05 0:28 lavanya_satheesh 1-Dec-05 0:28  hello all, this could be a stupid question. but for me it is a headache. i've been trying to do it for some time with no luck. i have got a datagrid with some data. i want to write the code to send the rows of data directly into a table on the click event of a button. how is this possible. if anyone knows how please do help me. thanks Re: Can we send a datagrid's records directly to the database? Pravin H8-Dec-05 1:58 Pravin H 8-Dec-05 1:58  First count the no of row in dataset dim rowno as integer = dataset.row.count for rowno = 0 to rowno 'creating a loop dim strval as string=datagrid.items(row#,coloum1).tostring dim insert as string = "insert into table(field)values(strval)'write the insert command here cmd1 = new oldbcommdbuilder(insert) cmd1.nonexecutereader next hope it helps you If you still have any questions let me know i will give you detailed explanation. take care Regards Re: Can we send a datagrid's records directly to the database? lavanya_satheesh8-Dec-05 17:03 lavanya_satheesh 8-Dec-05 17:03  hi, thanks for ur help. right now i am in another project team doing a project in asp.net. i will try out ur solution and let u know. thanks, lavanya how to Bind 2 Tabels to one DataGrid ? microuser_20001-Dec-05 0:03 microuser_2000 1-Dec-05 0:03  hellow to all ... i wana to Bind to a Datagrid 2 tabels , i had used the JOIN Statment and the statment run fine , just when i wana bind the datagrid to the tabel i can't select 2 tabels at one to bind them . i am useing this method to bind the tabel to a datagrid Dim sqlMarkups As String Dim ds1 As DataSet = New DataSet Try sqlMarkups = "The sql join statment" Dim conSQL As New SqlClient.SqlConnection(sConn) Dim daMarkups As New SqlClient.SqlDataAdapter(sqlMarkups, conSQL) Dim dsMarkup As New DataSet daMarkups.FillSchema(dsMarkup, SchemaType.Source, "tabel") daMarkups.Fill(dsMarkup, "tabel") grdComplaintlist.SetDataBinding(dsMarkup, "tabel") Catch ex As Exception MessageBox.Show(ex.Message) End Try thxx for any help .. -- modified at 6:04 Thursday 1st December, 2005 Re: how to Bind 2 Tabels to one DataGrid ? lavanya_satheesh1-Dec-05 19:27 lavanya_satheesh 1-Dec-05 19:27  i dont know if this will help u or not. i dont know how to use the .FillSchema but the code i am posting worked fine for me. Dim sqlcon As New SqlConnection(constr) Dim sqladp As New SqlDataAdapter Dim cmdstr As New SqlCommand Dim dsdata As New DataSet Dim strq As String sqlcon.Open() strq = "SELECT C.BillNo,C.BillDate,C.Customer,P.PID,P.PName FROM BillCommonDet AS C JOIN BillProductDet AS P ON (C.BillNo = P.BillNo)" Try sqladp.SelectCommand = cmdstr sqladp.SelectCommand.CommandText = strq sqladp.SelectCommand.Connection = sqlcon dsdata.Clear() sqladp.Fill(dsdata, "SearchResult") If dsdata.Tables("SearchResult").Rows.Count > 0 Then DataGrid1.DataSource = dsdata DataGrid1.DataMember = "SearchResult" DataGrid1.Refresh() End If cmdstr.Dispose() sqlcon.Close() sqlcon.Dispose() sqladp.Dispose() Catch empexp As SqlException MessageBox.Show(empexp.Message) End Try hope this is of help to you. Regards, Lavanya Select row in Datagrid bhavanamshah30-Nov-05 23:56 bhavanamshah 30-Nov-05 23:56  I am net to VB I am using a MS Datagrid in my application. I wish to programatically select a row in the datagrid. If the row is visible my code works fine but i dont know how to point out to a row which is not visible in the datagrid as it has been scrolled up or down. Bhavana newbie in VB.NET Soniam30-Nov-05 23:19 Soniam 30-Nov-05 23:19  hi ... I'm familiar with vb6.0 but completely newbie in vb.net... I'm interested in learning it, of course learning Object Oriented Programming methods by it not only vb.net syntaxes.... what is your opinion...? what is my first step? please help me Thank you very much for any suggestion Sonia Re: newbie in VB.NET Joshua Quick1-Dec-05 11:34 Joshua Quick 1-Dec-05 11:34  Sounds like you need to absorb as much material as possible. Regarding object oriented programming, I suggest that you read books/articles on "design patterns". This is a very valuable skill to learn. In fact, you might want to take a class on this, because I think the best way to learn it is by practicing it. It's usually taught in C++ or Java, so watch out. In regards to VB.NET, it's not enough to just learn the new syntax. You need to learn about the .NET framework as well. I highly recommend the following book (although it's for .NET 1.1): "Programming Microsoft Visual Basic .NET, Version 2003" http://www.amazon.com/gp/product/0735620598/qid=1133475906/sr=1-1/ref=sr_1_1/103-3239437-9033428?s=books&v=glance&n=283155[^] Re: newbie in VB.NET dptalt2-Dec-05 2:20 dptalt 2-Dec-05 2:20  Also, browse through the threads on this site regularly. Error while trying to run project alwinSCH30-Nov-05 21:21 alwinSCH 30-Nov-05 21:21  Hello, I made a simple Windows Form in VB.NET, just a button, no code because i'm new in VS2005 and was trying to see some features! Now when trying to run this project, i get an error "Error while trying to run project:unable to start debugging" and now a translation of the explanation below "the bindings entrance is invalid" ---- "de bindingsingang is ongeldig" Don't know what to do know! Thanks, A.

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 3:50 Refresh ᐊ Prev1...3752375337543755375637573758375937603761 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.