Database

FirstPrevNext

Re: DropDownList Jerry Hammond7-Jul-06 4:00 Jerry Hammond 7-Jul-06 4:00  I'm being kind and looking at it as implied. “Profanity is the attempt of a lazy and feeble mind to express itself forcefully” Re: DropDownList PlayByTheRules5-Jul-06 2:51 PlayByTheRules 5-Jul-06 2:51  1. What does this have to do with SQL (the subject of this forum) 2. The people here volunteer their abilities in their spare time, for free, for the benefit of others. Saying your problem is "Very Urgent" is not going to get you a faster response. I would suggest that it does, in fact, turn off some people because they would rather help someone who appears to appreciate the scenario in which the questions are being asked. i.e. a community forum. If you want urgent help with your problem then I would suggest you call Microsoft Support who will help for a small fee. Re: DropDownList Jerry Hammond6-Jul-06 18:12 Jerry Hammond 6-Jul-06 18:12  This could arguably be deemed an ADO.NET question as well as an ASP.NET question. Either forum is correct, imo. Jerry “Profanity is the attempt of a lazy and feeble mind to express itself forcefully” how to use now() function in the access? KSCsoft5-Jul-06 0:01 KSCsoft 5-Jul-06 0:01  When I update data,I hope the datetime change together.so,I use the Now() function,but throw the Excetption.look at following: @ID @name, @sex, @age, "Update mytable set name=@name,sex=@sex,age=@age,DateTime=now() where ID=@ID" so,how to modify?who can help me? thank you! KSCsoft Re: how to use now() function in the access? sathish s5-Jul-06 0:26 sathish s 5-Jul-06 0:26  you can always can have the value of "date" field filled with the current date/time by setting the field's Default value to =Now() in Access table design mode. What is the exception you get? Re: how to use now() function in the access? KSCsoft5-Jul-06 17:42 KSCsoft 5-Jul-06 17:42  you are right!but it is insert,not the update. KSCsoft Re: how to use now() function in the access? Eric Dahlvang5-Jul-06 3:32 Eric Dahlvang 5-Jul-06 3:32  KSCsoft wrote: @ID@name,@sex,@age MSAccess doesn't use the @ symbol for variable naming. Your problem isn't the 'now()' function. --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters Re: how to use now() function in the access? KSCsoft5-Jul-06 17:50 KSCsoft 5-Jul-06 17:50  I use @ symbol for variable naming in the asp.net. I just wanna know When I update record,the datetime field's value is the current time! KSCsoft Re: how to use now() function in the access? Eric Dahlvang6-Jul-06 3:26 Eric Dahlvang 6-Jul-06 3:26  DateTime is a reserved word in MSAccess, and you have chosen it as one of your field names. Try using brackets around it: [DateTime] --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters Transferring data between databases divyaswati4-Jul-06 18:50 divyaswati 4-Jul-06 18:50  I wanted to transfer the data of one database to blank database in SQL With Windows Application divya -- modified at 6:38 Wednesday 5th July, 2006 Re: Please help me it's urgent Igor Sukhov4-Jul-06 19:24 Igor Sukhov 4-Jul-06 19:24  I would recomend using management tools (that comes with your database) to perform a data migration tasks. Best regards, ----------- Igor Sukhovhttp://sukhov.net Re: Please help me it's urgent PlayByTheRules4-Jul-06 22:14 PlayByTheRules 4-Jul-06 22:14  divyaswati wrote: Please help me it's urgent This is a useless subject line. It tells those who can potentially help nothing about your problem. Your subject line should describe your problem in a few words. For example: "Transferring data between databases" would be a much better subject line. There are no guarantees about the speed we can help with your problem. We are all volunteers and help when we can. So, describing your problem as "urgent" is unlikely to have any impact on the speed with which you receive an answer. strategy for when to update DB from dataset [modified] Ed 544-Jul-06 18:14 Ed 54 4-Jul-06 18:14  Hi, What event should I use to trigger an update of a dataset to the originating DB, in order to take max advantage of dataset scalability without losing data? I'm building an ASP .NET website driven by an SSE database. Hopefully there will be several thousand users. When a user logs on, the codebehind queries the DB and retrieves up to several dozen records belonging to that user. The user can add, delete, and modify records on several webforms. I'm using a dataset and SqlDataAdapter to get the records at login and caching them in the Session object. Right now I'm calling SqlDataAdapter.Update(dataset) every time the user submits a webform with a new record. That works, but it doesn't seem very efficient. But I can't figure out how else to do it without potentially losing records. What if the user enters a record, and then closes the browser window? What if he times out or goes to another website before my Update method runs? How do I take better advantage of datasets and data adapters? Is there a way to detect the end of a Session and set up an event handler to run an update then? Or maybe cache to the Application and run an update on time intervals? I apologize if this question is elementary. I'm early in the learning process for C# / ASP .NET / ADO. TIA -- modified at 0:15 Wednesday 5th July, 2006 Re: strategy for when to update DB from dataset Frank Kerrigan5-Jul-06 1:52 Frank Kerrigan 5-Jul-06 1:52  Run the code SessionEnd event as well if its a ASP.NET web page. Look where you want to go not where you don't want to crash. Bikers Bible How to write the Access ConnectionString that have set password? KSCsoft4-Jul-06 16:32 KSCsoft 4-Jul-06 16:32  my Access database have set the password,but I don't know how to write the oleDb ConnectionString.somebody help me! thank you. KSCsoft Re: How to write the Access ConnectionString that have set password? Paul Conrad4-Jul-06 17:29 Paul Conrad 4-Jul-06 17:29  Check out this site, Connection Strings[^]. It is worth bookmarking Re: How to write the Access ConnectionString that have set password? KSCsoft4-Jul-06 18:16 KSCsoft 4-Jul-06 18:16  I have found out,thank you very much!! KSCsoft getting next row data into focus Glen Harvy4-Jul-06 15:03 Glen Harvy 4-Jul-06 15:03  I have created a windows form using C# / ADO.Net that contains textboxes that are populated at initialisation with the contents of the first row of a dataset - works well. I don't specify the actual row because the SELECT query returns the rows in the desired order. What I want to do is have a "next" button on that form populate the textboxes with data from the next row. 1. Can I just execute some onClick code to do this easily and if so where can I locate an example code? 2. I'm just learning ADO.Net as well as C# and would appreciate pointers to where I can find some good tutorilas on the net to help me particularly with database access/manipulation. TIA. Glen Harvy Re: getting next row data into focus DIMPLE_R4-Jul-06 19:14 DIMPLE_R 4-Jul-06 19:14  Hi Glen, You may want to check this link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbwlkwalkthroughdisplayingdatainwindowsformusingparameterizedquery.asp Hope it helps --Dimple Re: getting next row data into focus Glen Harvy5-Jul-06 0:43 Glen Harvy 5-Jul-06 0:43  Thanks for the reference. It's close enough for me to learn from Glen Harvy Re: getting next row data into focus Mike Osbahr6-Jul-06 7:36 Mike Osbahr 6-Jul-06 7:36  If you are using the Visual Studio IDE, there is a template form for data. The wizard will ask if you want to display one record or multiple records. Selecting one record will generate a form that has the text boxes for editing data values as well as the navigation controls. The code generated should be very similar to the example you've already seen. For a simple application it might be close to what you need without all the cut & paste. >>>-----> MikeO Re: getting next row data into focus Glen Harvy6-Jul-06 10:51 Glen Harvy 6-Jul-06 10:51  Mike Osbahr wrote: If you are using the Visual Studio IDE I am. Thank you for this - I'm learning the IDE as well so you've helped with two areas that I need development on Glen Harvy Add Tables Brendan Vogt4-Jul-06 5:01 Brendan Vogt 4-Jul-06 5:01  Hi, I want to make use of the .NET 2.0 memberships and roles tables in my database. I'm referring to the following tables (not all is listed): aspnet_Applications aspnet_Membership aspnet_Roles aspnet_Users aspnet_UsersInRoles What is the best possible way of getting these tables in my database? Creating and running the SQL script? And how do I write code to access and modify the contents of these tables? Is this the best possible way to go about it? Regards, ma se Re: Add Tables -Dr_X-5-Jul-06 7:27 -Dr_X- 5-Jul-06 7:27  Take a look at this article. It may be helpful. http://aspnet.4guysfromrolla.com/articles/121405-1.aspx#postadlink[^] I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970) SQL Server 2005 Brendan Vogt4-Jul-06 4:16 Brendan Vogt 4-Jul-06 4:16  Hi, The creation of a new login is a bit confusing to me in SQL Server 2005. I usually use username sa and it's password. But now I'm trying to add the DotNetNuke database, with a different login name. They say I must go and create a new login, and a new user. What is the difference btween the 2? This does not just apply to the DNN database, I want to do the same when adding any other new database. Please can someone help me with my confusion?? Regards, ma se

Last Visit: 31-Dec-99 18:00     Last Update: 23-May-24 0:56 Refresh ᐊ Prev1...1858185918601861186218631864186518661867 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.