tag:blogger.com,1999:blog-79721055781557992312023-11-15T10:00:57.465-08:00how to datagridCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.comBlogger167125tag:blogger.com,1999:blog-7972105578155799231.post-9916333664537122812010-08-20T23:25:00.002-07:002010-08-20T23:25:33.799-07:00Pls help me out.. i have doubt in C#?hi every body.. i want to know how to fetch a particular data from a text file.. not the entire file and place those datas into some control like datagrid or dataview using C#.Net... pls help me out how to do this..Pls help me out.. i have doubt in C#?<br >u fill use System.IO namespace for that<br><br /><br /><br><br /><br />i know vb.net,in vb.net i can do it.but i can read the first line<br><br /><br /><br><br /><br />fileiovar.readline()<br><br /><br /><br><br /><br />but i dont know how its in c#<br><br /><br /><br><br /><br />if u want a part in a text file u can look for searching-techniques.but im sure its all about System.IOPls help me out.. i have doubt in C#?<br >Read data connections using text drive r..this may help you out..<br><br /><br />Have a nice day<br >StreamReader class can be used for retrieving data from the text file. The programming logic varies depended on the type of data file. <br><br /><br /><br><br /><br />IF You have no idea the actual data, but the data type is xml or html. You need to know its open tag and close tag, and the data is being placed between them. Following is the example in C#.NET in handling xml file.<br><br /><br />--------------------------------------鈥?br><br /><br />int iopentag;<br><br /><br /> ' this is for recording the position of opening tag<br><br /><br />int iclosetagpos;<br><br /><br /> ' this is for recording the position of closing tag<br><br /><br />string stropentag = ';%26lt;name%26gt;';;<br><br /><br />string strclosetag = ';%26lt;/name%26gt;';;<br><br /><br />string strxmlcontent; (the file is in binary format, you need to encode it to text, otherwise it will not work. I can't remember how to do it at moment.) <br><br /><br />string stractualvalue;<br><br /><br />int inumberofcharacterstostrip; <br><br /><br /> 'This value is to determine how many characters to strip<br><br /><br /><br><br /><br />iopentag = strxmlcontent.indexof(stropentag);<br><br /><br />if iopentag %26gt; -1 {<br><br /><br /> if iclosetag %26gt; -1 {<br><br /><br /> inumberofcharacterstostrip = iclosetag - iopentag - stropentag.size;<br><br /><br /> stractualvalue = strxmlcontent.substring(iopentag + stropentag.length, inumberofcharacterstostrip);<br><br /><br /> }else{<br><br /><br /> Message.show(';This file is invalid!!!';);<br><br /><br /> }<br><br /><br />}<br><br /><br />///////<br><br /><br />This is an example of retrieving one data from the text file. In the realworld situation, the pesuedo-code is as follow:<br><br /><br />--------------------------------------鈥?br><br /><br />Get the current postion of opentag<br><br /><br />Do while current position is greater than zero<br><br /><br /> If the end tag position is greater than zero then<br><br /><br /> get the actual number of characters to strip by opentagpos less closetagpos less length of starttagstring<br><br /><br /> get the start position to strip by start tag pos. plus length of start tag string (might be less 1, please try!)<br><br /><br /> Using substring property (start position to strip, actual number of characters to strip)<br><br /><br /> Change the open tag pos by (strxmlcontent.indexof(stropentag, iendtagpos))<br><br /><br /> Else <br><br /><br /> set opentag pos is -1<br><br /><br /> End if<br><br /><br />End While<br><br /><br /><br><br /><br />if closetag is -1 then<br><br /><br /> Prompt the message ';the file is invalid';.<br><br /><br />end if<br><br /><br /><br><br /><br />I have provided the logic tailerd to your case, hope my message will solve your programming problems. Are you uni student?Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-60484933573445075272010-08-20T23:25:00.001-07:002010-08-20T23:25:18.062-07:00How to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?not be duplicated..My only problem is that error. The error always appear when i put the same data in the databse, and after that those duplicates were deleted from the database...how can I trap the error? the error is like this:<br><br /><br /><br><br /><br />Run-time error '-2147467259 (80004005)<br><br /><br /><br><br /><br />i try to trap it but it doesn't work that error always appear...<br><br /><br />is their any alternative way to avoid entering duplicates in the database? or What is the right way to trap the error? Please help me i really need this to my thesis...Im now online this is my I.d ericgri20002000.<br><br /><br />By the way im using ADO control and Datagrid ...PLease help meHow to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?<br >You use create a constraint and create a unique key across the fields you don't want duplication. Most DB Engines allow you to specify to ignore duplicate records in a unique key field range. An Identity field doesn't necessarily remove duplicate values in supplement fields- only the ID field.<br><br /><br /><br><br /><br />runtime error 80004005 refers to unrecognized database format.. what is the version of your access database? use Jet Ver 4.0 for access 2000/2003.. Jet 3.5.1 for access 97.. take careHow to avoid entering duplicate in Database? I have already put an Index to the field so that the data will?<br >Create a method to verify that the data that you鈥檙e entering does not already exist prior to updating your table in the database. The method should execute a stored proc that will simply query the table for the specified value and then return the record ID if it exists. If it鈥檚 already there, then just don鈥檛 attempt to perform the insert.<br><br /><br /><br><br /><br />If you wanted to get more complicated you could use Ajax to check the database for the value as the user is actually typing it on the page and instantly notify the user that the value already exists preventing them from inserting the duplicate value on the client side. You would need to develop a Web service for this and learn how to use Ajax.NET or write your own JavaScript SOAP call methods to interact with the Web service.Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-14176169333662852282010-08-20T23:25:00.000-07:002010-08-20T23:25:01.849-07:00My GUI problem?hi,<br><br /><br />I've a problem figuring out how to design my website's interface.<br><br /><br />I have a menu control that's horizontal..it takes the whole width of the screen and right under it I have datagrid that also takes the whole width of the screen, so my problem is that new items are added in the menu regularly so that means the menu will be too wide for the screen..so I was thinking of converting it to a vertical menu but my problem is that the grid also takes the whole screen so I don't know where exactly to put it so this means it's gonna take part of the width that the grid takes?<br><br /><br />So I can't imagine where to put it exactly...any suggestions..maybe some links to websites as examples..<br><br /><br /><br><br /><br />thanksMy GUI problem?<br >First of all you should use css for the page layout. if you don't wana use them try specifying the width of each td tag in percentages in which you want to keep the display items of your webpage. once you have a stremlined table structure, adding or removing more items from page won't be any problem. using this approach you can have your extra item in either vertical or horizontal part. also you can restrict the datagrid to couple of TD/colums by specifying the the colspan attribute. or you can include the datagrid within the div tag and make the size of div tag smaller than the size of datagrid, so you can have scrollbars around the datagrid to view data and also increasing the space for you.<li><a href='http://love-myspace-we.blogspot.com/'>love myspace</a></li><li><a href='http://myspace-girl-rt.blogspot.com/'>myspace girl</a></li>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-53120266537930695532010-08-20T23:24:00.002-07:002010-08-20T23:24:46.107-07:00How to get value from datagrid to textbox outside grid in asp.net?how to get value from datagrid to textbox outside grid in asp.netHow to get value from datagrid to textbox outside grid in asp.net?<br >in Asp Net data grid is associated with DataSet. Whenever there is change in data dispalyed in datagrid, dataset is updated accordingly. You need to read dataset for getting that value.Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-27978480945397824092010-08-20T23:24:00.001-07:002010-08-20T23:24:30.082-07:00I am a newbie in visual basic and i am having a hardtime controling my database using vb as my interface?would you please help me on how i would code my vb program so that it would accept inputs via textboxes, confirm the inputs using a command button and save it in a database (access via adodc) that would then be displayed in a datagrid.<br><br /><br /><br><br /><br />i already used adodc1.recordset.addnew and adodc1.recordset.update but what i need is a code because im going to use sql statements for queries with certain conditions.<br><br /><br /><br><br /><br />one example is in my login form. I need to query my database using adodc to verify if the logging user is registered to the database. how could i solve this? please help me...I am a newbie in visual basic and i am having a hardtime controling my database using vb as my interface?<br >Been a while for VB and ADODC but as I recall, click on properties for the ADODC control and a wizard opens. You can select that you're using a SQL query, which kind of database you're connecting to (Access, SQLServer, etc) write the query in a box in the wizard and test the connection.<br><br /><br /><br><br /><br />Hope that helpsCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-32440954631700339462010-08-20T23:24:00.000-07:002010-08-20T23:24:13.553-07:00How can I use Function keys to display data in VB6.0?Dear Friend<br><br /><br /><br><br /><br />Can anybody answer about my below requirement?<br><br /><br /><br><br /><br />I want to use function keys in my “Inventory Control System” software. I’m using VB6.0 and for database Access 2002.<br><br /><br /><br><br /><br />For example, I want to see the availability of Computer based on ref_no (ref_no does exist in a TextBox which is placed on my MDI form). Then if I press F2 or F3 or F4 …., that particular item i.e. Computer related with ref_no will be displayed on a DataGrid.<br><br /><br /><br><br /><br />Please help me about the use of function keys.<br><br /><br /><br><br /><br /><br><br /><br />Appreciate, if you would come back at your earliest.<br><br /><br /><br><br /><br /><br><br /><br />Regards<br><br /><br />PervezHow can I use Function keys to display data in VB6.0?<br >You will need to place a keyup handler on your form and process the keys that come in<br><br /><br /><br><br /><br />Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer)<br><br /><br />If KeyCode = vbKeyF1 Then myFunction()<br><br /><br />End SubCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-3490119722571641102010-08-20T23:23:00.003-07:002010-08-20T23:23:57.581-07:00MS Access search form -> open report?scenario:<br><br /><br /><br><br /><br />FormName:frmSearch<br><br /><br />objects: (all unbound)<br><br /><br />txtBeginDate <br><br /><br />txtEndDate<br><br /><br />cboNameList (contains Names from tblNameList onLoad event)<br><br /><br />cboCategoryList (contains Category from tblCategoryList onLoad event<br><br /><br /><br><br /><br />() Show Detailed report (option bution to open dtlMonthlyReport)<br><br /><br />() Show Summarized report (option bution to open smrMonthlyReport)<br><br /><br />() Search Reciept (option button to open rcptReport)<br><br /><br />() Search Voucher (option button to open vcrReport)<br><br /><br /><br><br /><br />btnSearch <br><br /><br /><br><br /><br />[ I want to display search result here within the form ... but dont konw how?]<br><br /><br /><br><br /><br />================= end of frmSearch ==============<br><br /><br />notes:<br><br /><br />all the reports are link to its own form and the date field formated to accept input from within the form<br><br /><br /><br><br /><br />the purpose of this form (frmSearch) is to show the search result based on user defined criteria and then from the search result user can double click to open the designated report with the parameters from the sellected search result.<br><br /><br /><br><br /><br />question:<br><br /><br /><br><br /><br />1) how do I display the search result(s) within the form itself (in VB its dataGrid) for the option 3 %26amp; 4 only.<br><br /><br />2) I have tried using the ';SELECT '; method in sqlCriteria string using <br><br /><br /> doCmd.OpenReport .......,sqlCriteria <br><br /><br />but an error msg appears saying ';....there are more than 1 record based on ..... consider using EXISTS reserved word ......';<br><br /><br />So how do I open the designated report based on the search criteria?<br><br /><br /><br><br /><br />I have heard of this PARAMETERS in querydef but not sure how to use it.<br><br /><br /> <br><br /><br />can you guys help me? Im stuck. whenever I want to display the reciept of a certain transaction I have to manually browse to the records (in frmTransaction) then click the button to generate the report. The same goes to the monthly detailed report, where I have to execute the form , enter the date range and click the button. For the summarized report its more troublesome for me to generate the report because it goes through many process. That is why i want to have this ';short cut';MS Access search form -%26gt; open report?<br >dont look for a shortcut please.Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-43284337641320840872010-08-20T23:23:00.002-07:002010-08-20T23:23:42.048-07:00I have some problem about DATA GRID in vb6 connected to MS access, i need to remove/delete all records?HELP!!?i have problem about DATA GRID in vb6 connected to MS access, i need to remove/delete all records in just one click in a command button. My code is: rsProducts.delete, because i made my records as a recordset. but it doesnt remove all records in DATAGRID. i've already done deleting a single record by selecting 1 record, but my problem now is that, i need to delete the entire recodrs on my datagrid. How can i do that, can you please help me do this one. THANKS!!! PLEASE! any help will be greatly appreciated.I have some problem about DATA GRID in vb6 connected to MS access, i need to remove/delete all records?HELP!!?<br >project helps<br><br /><br />http://hobbyprojects.info/Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-1462627509173779292010-08-20T23:23:00.001-07:002010-08-20T23:23:25.931-07:00Gridview paging in asp.net?i m working on this page with gridview which i flood from my vb code, same adap.fill, gridview.databind(). now i want to page this gridview. while this code http://dotnetjunkies.com/Tutorial/AAF84EAD-C412-4304-A88A-AF26F8C883E6.dcik <br><br /><br />works for a datagrid. i want similar functionality for a gridview. can anyone help??? please its urgent.. my deadline is tom n i've wasted enough time. as in what is the code that goes in pageindexchanged... also if you could type a tiny code showing how rowcommand would work if i were to access the property of an object in my gridview... eg. activate button text to deactivate on clicking....Gridview paging in asp.net?<br >The GridView is NOT a DataGrid. If you are using a GridView, then achieving paging is even easier than in a DataGrid. Below I give the code for a page that uses Paging in a GridView.<br><br /><br /><br><br /><br />I write the whole code inline (in aspx file) to simplify stuff.<br><br /><br /><br><br /><br />%26lt;%@ Page Language=';C#'; AutoEventWireup=';true'; %%26gt;<br><br /><br />%26lt;%@ Import namespace=';System.Data';%%26gt;<br><br /><br />%26lt;%@ Import namespace=';System.Data.SqlClient';%%26gt;<br><br /><br />%26lt;html %26gt;<br><br /><br />%26lt;head runat=';server';%26gt;<br><br /><br /> %26lt;title%26gt;Untitled Page%26lt;/title%26gt;<br><br /><br /> %26lt;script runat=';server';%26gt;<br><br /><br /> protected void Page_Load(object sender, EventArgs e)<br><br /><br /> {<br><br /><br /> if (!Page.IsPostBack)<br><br /><br /> {<br><br /><br /> BindGrid();<br><br /><br /> }<br><br /><br /> }<br><br /><br /><br><br /><br /> private void BindGrid()<br><br /><br /> {<br><br /><br /> SqlConnection MyConnection;<br><br /><br /> SqlCommand MyCommand;<br><br /><br /><br><br /><br /> MyConnection = new SqlConnection(';server=.;DataBase=Northwi鈥?br><br /><br /> MyCommand = new SqlCommand(';SELECT * FROM CUSTOMERS ';, MyConnection);<br><br /><br /><br><br /><br /> DataTable dt = new DataTable();<br><br /><br /> SqlDataAdapter da = new SqlDataAdapter(MyCommand);<br><br /><br /> MyCommand.Connection.Open();<br><br /><br /> da.Fill(dt);<br><br /><br /> MyCommand.Dispose();<br><br /><br /> MyConnection.Dispose();<br><br /><br /><br><br /><br /> gvwTest.DataSource = dt;<br><br /><br /> gvwTest.DataBind();<br><br /><br /><br><br /><br /> }<br><br /><br /><br><br /><br /> protected void gvwTest_PageIndexChanging(object sender, GridViewPageEventArgs e)<br><br /><br /> {<br><br /><br /> BindGrid();<br><br /><br /> gvwTest.PageIndex = e.NewPageIndex;<br><br /><br /> gvwTest.DataBind();<br><br /><br /> }<br><br /><br />%26lt;/script%26gt;<br><br /><br />%26lt;/head%26gt;<br><br /><br />%26lt;body%26gt;<br><br /><br /> %26lt;form id=';form1'; runat=';server';%26gt;<br><br /><br /> %26lt;asp:GridView ID=';gvwTest'; runat=';server'; AutoGenerateColumns=';true'; AllowPaging=';true'; PageSize=';10'; <br><br /><br />OnPageIndexChanging=';gvwTest_PageIndex鈥? /%26gt;<br><br /><br /> %26lt;/form%26gt;<br><br /><br />%26lt;/body%26gt;<br><br /><br />%26lt;/html%26gt;<br><br /><br /><br><br /><br />Remember.. look for gridView code snippets not DataGrid!!<br><br /><br />Hope the above helps.<li><a href='http://love-myspace-we.blogspot.com/'>love myspace</a></li><li><a href='http://myspace-girl-rt.blogspot.com/'>myspace girl</a></li>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-1264395068229554662010-08-20T23:23:00.000-07:002010-08-20T23:23:09.723-07:00Visual Basic 6.0 Questions?1. how to filter ms access database records when u have a textbox searchbox,<br><br /><br />then the record u will filter or search has apostrophe (')? <br><br /><br />pls give me sample code ...<br><br /><br />2. also how can u bind the DATAGRID control (not flexgrid) using adodb (coding)? <br><br /><br />3. how can u create a backup of ur database when ur frontend is visual basic?<br><br /><br />4. how can u export from access database to ms excel file with vb as the front end?<br><br /><br />hope to hear from u. take care. thanks in advance.<br><br /><br />=)Visual Basic 6.0 Questions?<br >Too much questions :).<br><br /><br />Visit the websites you may can get codes<br><br /><br />http://www.ecodebank.com<br><br /><br />http://www.freevbcode.com<br><br /><br />http://www.vbdiamond.com<br><br /><br />http://www.planetsourcecode.comCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-17059720545042534722010-08-20T23:22:00.003-07:002010-08-20T23:22:53.599-07:00ASP.Net C# Trim Method?For example, I have 24.00 on my Table.<br><br /><br /><br><br /><br />If I use a session variable and put it on a textbox, I only want the 24 to appear. But I don't want to change its format on the DataGrid. So I'm thinking of trimming the .00 at the end. How do I put it in code?<br><br /><br /><br><br /><br />I think it's something like this:<br><br /><br />TextBox1.Text.Trim()???<br><br /><br />But I don't know how to use it.ASP.Net C# Trim Method?<br >text.trim only trims the spaces off the front and back. What you might want to do is used a 'masked text box' and set the mask only to non decimal places.<br><br /><br /><br><br /><br />outside of that you will have to search the string for a period and take the substring from the start of the string to the period, but not including the period.Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-4327913660150119812010-08-20T23:22:00.002-07:002010-08-20T23:22:41.817-07:00Simple RSS in Flex help?I am trying to do an oh so very simple RSS reader in flex but I keep seeing so many ways to do it and none of them are working for me, from what I understand it should be as simple as:<br><br /><br /><br><br /><br /> %26lt;mx:HTTPService id=';EngadgetFeed'; url=';http://www.engadget.com/rss.xml'; /%26gt;<br><br /><br /><br><br /><br />but then how do I bind the data to my data grid?<br><br /><br /><br><br /><br />%26lt;mx:DataGrid id=';Feed'; x=';10'; y=';86'; height=';307';%26gt;<br><br /><br /> %26lt;mx:columns%26gt;<br><br /><br /> %26lt;mx:DataGridColumn headerText=';Title'; dataField=';col1';/%26gt;<br><br /><br /> %26lt;mx:DataGridColumn headerText=';Date'; dataField=';col2';/%26gt;<br><br /><br /> %26lt;/mx:columns%26gt;<br><br /><br /> %26lt;/mx:DataGrid%26gt;<br><br /><br /><br><br /><br />ive tried adding : dataProvider = ';{EngadgetFeed}'; but I know im still missing something.<br><br /><br /><br><br /><br />Can someone show me how to do it in the most simplest way? I dont need it to be amazing looking I just want it to function so I can learn how to do it.Simple RSS in Flex help?<br >Maybe these free online RSS Feed Makers will help...<br><br /><br /><br><br /><br />http://jade.mcli.dist.maricopa.edu/feed/鈥?/a><br><br /><br />http://www.feedburner.com/fb/a/home<br><br /><br />http://www.rssfeedsgenerator.com/<br><br /><br />http://www.site-reference.com/rss-parser鈥?/a><br><br /><br />http://www.make-rss-feeds.com/rss-tags.h鈥?/a><br><br /><br />http://www.site-reference.com/syndicate.鈥?/a><br><br /><br />http://www.wotzwot.com/rssxl.php<br><br /><br /><br><br /><br />RonCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-36951174290411877462010-08-20T23:22:00.001-07:002010-08-20T23:22:23.335-07:00I want to build a GUI in visual C++ that will show the contents of a MySQL database. How can I do that?I want to build a GUI in visual C++ that will show the contents of a MySQL database and then I'll have to add stuff like only showing specific columns when i klik, but I don't know how to add the data to a datagrid (if there is a better option than using a datagrid, I'm willing to try that). I need as detailed info as possible, or link to any tutorials/help or whatever to make it as close to step by step guide, because I'm kind of an amateur in Visual C++. Any tips and ideas are very appreciatedI want to build a GUI in visual C++ that will show the contents of a MySQL database. How can I do that?<br >Maybe if you are flexible on language you might want to go Java for a first up on GUI design (it transports across languages and Swing is quite nice to use, though Java itself is akin to my semen freezing when I see Chris Hansen). If you were to do this, I would recommend NetBeans and you will also need the ConnectorJ library. Or maybe since you're on Windows take a geez at C#<br><br /><br /><br><br /><br />However, C++ is a fickle language, and it is likely you will need a new library to link into your app to connect to the DB with it (don't worry, MySQL likely have it on their website). If I'm correct in my guess (I'm a Linux guy, so when I write in C I use GTK+), it's likely that each GUI component will have a member function like set_content() or the like with which you can set what ever you needCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-70133988807155851452010-08-20T23:22:00.000-07:002010-08-20T23:22:12.163-07:00Adobe flex + .NET web services?hi, im new in adobe flex so i have this problem that maybe easy for some of u flexperts =).<br><br /><br /><br><br /><br />what i know is the %26lt;mx:datagrid%26gt; can accept array collections or xml files. but in my case, im not allowed to use the xml as datasource.<br><br /><br /><br><br /><br />The webservice (.NET) returns an array (or watever collection it is with muyltiple columns).. so how can the flex datagrid accept this as an array collection?<br><br /><br /><br><br /><br />to summarize all those bunch o' craps i mentioned earlier, i just need to populate my flex datagrid with 3 columns (the method will come from the .net webservice)...<br><br /><br /><br><br /><br />thanksAdobe flex + .NET web services?<br >Within Flex, you have to convert the XML to an array. If your web service returns the data in some sort of table/row/column format, then this is pretty straightforward. Take a look at the tutorial below and let me know if that is what you are looking for.Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-44050812330643868182010-08-20T23:21:00.003-07:002010-08-20T23:21:53.486-07:00Visual Basic 2008 Data Update?Ok im making a program for a local grocery. my problem is the following - ive created a database using Access. basically what i intend to do is make two Forms in vb2008. one of them will have the main databse in a datagrid and a window saying ADD/Delete/Edit and when pressed the 2nd form will show up with textboxes where i will be able to input for example a new product and when i hit save it goes back to the 1st form and the product is already added to the database there. ive already done the datagrid in the 1st form and ive put the textboxes in the 2nd form (by going to the datasource tab and just drag the text boxes in there) but i dont know how to, when i hit save and save what ive added to the textboxes so it can appear on the datagrid on the first form. anyone?Visual Basic 2008 Data Update?<br >This is much to complicated to do in this forum.<br><br /><br /><br><br /><br />If you want to pay me $5,000 I will have it done in a few days. The choice is yours!<li><a href='http://love-myspace-we.blogspot.com/'>love myspace</a></li><li><a href='http://myspace-girl-rt.blogspot.com/'>myspace girl</a></li>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-29797602163117254702010-08-20T23:21:00.002-07:002010-08-20T23:21:33.711-07:00Vb .net help database?Dim historyconnection As OleDbConnection = New OleDb.OleDbConnection(';Provider=Microsof鈥?Source=D:\@skul\fifth\tralala.mdb';)<br><br /><br /> <br><br /><br />Dim historyadapter As OleDbDataAdapter = New OleDb.OleDbDataAdapter(';SELECT [historyd].[accession number], books.title,[history date].[date borrowed],[history date].[date returned] FROM historyd, books where [history date].[accession number] = [books].[accession number]';, historyconnection)<br><br /><br /><br><br /><br />Dim historydataset As DataSet = New DataSet<br><br /><br /><br><br /><br />HOW DO I MAKE THIS QUERY APPEAR IN THE DATAGRID?<br><br /><br /><br><br /><br />are there any programmers there who would like to help a beginner?! IM me pls.Vb .net help database?<br >The below given link may help you<br><br /><br />http://vb-helper.com/howto_net_datagrid.鈥?/a>Vb .net help database?<br >check out http://www.pscode.com - great site for source code. I do VB-6 programming, and use that site all the time.Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-53011223042601898862010-08-20T23:21:00.001-07:002010-08-20T23:21:17.608-07:00How to solve this search problem??using datagrids and vb.net?If cboSearch.Text = ';Books'; Then<br><br /><br /> Dim ProductId As String<br><br /><br /> txtProductID.Text = ProductId<br><br /><br /> ProductId = ';SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN =''; %26amp; ProductId %26amp; ';'';<br><br /><br /> Dim dt As New DataTable<br><br /><br /><br><br /><br /> OleDbDataAdapter1.Fill(dt)<br><br /><br /> DataGrid1.DataSource = dt<br><br /><br /> End If<br><br /><br />There's 1 combobox(with the category choices) and 1 textbox...user have to choose the category from the cbobox and type the productid in the txtbox...when i run this code only the info for B0001 is supposed to show on the datagrid, but when i run it..the whole list comes out...how do i solve this??How to solve this search problem??using datagrids and vb.net?<br >with this new information try this:<br><br /><br />dim cn as new adodb.connection<br><br /><br />dim rs as new adodb.recordset<br><br /><br /><br><br /><br />set cn = new adodb.connection<br><br /><br />set rs = new adodb.reocrdset<br><br /><br /><br><br /><br />cn.Open ';Provider=Microsoft.Jet.OLEDB.4.0;'; %26amp; _ <br><br /><br /> ';Persist Security Info=False;'; %26amp; _<br><br /><br /> ';Data Source=C:\database.mdb'; <br><br /><br /><br><br /><br /><br><br /><br />If cboSearch.Text = ';Books'; Then<br><br /><br />Dim ProductId As String<br><br /><br />txtProductID.Text = ProductId<br><br /><br />ProductId = ';SELECT ID, ISBN, Title,Format, Quantity FROM BooksInfo WHERE ISBN =''; %26amp; ProductId %26amp; ';'';<br><br /><br />'Dim dt As New DataTable<br><br /><br /><br><br /><br />rs.Open ProductId , cn, adOpenDynamic, adLockOptimistic<br><br /><br /><br><br /><br />'OleDbDataAdapter1.Fill(dt)<br><br /><br />DataGrid1.DataSource = rs<br><br /><br />End If<br><br /><br /><br><br /><br />rs.close<br><br /><br />cn.close<br><br /><br />set rs = nothing<br><br /><br />set cn = nothing<br><br /><br /><br><br /><br />hope I didn't miss anythingCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-71432066175539877542010-08-20T23:21:00.000-07:002010-08-20T23:21:01.763-07:00Vb.net Conection with 2 tables of an Access Bd?i have 2 table student and inscription, and i need that those tables, all in one form like a view but with all the features like , update,erase and saved, because i try and nothing happen , The form i try is like with textbox and i don't need datagrid , some one know how to do this ???Vb.net Conection with 2 tables of an Access Bd?<br >make querryCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-70183005971892268312010-08-20T23:20:00.002-07:002010-08-20T23:20:46.119-07:00ListView or any other Component in ASP.net?We want to add Records in Tabular form from collection of text boxes..Data Grid can be used for this purpose but DataGrid uses the DataBase as a data source but our Data Sourc is Collection of Text Boxes and we want a component like list view or Data Grid...Plz tell me from where we can get it Free or Tell me how can we solve this Problem..plz tell me as soon as possible..ListView or any other Component in ASP.net?<br >You want to bind your grid to a datatable, which you will use to store results.<br><br /><br /><br><br /><br />I will provide code for this shortly in my Yahoo! 360 blog and will update this answer when the solution is complete.<br><br /><br /><br><br /><br />UPDATE: Here is the link:<br><br /><br />http://blog.360.yahoo.com/blog-NVb99sQ4R鈥?/a>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-60159401213569259572010-08-20T23:20:00.001-07:002010-08-20T23:20:31.591-07:00Hello there?I would like to know how to upload images into MS ACCESS database? using ASP.NET and then view them using Datagrid.<br><br /><br />Please provide me with the screen shots and the codes if possible<br><br /><br />Thank you for all your help/Hello there?<br >I will put together a demo and update this answer when it is done, in about 12 hours.<br><br /><br /><br><br /><br />UPDATE, 3/21/06: I have finally posted the answer to my blog and my demo site:<br><br /><br /><br><br /><br />http://blog.360.yahoo.com/blog-NVb99sQ4R鈥?/a>Hello there?<br >What the heck r u on about?Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-51848048040228509462010-08-20T23:20:00.000-07:002010-08-20T23:20:16.611-07:00Would u pls answer these questions?1.What is disco file? <br><br /><br />2.What are the events fired when web service called? <br><br /><br />3.How will do transaction in Web Services? <br><br /><br />4.In what order do the events of an ASPX page execute. As a developer is it important to undertsand these events? <br><br /><br />5.How would you get ASP.NET running in Apache web servers - why would you even do this? <br><br /><br />6.What tags do you need to add within the asp:datagrid tags to bind columns manually?<br><br /><br />7.What are the page level transaction and class level transaction? <br><br /><br />8.What are different transaction options? <br><br /><br />9.What is the namespace for encryption? <br><br /><br />10.What is the difference between application and cache variables? <br><br /><br />11.What is the difference between control and component? <br><br /><br />12.You ve defined one page_load event in aspx page and same page_load event in code behind how will prog run? <br><br /><br />13.What r the diff types of inheritance in C#?give examples or syntax?<br><br /><br />14.What is delegates in C#?<br><br /><br /><br><br /><br />these r some interview questions.pls give answer.........Would u pls answer these questions?<br >Do your own homework.<br><br /><br /><br><br /><br />www.asp.net<br><br /><br />www.codeproject.com<br><br /><br />www.msdn.com<br><br /><br />www.gotdotnet.comWould u pls answer these questions?<br >Check it on the MSDN of .NET you will get all the Answer<br >Sounds like someone's trying to cheat her way through an exam / homework.<br><br /><br /><br><br /><br />If we give you the answers, you'll never remember them. Search, learn, remember.<br><br /><br /><br><br /><br />Google it if you must...<li><a href='http://love-myspace-we.blogspot.com/'>love myspace</a></li><li><a href='http://myspace-girl-rt.blogspot.com/'>myspace girl</a></li>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-8544717542927040332010-08-20T23:19:00.003-07:002010-08-20T23:19:58.070-07:00Vb .net datagridview oledb?how do i get a single row like in listbox i can use ';listbox1.selectedindex = 0'; how do i do it in datagrid.<br><br /><br /><br><br /><br />if there is a programmer out there who would like to teach a complete idiot. please contact me.Vb .net datagridview oledb?<br >Here it is your code -assume you have named your DataGridView ';DataGrid';! (I haven't work with DataGridViews before but I've done a lot of other things - so I found it easily!):<br><br /><br /><br><br /><br />'First, deselect every selected cell/row/column!<br><br /><br />DataGrid.ClearSelection()<br><br /><br />'Then select your row - replace 0 with the index of the row!<br><br /><br />DataGrid.Rows(0).Selected = TrueCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-43382445164893862612010-08-20T23:19:00.002-07:002010-08-20T23:19:42.040-07:00I am using asp.net 1.0. i want to know paging concept.?i am retreiving data from my databse to my datagrid. but i want to display 5 rows first and if i click on next the next 5 rows will display. i dont know how to do this. complete rows from my database is comming. thanks in advance.I am using asp.net 1.0. i want to know paging concept.?<br >http://aspnet.4guysfromrolla.com/article鈥?/a>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-14805063247717853862010-08-20T23:19:00.001-07:002010-08-20T23:19:26.058-07:00Vb.net question?how to print the contents of a datagrid?Vb.net question?<br >datagrid has its function to print. you can evoke that from a command button.<br><br /><br /><br><br /><br />they have removed this page but see it quick before the cache from google goes off http://64.233.167.104/search?q=cache:_Rw鈥?/a>Curtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0tag:blogger.com,1999:blog-7972105578155799231.post-20978960472867088392010-08-20T23:19:00.000-07:002010-08-20T23:19:09.851-07:00I need a VB.Net and ASP tutor!!!!!!?i have to do this project and i've come to the point where i am going to GIVE UP which is a really bad thing coz this project is very important!! SOME KIND SOUL, PLEASE HELP ME!! i need someone who could teach me how to code using visual studio .net 2003!!this is xtremely URGENT!!<br><br /><br /><br><br /><br />Details of the project: online sales and inventory for a bookshop<br><br /><br />inventory is using vb.net in vs .net 2003 and the sales is using asp...<br><br /><br />I am using MS Access for the database<br><br /><br />Main problems:<br><br /><br />1) i don't know how to connect the database to the code<br><br /><br />2) i have tried so many variations in the coding for logging in and i can't seem to get even THAT right!!<br><br /><br />3) I also need to be able to show selected details using the datagrid as well as how to edit and update it<br><br /><br /><br><br /><br />Please help me!!!I need a VB.Net and ASP tutor!!!!!!?<br >i can help u in asp if u wanna it pls send ur project details to my mail<br><br /><br /><br><br /><br />amit_shri05@yahoo.co.inCurtishttp://www.blogger.com/profile/02848360283496620838noreply@blogger.com0