Search results for query: *

no thanks, i rather figure it out and learn.

I'm using a Oledatadapter to fill a dataset and displaying my ms access records via a datagrid. Anybody is familiar on how to 1. Allow a user to select a Datagrid row and click on a button "btnDelete" the row will be deleted from the database? Each row has a unique column called 'ID'. any...

Question: Do i have to create it for all my related tables? How do i know which is parent, which is child? What do i do after i create the relationships? In summary, if i have 8 tables, i create 8 data-adapters for 8 tables and put all of them into a dataset? Then type 8 times of...

how do i put person_id into tb1 as a foreign field? ok after i use the select statement in my data adapter, i run 'da.fill(ds)' next how do i put input this dataset 'ds' into my datagrid

codes Private Sub frmResults_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'da1 is a data adapter that has 2 tables: tb1 & tb2 'i used vs.net to drag the oledbdataadapter to select fields using sql query builder 'the datagrid will show eg...

my datagrid displays a dataset with no problem when it has 2 tables, however when i add more related tables, it doesnt display any values at all, any idea? i'm using the vs.net 2003 data adapter to add the tables. after i added the tables, they are displayed out with relationships shown. then i...

Hi, I'm using a data adapter 'da1' to fill a dataset 'ds1' which is used to display data in a datagrid 'dg'. How do I code datagrid OnClick event on whichever row the user click on the datagrid, to cause a new form2 to popup with textboxes to display the selected row's data and allow the...

Hi, How do i input 2 related tables' fields into a dataview which is displayed on a datagrid, choosing the fields (columns) i want to display, anyone knows or have any examples? Table1: ID, Name, Age, Sex, Job Table2: ID, JobName, Salary For example, I created a relationship "Table1Table2"...

I created a repeater to display my data inside a dataTable of Session("Cart") however i have a problem. I do not know how to to update the Quantity displayed in a txtQuantity. How do i code a 'btnUpdate' so that it will read the txtQuantity and update each row of item's quantity according...

thanks, what if the user is allowed to update the Name, by putting a textbox inside, how can it be updated? <AlternatingItemTemplate> <trbgcolor="lightyellow"> <td><asp:Textbox id=Firstname Text=<%#Container.DataItem("Firstname")%></td> <td><asp:Textbox id=Lastname...

I got the relationships setup. however the second listbox doesnt display what i wanted. dataAdapt = New OleDbDataAdapter("SELECT * from Table1", oledbCon) dataAdapt.Fill(Dataset, "Table1") dataAdapt.SelectCommand = New OleDbCommand("SELECT * from Table2", oledbCon) dataAdapt.Fill(Dataset...

i have 2 tables tblCustomers and tblTransactions, how do i code a data relationship between them. have created a dataset and data adapter. say their common field is 'ID'. how do ensure also when the data is updated, it is updated into the proper tables.

when my prog tries to open a filedialog to open a .txt file, when it fails to open it eg: when file is open or in used. It crashes, anyway to turn around this. so that it can prompt an error msg when the .txt file is not valid or not of a proper format instead of crashing. also is it somehow...

i have finished coding a HP bills calculator that reads the user's mobile hp usage from a .txt file, and displays it on the screen with respect to the plans he subscribed to. i was told to add in an extra function that may give the company a good boost.. any recommendations?

hi, how do i validate a userid to ensure they are 3 uppercase digits followed by 6 digitals, otherwise it will reject it. ABC123456 - OK abc123456 -NOT OK ab12345 -NOT OK 12abc -NOT OK I'm thinking of using substring to test for the 6 digits to ensure it is between 1-999999, not sure if that...

i used a repeater region to display my products from a MS access db, what codes should i add to allow a button to add this item to the shopping cart? help appreciated, thanks. DB: MS Access 2000 App: Dreamweaver MX 2004 Type: ASP .Net VB <ASP:Repeater...

Hi, I would like to do validation on my .aspx , however the form tags are <input type=""> html based, therefore how can i do validation on the server side(already have javascript validation) since asp: requiredvalidator only works on asp:tags Next, i have another form on asp tags, how...

Hi, I managed to create a repeater to list my products's name, desc, cost using DWMX and my database is MS Access (project purpose), how do I add a button that will allow the user to Add the db items to cart? How do I create this cart too? Anyone has any examples or samples somewhere...

Hi I'm having these errors when on the user registration form i created and it gives these errors: System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at...

Hi, I have a MS access database of product's table namely with fields imagefile, product_id, name, cost and 4 different products added. I created a table 2 rows 2 cols in products.aspx, i have the database connected, datasets up and i wish to display the 4 products into this 2 row 2 col table...