Topics
-
-
- Administrators
- 3 replies
- 6.6k views
this is what i have so far for updaing one column but i need to update multiple columns in my form Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yada_yada_yada.mdb") MyConnection.Open Dim MyCommand As New OleDbCommand("UPDATE Cust SET Fname = me.txtFname.text WHERE ID = txtUpdID", MyConnection) MyCommand.ExecuteNonQuery() MyConnection.Close MyReader.Close MyCommand.Dispose anyway how would i go about doing an update for lets say SET Fname = me.txtFname.text, Lname = me.txtLname.text, Mname = me.txtMname.text WHERE ID = me.txtUpdID; i have been searching for some kind of code showing this but my searches come up …
Last reply by PlausiblyDamp, -
-
- 2 replies
- 1.1k views
I have a datagrid that lists files in a directory with hyperlinks to each file. I would like each hyperlink to be the filename without the extension but then I need the filename with the extension for the hyperlink. Here is the relevant part of my code: Sub BindData() 'variables defined in this part - not shown filesTable.Columns.Add("Name", Type.GetType("System.String")) ' Get File Info arrFileInfo = dirInfo.GetFiles("*.aspx") For Each filesInfo In arrFileInfo If filesInfo.Name <> "dr.aspx" and filesInfo.Name <> "Search.aspx" then drFiles = filesTable.NewRow() ofn = filesInfo.Name charCt = Instr(ofn, ".aspx") -1 ofn = Mid(ofn, 1, charC…
Last reply by eramgarden, -
-
- Leaders
- 2 replies
- 4.7k views
Hello everyone, I've been programming for a very long time but haven't touched any game related code since the 90s when I did a few demo games in c and pascal. It's piqued my interest again and so I started playing around with directx in my spare time. I want to go ahead with an idea I have for a top down 3d tile-based game, meaning that it has a tile based look-down feel like legend of zelda, but the tiles are 3D objects. What I'd like to be able to do is combine the tiles on a map into a single mesh, so that there are no seams. I figure if I make all the tiles have junction points, vertextes that are in the same place on each tile, then I should be able somehow to…
Last reply by Cags, -
-
- 2 replies
- 1.2k views
Can I omit the "wait-time" when I run a Stored procedure? The thing is, my procedure goes on for 20mins, and thus I usually get timeout expired or the user falls asleep and does strange things. I imagine that the application is waitting some out parameters from the server system or what? Can that be omitted?
Last reply by IxiRancid, -
-
- *Experts*
- Leaders
- 7 replies
- 1.8k views
i have 4 check boxes, a calculate button, and a label. when u check the box or boxes u want, u click the calc button, and it will at those prices to the base cost, and then it will show your total cost in a label. when i check mulitple boxes, it adds the lowest box's value -- example Shoes $20 Hat $15 Shirt $14 say i click hat and shirt, it will only add the $14 that the shirt costs to the total cost.. i have tried many things but none seem to fix the problem :confused:
Last reply by Cags, -
-
- 2 replies
- 1.2k views
Hi, I'm creating a simple game in Direct3D. I would like to show a loading screen while my program loads up resources like textures and scripts. The problem is, while my program is busy loading resources, there isn't any rendering taking place so I cannot show a progressbar or anything. I'm rendering within a window using the Invalidate method. How should I handle this? Should I load one resource at a time per frame cycle? Thanks in advance for your reply.
Last reply by Wessel, -
-
- Administrators
- 3 replies
- 1.3k views
How do I convert an Excel spreadsheet to a database for use in my VB application? The spreadsheet is a series of about 10,000 records divided up into categories. Some of the cells in the spreadsheet are commented, and I'd like to transfer these comments over with the data contained in Cells, if possible.
Last reply by net pwanage, -
-
- 5 replies
- 2.9k views
Previously I have been using VS.NET 2003 Professional by itself meaning that I have never done the MSDN subscription thing. At this point I am very seriously considering the MSDN subscription, the Professional level one, for VS.NET 2005 Professional edition. I was wondering if anyone knew if the MS eLearning courses were avaible at no additonal charge to MSDN subscribers or if the prices associated with those courses still would need to be paid even if I was an MSDN subscriber?
Last reply by irasmith, -
-
- Administrators
- Leaders
- 6 replies
- 2.3k views
I've used threads in my apps before but wish to make sure that I'm implementing a thread correctly in this case. Here is the function I call on a form.closed event: Private Sub RefreshData Dim ThrData As New Thread(AddressOf LoadMemos) ThrData.Start() End Sub LoadMemos just simply reads a few tables from the database and fills a dataset that the forms will be using. My questions are how can I tell the thread is completed and how do I perform any clean up because every time any of the child forms (up to 5 forms) are closed a new thread is created and called again. Thank you for your time and appreciate your assistance.
Last reply by PlausiblyDamp, -
-
- 1 reply
- 1.1k views
I have a panel and one "add" button. When user clicks on the Add button, i hide one panel and display the other panel. The second panel displayed has text fields on it where users enter info and click the add button again and save to database. Well, if I have ONE "add" button with the hide/unhide panel AND the insert code, code just keeps on going and adds a blank row to the table, then displays the text fields. so this is what i did I created TWO add buttons. One is when the user clicks and it hides/unhides the panel. The second "add" button actually saves to the database. Any other way of having only 1 add button to perfom the 2 functions: hide/unhide and …
Last reply by eramgarden, -
- 2 replies
- 1.4k views
I have one stored procedure that returns 2 different tables (no relations at all) and I have one dataset called mydataset. What I want to do is have data from one of the tables in the dataset to be displayed in a repeater, the other to be displayed page bound. How do I reference both tables individually in the dataset if they are returned by the stored procedure. Oh - one of the tables in the dataset can have multiple rows. The other one has only 1 row (all the time, only one row). Thanks in advance for your help. Amy
Last reply by college_amy, -
Transactions
by Puiu-
- *Experts*
- 2 replies
- 774 views
I have a stored procedure that makes an insert into a database. Something like create proc InsAgent @Name varchar(100), @Age varchar(10), @Message varchar(100) output as insert into Agent values(@Name,@Age) set @Message='Success' My questions: 1. is it worth to use transactions with this kind of stored proc ? 2. If i want to exit a stored procedure i should type return In some cases i saw "return" followed by a number: return 11 or return 10... Is there any use for that number ?
Last reply by Nerseus, -
-
-
- Administrators
- Leaders
- 4 replies
- 2.8k views
Is the Autoscroll facility for forms and panels any good? I notice two problems with it straightaway - it doesn't show up if a control is off the left or top of the container, only if it is off the right or bottom, and if a partly obscured control gets focus it scrolls into view, which I don't really like. Is there a way to fix these or should I forget it and use my own scrollbars?
Last reply by rbulph, -
-
-
- *Gurus*
- Leaders
- 10 replies
- 3.5k views
We have a rather bizarre issue here, and I was wondering if anyone had any ideas: The Windows API exposes the call IExtractImage, which, among other things, can extract a bitmap from a URL link. It works quite nicely, except that it doesn't work in XP. The call is still there, but apparently doesn't supported extracting images from URLs in XP. Now, XP does create thumbnails from html in Windows Explorer, so I know the functionality is there. The question is: where is it? Where did they hide it? I've seen one product (html2jpg) that basically does this, but nobody seems to have noticed that this functionality is not available in XP. The reason that this is an i…
Last reply by privateer, -
-
- 1 reply
- 922 views
I have two tables in a database (created in SQL 2005 Management Console) that are full on: Select, Insert, Update & Delete. One Table (we'll call it customers) has had everything generated for it dynamically. All the commands and each command has all the parameters created and the logic for Update/Insert that is very... exaustive. A huge WHERE block. The other Table (we'll call Address, isn't this DB unique!?) Has a dynamically generated Select & Insert command (complete with parameters and logic) but no Update or Delete command. For some reason the generated parameters are all unique to the command and leave the TableAdapter level paramaters empty. So …
Last reply by Denaes, -
- 0 replies
- 1.4k views
Hi I am attempting to user dataadapter.updatecommand to update a row in a database table. I have created a dataset which contains all the rows in the database table except one. The dataset does contain data. The code that I am using for the update is: Dim tempDs As New DataSet Dim cmd As New SqlCommand cmd.Connection = cnConn cmd.CommandType = CommandType.Text cmd.CommandText = "SELECT * FROM Members" Dim daDataAdapter2 As New SqlDataAdapter daDataAdapter2.SelectCommand = c…
Last reply by mike55, -
- 0 replies
- 1.4k views
Hi there ! I need help with transparency and listboxes. The code below actually makes the listbox so transparent that items added to it are also transparent, unless you click them. When you release the mouse click, item goes back to transparent state. Any help would be appreciated. Thanks in advance. Imports System Imports System.Windows.Forms Imports System.Drawing Imports System.ComponentModel Public Class CustomListBox : Inherits ListBox ' Properties <DefaultValueAttribute(GetType(System.Drawing.Color), "Transparent")> _ Public Overrides Property BackColor() As System.Drawing.Color Get Return MyBase.BackC…
Last reply by geezup_2000, -
- 0 replies
- 743 views
Hai all, Can someone help me on How to dynamically generate and display crystalreport on a .aspx page ?
Last reply by sureshcd10, -
- 2 replies
- 848 views
I usually stay away from this one because I can get most to work with a regular expression validator. Anyway, what I have is a ListBox (<select>), and I want to ensure an item is selected prior to the form being submitted. It appears through my testing that the client side script doesn't fire when I submit the form unless I first select an item in the list box (which would take the point out of ensuring an item is selected). Furthermore, as a back-up I set the Server_OnValidate method to do a similiar check...it never fires, even when I expressly call Page.Validate(), or for that matter event the Validate method of the custom validator. I haven't ever seen…
Last reply by bri189a, -
- 1 reply
- 835 views
I am trying to integrate paypal's shopping cart into my site. To do this all i need to do is add an additem button for each item i intend to sell. If my site was coded in html, i would just paste the bellow code per each item : <form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!"> <input type="hidden" name="add" value="1"> <input type="hidden" name="cmd" value="_cart"> <input type="hidden" name="business" value="name@business.com"> <input t…
Last reply by hsueh001,
-
Who's Online 0 Members, 0 Anonymous, 60 Guests (See full list)
- There are no registered users currently online