Visual Basic

FirstPrevNext

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. Re: Error while trying to run project Steve Pullan1-Dec-05 17:45 Steve Pullan 1-Dec-05 17:45  just search Google for this: Error while trying to run project:unable to start debugging. There are many hits for that error most of which point to problems with the web server configuration. Maybe the type of project you are building is not a Windows application but a Web application? These are two different beasts. ...Steve VB 6 Windows Services running in WinXP Environment miceisland30-Nov-05 15:57 miceisland 30-Nov-05 15:57  Hi, need help, I created a vb6 program that utilized the ntservices component, so that it can run in windows services, i also include a timer control so that the program will run on a specified time, BUT i setup to run at 6am in the morning, PROBLEM my program does not activate on the specified time, is this anything got to do in Windows XP environment, but when i restarted the services, then my program will run. any recommendation on how to troubleshoot this problem, many thanks Michael Re: VB 6 Windows Services running in WinXP Environment miceisland30-Nov-05 21:05 miceisland 30-Nov-05 21:05  I have tried to re schedule it at 8am, and it works, but when i schedule it about 6am, it does not work again. hmm any recommendation how to troubleshoot this problem, i was suspecting if its got to do with the power management? Mike Re: VB 6 Windows Services running in WinXP Environment Dave Kreskowiak1-Dec-05 6:13 Dave Kreskowiak 1-Dec-05 6:13  How are you using the Timer? Are you checking the current time every minute with it or did you sent the Interval to the difference in time between when the service starts and the target time? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: VB 6 Windows Services running in WinXP Environment miceisland1-Dec-05 22:18 miceisland 1-Dec-05 22:18  Yeah, i was actually checking the time every minute, program actually should run once everyday at 6.00am. if the program checks if 6:00am or greater, then it should run some procedure.

Last Visit: 31-Dec-99 18:00     Last Update: 24-Apr-24 12:21 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.