Database

FirstPrevNext

Creating a Access Database from SQL statements in C# Wilye3-Jun-05 11:05 Wilye 3-Jun-05 11:05  Hi Im trying to create an Microsoft Access Database using the SQL "CREATE DATABASE" command, but very attempt I have used has lead to an exception, so if anyone out there has an answer to my problem I would REALLY appriciate it Wilye Transfering of files and folders Anonymous3-Jun-05 2:48 Anonymous 3-Jun-05 2:48  can any one suggest how to perform Tranfering of files and folders from one server to another server using asp.net Re: Transfering of files and folders Colin Angus Mackay3-Jun-05 4:29 Colin Angus Mackay 3-Jun-05 4:29  Anonymous wrote: can any one suggest how to perform Tranfering of files and folders from one server to another server using asp.net By granting the appropriate permissions to the account that ASP.NET is using. By the way, what does this have to do with SQL or databases? My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More IDispatch, ADORecordset and Property loss?!? almc3-Jun-05 0:54 almc 3-Jun-05 0:54  Hi there! I have a activex dll written in vc++ 6.0 There is one function that needs to receive a Ado Recordset from a VBasic application. It seems that after the VB does the call to the function, the ADORecordset loses at least one property: Sort. The function is receiving the ADORecordset as an IDispatch. Any ideia is a good idea to this problem... Thanks in advance. António Carvalho SQL DateTime average function? devvvy3-Jun-05 0:31 devvvy 3-Jun-05 0:31  Hey guys, how do I: SELECT AVG(SomeDateTimeColumn) FROM TimeLog WHERE EMPID=12345 Any useful script for lazy me? Thanks in advance. Norman Fung Re: SQL DateTime average function? toxcct3-Jun-05 3:35 toxcct 3-Jun-05 3:35  i don't understand neither your question nor your explaining sql query... TOXCCT >>> GEII power [toxcct][VisualCalc] Re: SQL DateTime average function? oykica6-Jun-05 7:32 oykica 6-Jun-05 7:32  You can't AVG a datetime. I am not sure what you are getting at. currency convertor Virendrak2-Jun-05 21:57 Virendrak 2-Jun-05 21:57  hi i need code 4 currency convertor automatic convert the currency 4 payment in online hotel reservation thanx viren Re: currency convertor Colin Angus Mackay2-Jun-05 22:21 Colin Angus Mackay 2-Jun-05 22:21  virendra kumar wrote: i need code 4 currency convertor It is a simple multiplication or division. Also, this question does not seem to have anything to do with databases. Source currency * or / exchange rate = destination currency. e.g. Pounds Sterling to US Dollars. Exchange rate: £1 == $1.87 £5 * 1.87 = $9.35 or US Dollars to Pounds Sterling $10 / 1.87 = £5.34 My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More Re: currency convertor Yulianto.2-Jun-05 22:53 Yulianto. 2-Jun-05 22:53  virendra kumar wrote: online hotel reservation Maybe you need this.[^] <italic>Work hard, Work effectively. Re: currency convertor Kareem Shaker4-Jun-05 23:20 Kareem Shaker 4-Jun-05 23:20  Yes, of course you need one online source to convert currencies this webservice is so interesting http://www.webservicex.net/WS/WSDetails.aspx?CATID=2&WSID=10[^], this is to make sure that you have an up-to-date currency rates! Kareem Shaker OleDB Problem Saksida Bojan2-Jun-05 20:16 Saksida Bojan 2-Jun-05 20:16  In my database i got: ID, Name, Type, Comment But when i fill to grid. my Columns reorder: Comment, ID, Name, Type But i want to have an ordier like in database. How can be done. I used the tutorial on web: http://www.c-sharpcorner.com/Tutorials/OleDbDataAdapterDesign.asp I am using Jet 4.0 as connection I have noticed if i change select statment, but there isn't any effect. I hope i dit posted this on correct forum. Can anybody help me. Thanks in advance. Re: OleDB Problem Yulianto.2-Jun-05 22:58 Yulianto. 2-Jun-05 22:58  I think the problem is in your grid. How do you fill the grid? <italic>Work hard, Work effectively. Re: OleDB Problem Saksida Bojan3-Jun-05 5:16 Saksida Bojan 3-Jun-05 5:16  dgCDList->DataSource = core->databaseDataSet->CD; core->oleDbCDData->Fill(core->databaseDataSet); Set up mail account for reporting services PaulCurry2-Jun-05 14:56 PaulCurry 2-Jun-05 14:56  I need to set up a mail account for reporting services in SQL 2k can anyone point me to some information Thanks Paul beginer ADO prob - inserting into access martin hayes2-Jun-05 10:02 martin hayes 2-Jun-05 10:02  Hi all, I would be most grateful of some help !!!! I have a number of Text boxes (including a rich text box) and I simply want to insert the data into an access DB. I have made a ADO.net connection, adapter and then it has generated a dataset (using GUI not code). I can display the data but just can’t find a good explanation of the statement needed to insert into DB Any Help would be fantastic !!!! Thanks Martin Re: beginer ADO prob - inserting into access Christian Graus2-Jun-05 10:16 Christian Graus 2-Jun-05 10:16  First you need a database to exist that expects values in columns that relate to what you've got in your text boxes. Then you need to do an insert using SQL, here is a reference: http://www.w3schools.com/sql/sql_insert.asp[^] This project will be doing what you want, perhaps you should look at it also: http://www.codeproject.com/cs/database/csharpaccessdb.asp[^] Christian Graus - Microsoft MVP - C++ Re: beginer ADO prob - inserting into access martin hayes2-Jun-05 10:31 martin hayes 2-Jun-05 10:31  Hi, Sorry to bother you but i am unfamiliar with C# and am still having big difficulty. I need a very basic step by step help. Would be most grateful Thanks Martin Re: beginer ADO prob - inserting into access Christian Graus2-Jun-05 10:42 Christian Graus 2-Jun-05 10:42  C# uses the .NET framework, as does VB.NET. The API calls will be the same. Perhaps if you could break down exactly what you're finding hard - do you know anything about SQL to start with ? Do you know anything about how ADO.NET works ? Did you know how to bind a data source to a data grid, or did you copy the code from somewhere ? If I have an idea of your skill level, and what bits you're struggling with, perhaps I can be more specific. Christian Graus - Microsoft MVP - C++ Re: beginer ADO prob - inserting into access martin hayes2-Jun-05 11:07 martin hayes 2-Jun-05 11:07  Hi, I have no SQL experience ! I know the basics of ADO.NET i.e. create a connection adapter and dataset this can then be used to bind to datagrid, listbox ... However i have no idea about how to work with connections. Thanks for all your help ! Martin Re: beginer ADO prob - inserting into access Christian Graus2-Jun-05 11:26 Christian Graus 2-Jun-05 11:26  Try this[^] as an intro into the overall code you need, and the SQL Insert page I linked you to before for info on the Insert statement generally. So long as you have a database already that expects the values you want to write, you should be fine. Make sure you're providing a value for each column in the row you're creating, unless a default value exists. Christian Graus - Microsoft MVP - C++ Scripting User in SQL Server 2000 Rizwan Bashir1-Jun-05 23:56 Rizwan Bashir 1-Jun-05 23:56  Hye There I have created one user in SQL Server and it has rights in two different databases at a time. Now I want to script the user. the option available is to script with in database by right clicking on the database then script. I want to scrip the user to get rights on all the databases togather. Any Comments Re: Scripting User in SQL Server 2000 Colin Angus Mackay2-Jun-05 0:31 Colin Angus Mackay 2-Jun-05 0:31  Rizwan Bashir wrote: I want to scrip the user to get rights on all the databases togather. Have Enterprise Manager create the two individual scripts for you then use a text editor to merge them into one script. My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More Datagrid update and current row under edit. Itanium1-Jun-05 2:09 Itanium 1-Jun-05 2:09  Hi All, When bound datagrid to some table, edit a cell in a row and press SAVE button(on my toolbar) to update it. it doesn't update the row being edited, until we focus on row below it or above it. Regards, sorry for my bad English. SQL Oraclce code to SQL2000 convertion Mohammad Daba'an31-May-05 22:26 Mohammad Daba'an 31-May-05 22:26  hi, i have a code works with oracle sql i want to change the problem in it that doesn't work with sql2000 soplease any one help me the sql statement is: select folderindex, NAME, PARENTFOLDERINDEX from pdbfolder connect by prior FOLDERINDEX=PARENTFOLDERINDEX start with PARENTFOLDERINDEX = " + indexx + " order by(PARENTFOLDERINDEX) it gives me an error on line to when i test it on the sql 2000 query analyzer so what is the solution :-> Thanks alot Mohammad Daba'an

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 0:42 Refresh ᐊ Prev1...2094209520962097209820992100210121022103 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.