9,022 Topics
hi frnds, how can we connect to a sql server database using C++ program.can anyone pls post a code for this ...
Hello! I've got web application created for MSSQL and IIS. There are two directories in this application - Scripts and WebSite. In Script there is file CreateDb.sql. I need to run it so that it can create database. I changed in that file one line into this: CREATE DATABASE [NameOfDb] …
Hai iam a new one to vb.net but i have done a project in it.that is front office management system. but we done the data connections(sql server) through the builtin methods ie from data menu in the toolbar add datasource through this... now i need two information 1-how to connect …
Hello! I tried to install MS SQL server express 2008. I run SQLEXPR32_x86_ENU.exe and see: "SQL Server 2008 Setup requires Microsoft .NET Framework 2.0 SP2 to be installd. Download and install .NET Framework from [url]http://www.microsoft.com/net/[/url] and then return Setup". I downloaded dotnetfx.exe - that is .NET Framework 2.0 SP2 and …
How can I create group report in Data Report by writing code without using Data Environment. I'm using VB 6 and SQL server 2000.
Hi everyone, It's my first time with looping through data in a query. I know there are two ways of doing this and one is using CURSOR (I read it'snot the nicest thing to use). Wouldn't mind hearing your thoughts. I will copy and paste my first attempt at usingCURSOR …
how I send a data by click button ,I know using SQL Server. I really new in this subject? Thanks
I am working on an application and I have SQL server 2008 running on my local machine when I start the application everything works fine, but when I moved my application to my laptop the program connects to sql server, but it cannot find any of my stored procedures when …
hi there, in my database, I have a match table, and one of the columns is matchdate I also have a country table, where each country has an ID. I have a seasons table where each row is linked to a country and has a start date and end date. …
Hi everyone! I have the following problem I am trying to solve: I have one table with data and need to access the same column twice, everyone with different criteria and then output the results on one table. I tried [code=sql]SELECT e.user, SUM(e.column), SUM(f.column) FROM table AS e INNER JOIN …
Hi all, What is the best method to move data from an access database into sql server database with different table and field names? If possible could you give me an example? Thank you so much!
Hi I already Install the MS Sql server 2005 into my machine,but I want to install the Sql server 2008 into my machine.I want to install the sql server into "D:" Drive, because of few space available in "C:" drive. 1)Can I install sql server 2008 into "D:" drive? 2)If …
I have a huge stored procedure which calls other mini-ones. The problem is that I need a temp table and I'd like to avoid a real table being used as a temp one. You've probably guessed by now, but if you haven't, a table variable is created at the beginning …
Hi everyone. I'm relatively new to MS SQL but one of my clients has a site based entirely around it so I am having to get to know it a bit better. While trying to clean out some of the fake emails from the mail list table they all got …
Hi all, I have searched high and low for this answer but turned up nothing concrete. I am using MS SQL Server and ASP. I have a database with a table which includes a field with a TEXT datatype. I have created a simple stored procedure to select all the …
So i have a gridview linked to a sqldatasource. auto generate is off. I change some of my fields to template fields, set some to read only ect. on my aspx page. Then i make a modification to my stored prodecure and click refresh schema to see my changes show …
In my application i have used DataGridView for displaying the data available in my table (SQL database). The form containing the datagridview is accisible from the menu in MDI Form. [COLOR="red"]Problem: [/COLOR]Every time i access the datagridview form, the same data gets appended to the old data in the datagridview …
Hi there, I'm working on an application for a lab project and I'm making it in C#. It's supposed to import results from a text file that is exported from the application we use to run the tests and right now, I've hit a road block. I've gotten the program …
hiiii how can I use 2 different select statement to insert 2 different values in same insert statement ????
good eveninh sir/madam, error is :- An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. code is : - Dim a, b As Date a = Date.Now.Date b = a.Now.AddDays(-7) Dim dataset2 As New DataSet Dim myconn As SqlConnection = New _ SqlConnection("server=;database=project3;uid=;pwd=") Dim obj_deletecommand As …
hi,i have a problem in installing sql server 2005 express,and even 2008.Ive searched the net for possible solutions but Ive not seen an error the same with me so ive decided to ask now. I hope someone can help me. this is the error Ive received when i install sql …
Okay, I had a thread in the HTML and CSS section, but I'm going to put a new one here with more detail. My friends have created a Cabal private game server, on THEIR computer. Im trying to create a site for it using my computer, but AS OF NOW, …
Hello, everyone. Can someone explain to me on how to read a .mdf file (the SQL Server 2005 Express kind)? I have a Java IDE (JCreator) and the JDBC (SQL Server 2005 Express compatible) installed into this computer. Right now, I'm using this: [CODE]Connection c = java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost\\SQLEXPRESS;DatabaseName=qsscsdb;IntegratedSecurity=True");[/CODE] to read the …
Hi all I crated a Report in SQL Server Reporting Services. The Report uses 1 parameter. When I exe the Report in my IE it asks me for the parameter and then run fine. When I use Subscriptions' I can put there my email. And sent it to me. (Work …
Hello all, i have a small question. In mysql i can do "select 'abc' into outfile 'c:\out';" is it possible to be done only with sql querry (to be executed at the server manager). I tryied select 'abc' into outfile 'c:\out.txt' and got the error : Incorrect syntax near 'c:\out.txt'.
Posted - 08/08/2009 : 20:48:04 Hello, I hope someone may have some suggestions for a SELECT statement I am trying to create. I have a primary table like: Field1 Field2 Field3 1_____AAA____BBB 2_____BBB____AAA 1_____CCC____DDD 5_____DDD____KKK Secondary table like: Field1 Field2 Field3 Field4 1__________________X 2____BBB____AAA____Y 1____CCC___________Z ___________________J Desired Result: Field1 Field2 …
Hi all, I've written a piece of software that connects to a server's SQL database. The software has a timer which fires every second, and the timer connects to the database every time and pulls out a list of current to do's from a table (CurrentToDoList). This database only has …
Hello, the first question is, how do iknow if the SQLEXPRESS server that in my machine is work well? i have sqlExpress and i also have the sql studio management, i am creating database and tables and all works fine. but when im tryin to call to a database from …
I have a datepicker on my form that I need to use as an integer value in the form yyyymmyy in an sql procedure. Can anyone tell me how to extract the datepicker value to an integer variable? Thanks
Private Sub cmdLogin_Click() Dim comSave As New ADODB.Command Dim sqlAdd As String Set RS = New ADODB.Recordset With comSave [COLOR="red"].ActiveConnection = ConnDB[/COLOR] .CommandType = adCmdText End With ConnDB.BeginTrans sqlAdd = "INSERT INTO UserName (FullName,IDCard,CustomerID,Office,Address,Telephone,UserId,UserPwd)" sqlAdd = sqlAdd & "VALUES('''& txtFullName.Text & ''', ''' & txtIDCard.Text & ''', ''' & txtCustomerID.Text …
Hello, I have two issues and I hope someone can help me with it. I have been on this problem for 3 days now, And I can't resolve it. #1 Issue I have a database in access 2003 that is the front-end and the backend on sql server 2005. I …
Hi frnds I have a problem im using sql server 2005 I have a database on my local machine and on a web server. I want that through stored procedure or a query i shud b able to synchronise the database on the remote serveras the local database... Can anyone …
hi friends i am a new bee to the world of sql server, started with it a few months back... i deleted a table from sql server by mistake, and trying to recover it. but i dont hav any backup concerned. is it possible to recover that table without backup, …
Hello everyone, I'm disapointed around problems of fct datetime:) I have a datetime column and I want to display the time period of the days in a datagrid: For exemple : H1 = Monday to Friday, from 06:00:00 to 21:59:59 H2 = Monday to Friday, from 22:00:00 to 05:59:59 H3 …
I have a web application for recording time, bonuses and commissions for employees. I am having a hard time joining three tables together. Here are the tables: employee - provides employee information including the primary key emp_id emp_timecard - provides recorded time from employees tc_bon_com - provides bonuses and commissions …
Hey guys, in my website the user uploads 3 random files. I've uploaded these in a folder on my machine using the FIleUpload Control. But now i want to give a link to the user to download the uploaded files. This is what i've done so far: [CODE]HyperLink link1 = …
Hi all, I'm going to attempt to create middleware in C# and i need some advice. What I'm looking to do is have an open socket, then when our VB app connects to it, it makes another socket and keep the newly connected one open. It then has to get …
Hi , I'm trying to read some details from Excel using ASP. The .xls sheet has got a column Time where the values are 00:00, 00:03 etc..but ASP is reading the first value as 0 & the second value as .3125 etc..so when writing to SQL Server database, I can't …
I am trying to design a Query in SQL that will enable the user to enter a customer code. However being new to SQL I do not know the language. I have selected the data from the tables, however I want to add criteria. In Access I used [] and …
My problem is as follows: 1- suppose you are in database db1 2- in db1 there is a role :role1 3- there is another database :db2 4- db2 contains a stored procedure :sp1 5- now, I want to grant the role (role1) in db1 a permission to execute the stored …
Here i am converting image to binary and saving it in sqltable , i got this code from some website but NOW I DONT KNOW THE WAY TO RETRIEVE THE BINARY DATA FROM SQL TABLE AND CONVERT IT BACK TO **IMAGE FORMAT** AND DISPLAY IT IN WEBPAGE public byte[] FileToByteArray(string …
asp.net c# sql server I have a web form that I use to insert data into a sql database. I want to know how to prevent inserting duplicate records into the database. Thanks. Ichu
hi, I'm trying to get daya into a new table via form. two fields in new table will pick up data based on look up tables. pls guide as to how do i proceed . The code is flashing conversion of Data type error. To avoid the datatype error, i …
hi friends We are connecting to sql server with Java and jsp as front end for our application. We are almost 10 people connecting to same machine regularly. earlier, we were just 4 or 5 connecting to one machine, now all are connecting to same machine, coz of some policy …
I made a cross tab query. please see the attach file. the sum of category show in textbox in my project. like: Stationary = 2000.00 Machinery = 5000.00 Salary = 2200.00 here I can write sql command like:[CODE]select sum(stationery) from table1 [/CODE] but here I know the category"stationery" so I …
I am trying to make an interface for my database. SQL Server 2008 express is used in my database. The compiler error prompted me an invalid outside source procedure. Here is the code. [CODE]Dim a As New adodb.connection Dim b As New adodb.Recordset Dim sqlStr As String ' String variable …
HI, I am working on a project and need to take the sql table structure out using python language. Basic idea behind is to prepare a program which could run on any sql database and table name provided could fetch what are columns and rows present in that table.
Hello Everyone, I am having difficulty looping through an array of stored procedures. The issue: Array with x number of stored procedures Column names identical in all Stored procedures (PO_Date, PO_Data, PO_Pointer) Each stored procedure has three inputs pi_pid, pi_from, pi_thru Must execute each stored procedure in the array Must …
Hi here image is getting converted into binary and getting inserted into sqltable . [B]Now I want the opposite of it i mean i want to retrieve the binary data and display it as image. [/B] [code]protected void btnupload_Click(object sender, EventArgs e) { // set temporary variable for database connection …
Ok, I guess wasn't as specific as I needed to be. Here is essentially what I need. I have two separate tables application_status and application_status log. Within the application status table there is the application_status_id and the application_status_description. The application_status_log table holds information on applications and the connecting factor between …
The End.