9,022 Topics
i m using visual studio 2005. i am working on a windows application and i have a form and an mdiparent. On the form i have some buttons wich are control an sql server database and it works fine. when i make the form an mdi child then no one …
i create a form that user can enter their data then save into SQl server...that problm have being solve... Now i want the data to be automatically appeared in the text box and user can use the next button to search for their data..(text box created early for the user …
Please Frd me the .Net Architecture + SQL Architecture???
Hi, How-To for example: SELECT * FROM table WHERE columname > '2' [B]FROM THOSE[/B] WHERE columname > '4' [B]FROM THESE LAST[/B] WHERE columname > '6' Thank you very much, Core regards :)
This looks like a good place to get as well as post information. I've been working with computers since the early 80's (Wargames anyone?) I work with Dreamweaver, Flash, SQL Server, and a lots of other programs. I'm constantly leraning and sharing what I know with others. I look forward …
When I backup my SQL-Server DB to flash disk from server named server1, The operation was completed %100 successfully.But When I had tried to restore IT FROM FLASH DISKE to an other server called server2 the SQL server 2005 desktop Management studio refused the order and responded "The database is …
Hey, I am currently having some problems with VB.net and MSSQL. I'm trying to create an application to learn more about VB.net, I decided to create a simple login system for the application (like the ones they used in distributed applications which have a centeral SQL server). I have come …
Hello, My manager is all over me because of this issue ... please can some help me I am working on an VB6 application which use Crystal Report 8.0.1.0 for reports and the backend database is SQL Server 2005. My report uses stored procedure to get the records from database. …
How do i pass variables to data environment's sql?
I want to make a server authentication login. First I logged in with windows authentication, changed the server authentication from windows authentication mode to sql server and windows authentication mode. Then I created a login, named it jihad and changed the password for that login. Then I gave that login …
I want to make a server authentication login. First I logged in with windows authentication, changed the server authentication from windows authentication mode to sql server and windows authentication mode. Then I created a login, named it jihad and changed the password for that login. Then I gave that login …
Hi, can anybody shed any light on what I'm doing wrong here... I'm trying to acheive an XML that looks like the following: [code] <tshirt Name="Stussy NY Posse T-Shirt Yellow"> <variant size="small"> <productID>10</productID> <dimensions length="34" /> </variant> <variant size="medium"> <productID>11</productID> <dimensions length="45" /> </variant> <variant size="large"> <productID>12</productID> <dimensions length="50" /> …
I have a website adding orders to my database. These start at 10000000 and increment by 1. I have pieces of paper sent out in advance with order numbers on them. These start at 50000000 and increment by 1. We get batches of paper orders brought back and need to …
What is @@rowcount and with small code snippet explain the usage? Is the foll. code is rite-- Create procedure get_emp_count ( @emp_id int) As Select * from emp where emp_id =@emp_id If @@rowcount = 0 Begin Select 'no rows with emp_id= ' Select @emp_id End . Can u pls explain …
I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this …
i am new to this database. can i know where can i type the command?:'(
may i know how to add sqlexpress database to my visual studio project while iam deploying... (i tried by simply adding database into my project through solution explore before deploy , but while instaling deployed project into client machine ,on that time i cant access the data's from database.) can …
I recently purchased Visual Studio Pro '08 and installed in on Vista HP. It comes with SQL Server Developer, but I disovered I could not get that to install correctly. From what I have discovered on other forums, Vista HP does not expose IIS properly to SQL Server so Reporting …
Hi All I am new in development I want assistence in database design (asp,sql server) for crm schedule calender . If you have any sujessions or link, i will like if you post them
Hello ! As in my text book , the most effective means to export a database ( complet or few tables only ) is to use DTS . The only variables needed are destination and origin addresses . What happens , when we do not know the address of the …
I am using vb.net 2003 and sql server 2000 as backend. I would like to do searching that will receive several input from user (input from textbox,combobox and radio button) that will retrieve data from sql server and display the output in textboxes and picture box. I can do the …
Hi , I need your help please. I am using OSQL statement to execute SQL database script From CMD Line. Basically our application Support Other than English 5 Foreign languages, so each foreign language contains their on character set so its in Unicode format (`* byte format`). In the sql …
Suppose a table ABC have column XYZ containing data 3PSY0001-06-08-F 3PSY0001A-07-09-P 3PSY0001-02-09-P 3PSY0001-07-07-F 3PSY0002-09-08-P 3PSY0002A-01-03-P 3PSY0002-07-07-F How can i write a query so that the data ending with P without A can be updated with A. For example, with that query, data 3PSY0001-02-09-P AND 3PSY0002-09-08-P will be updated as 3PSY0001A-02-09-P …
i am currently doing a wap site for a university project and i just wanted to know how to connect my site to my to a database basically SQL server, i understand that this may be a simple problem to solve, i am just unsure as to how i can …
Hi, I am developing this app using ASP.NET 2.0, SQL Server 2005 express and VS 2005 express edition. All I am trying to do is use Login Web controls provided in ASP.NET 2.0 for my user login pages. When I go to ASP.NET configuration and click on Security tab I …
helooo, i really need a good tutorial about connecting php with informix-sql & how do i get the informix-sql server software? thanx parulian
I have production data on one server and test data on another. I need to move one record from the production server into the test table on a different server. I setup the production server as a linked server one the test box. I can read/select fine, but when I …
Allright. I have two queries, which provide the exact same result, yet the simpler one is roughly 100 times slower than the more complicated one. I have absolutely no idea what is going on here. And let me add, there is no recursion so this is no idiocyncracy of the …
I have a count set up in a SQL view set to '*' with the alias set to 'Cn'. I can get the column name with: [code=vb] grd.columns("columnName") [/code] But it does not work when I use the alias... How can I pull use alias instead of the actual column …
Hello, I want to convert sql database having four fields into a text file. Please give me details with code. Waiting for reply. Amol
The following code coincides with an onClick event on my form to move to the next record in a file, but I keep getting the Error Code: 424, object required. I have (3) other buttons on my form: MoveFirst, MoveLast and MovePrevious, but they all work fine. What is different …
I'm trying to install SQL Server on a Vista HP machine, but it will not detect IIS, which in turn prevents Reporting Services from being installed. I have seen blogs which indicate that the UAC system in HP does not properly detect IIS and that as a result NOTHING can …
Hi I have a collection which is the resultset of a sql query. when i write out the collection (using system.out.println(col)) my collection is in the correct order. -- which is great. But when i iterate through the collection in order to populate my linkedhashmap, the items are inserted into …
[B]Hi, How to connect to sql server...on a remote system using the IP address of the machine. I actually want to start the MSSQLSERVER on a remote machine using the sql service manager. how can this be done. thanks.[/B]
I had stored a word file in database in "image field" then I restore it in a byte array. I want to convert this byte array into string to write it on the web page. I am using ASP.NET 0.2 and SQL 2005. thanks.
I want to get two columns data from two tables which are not dependent to each other i.e. no key common in both they are not related to each other. I can't use JOIN because it needs where clause which uses a common field from both tables. I just want …
steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server(last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my …
Hi, I am sorry if I am posting ...at wrong place.I donno where to post this. I have developed a windows service which uses a timer...to run the SQL Server for exactly 30min.If sqlserer service is stopped it starts the service and stops it after 30min and vice versa. I …
Hi, I have a webpage set up that allows users to upload a file to a server from the fileupload control, which is then saved to the database with the blob file and the file name. What I would like to do now is retrieve this file by selecting a …
I have know solved the syntax error in the FROM clause. I have been trying to solve No value given for one or more required parameters, but have not been able to solve it. Could anyone please give me a suggestion. Error happens on da.Fill(ds, "RoyalYachtingAssociation2") I have tried changing …
Hi, We have to migrate W2K3 64-bit from W2K and it seems SQL Server 2000 (32-bit) XML services is not working on 64-bit OS. The url is something like that: [url]http://64bitserverIIS/APPL/TEMPLATE/userList.xml[/url] The error message is herebelow in IE: %1 is not a valid Win32 application. I could not find the …
In my web application: I want to store a .Doc file(word file) in database and then retrieve it and display it in the same format in a web page. I am using ASP.NET 0.2 and SQL 2005. thnx.
As the spyware itself ironically keeps reminding me, my computer has been infected with the classic "big red circle with a white X on the taskbar" virus/trojan/whatever program. My numerous attempts at killing it with tools such as Spybot and CCleaner have all failed, and I must now rely on …
Friends, I recently switched to SQL server 2005 from SQL server 2000. Well in SQL server 2000, I used to made databases manually and applied other SQL commands from Query Analyser menu. Where's the same functionality is provided in SQL Server 2005 . Where's the path to go there? Waiting …
I want make a query to retrieve only those records from table which are unique on the basis of some coloumns
I use pymmsql to access MSSQL 2000, with a table, I store Chinese Character in NVarchar field, Chinese Character display normally when I query them by MS SQL Query Analyzer under Windows or by unixODBC under Ubuntu. But when I query those data by pymssql or pyodbc, all Chinese Character …
Im using visual studio 2005 asp.net, vb language. How can i compare minimum and maximum values in a gridview when all the values are different in every row?
Hi, sorry for a newbie question but I was wondering if the following is possible: I have to select some information from a table which I have already created a query for. This information then has to be inserted into a new table but needs another column with another unique …
Hi all, My server will have multiple databases and I want, for security purpose, to have one user per database. This user will only be able to access that one table and no other. This user will have all rights to this database only. I created my first database/user combo …
Hi , First post in this forum and hope this is the right area: Website crashed and am rebuilding from scratch. Basically an ASP site, Data driven by SQL Server 2000 running II6 on Windows Server 2003 SP2. Problem is that any URL links that are generated from a stored …
The End.