[microsoft:sql-server] Forum Topics

Hello everyone, I have a project that the user can create/customize a report in a form,.. And in my project I have a form where user can choose a multiple tables, and also user can choose which fields they put in the report form..............., but the main problem is only …

I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed: SQL Server 2008 SQL Server 2008 Browser SQL Server 2008 Management Objects SQL Server 2008 Native Client SQL Server 2008 Setup Support File (English) SQL Server Compact …

I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial ([url]http://www.programmersheaven.com/2/Les_CSharp_0)[/url], and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell …

I have the following Stored Procedure which works for one client but not another:- [code] ALTER PROCEDURE spIssueScannedTickets @iEventID int, @MemberNum nvarchar(12), @BatchSize int, @FirstNumber nvarchar(12), @LastNumber nvarchar(12), @SlotsBalance int, @TableBalance int, @BonusBalance int, @UserID int AS DECLARE @Result int SET @Result = 0 BEGIN TRANSACTION if (@SlotsBalance>0) INSERT INTO …

hi I'm trying to execute a stored procedure which returns a datatable my code is: [CODE=asp.net]try { string conStr = WebConfigurationManager.ConnectionStrings[0].ConnectionString; SqlDataAdapter adapter; DataTable ans = new DataTable(); SqlConnection connection = new SqlConnection(conStr); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "usp_GetUserDetails"; command.Parameters.Add("@UserName", SqlDbType.VarChar); command.Parameters.Add("@Password", SqlDbType.VarChar); command.Parameters["@UserName"].Value = …

I have a solutin with forms that use table adapters to input data into sql tables and that all works fine. My trouble comes when I have another form that uses a sql stored procedure. When I try to connect to the server I get an error that the login …

Hello all. When I run the statement: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%23%' I get the result: 2009-01-23 08:05:06.000 Administration Software is Closed. Operator's Name:admin But if I do: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%-23%' the result is null... why?!?! TIA, -hdmnp

I want to simply insert a few string values which i have successfully retrieved from an Excel Sheet. I have tried the "stored procedure" method but am not able to get what what i want. Just a simple C# code to insert value in SQL server 2005 using the SQLquery …

I need help in using "[COLOR="red"]between[/COLOR]" sql function. I don't know how to use it. I am comparing two time using [COLOR="red"]dtpicker[/COLOR]. The time should only be acceptable if I input between 6:00am and 6:00pm like 7am, 8am,.........6:00pm. 5am below and 7pm above are not acceptable. In need help. . …

hi i need to know how to query a number of count on a particular table let say i have [B]emp_id[/B] and [B]emp_name[/B] field. on my table their are 2 records. the result looks this: rowcount | emp_id | emp_name 1 1000 albert 2 2000 leah is it possible? thanks, …

i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno Student Slno 1 2 3 4 5 I want to display them as slno 1 2 3 4 5 Thanks in …

Hi, I am trying to update a datetime field in a table using asp.net web form. However I am getting the following error message: @poduedate is not a parameter for procedure prr_out_projsearch_update1. The parameter I am adding to a stored procedure in the asp.net page is the following: [code]cmd_r.Parameters.Add("@poduedate", Data.SqlDbType.DateTime) …

Hi All, I plan to have a website that has database connect to it. On my database, I want to display vietnamese characters (Input and output). How can I add vietnamese collation on my MS SQL Server 2005 developer edition? I am looking forward your help. Thanks.

Hi All, I plan to design a website that uses for online news or magazine. I am having MS SQL Server 2005 Developer Edition. Please help me how to design a database. Please let me know where I can obtain information to design it or db diagram. Thanks.

HI..Plz help me by giving ideas,opinion or suggestion. My objective of my project is is to send sms to the customers 40 minutes before their car is finish for servicing and ready to collect.I've model the flow of sending sms where 40 minutes b4 done,the car will send for washing …

I am using the login control in ASP.NET. When I run the program an error msg "Incorrect syntax near the keyword 'User' " appeared in the debugging mode. I have no idea what is the problem. Anyone know what is wrong with my code? [CODE] Protected Sub Login1_Authenticate(ByVal sender As …

[code] <html> <head> <title> database connectivity </title> </head> <body> <H1> DATABASE CONNECTIVITY </H1> <% dim constr constr= "provider=sqloledb;data source=1.234.5.678,1234;initial catalog = abcd; User Id=abcd; password=abcd" set conobj = server.createobject("ADODB.Connection") conobj.connectionstring = constr conobj.open set comobj = Server.CreateObject("ADODB.Command") comobj.CommandText = "test2" [COLOR="Red"]comobj.CommandType = adCmdTable[/COLOR] set rs1 = comobj.Execute %> </body> </html> …

Hello I am upsizing a MS Access database to SQL. I am keeping the MS Access 2003 frontend and using a SQL Server for the Backend. All the MS Access VBA code seems to be working fine except for the code below. I have the same code using different tables …

Dear All, I want to establish a remote connection with sql server 2005 in my Asp.net web service. How to do this in a effective and secured way, Please reply me with sample code, that will be very helpful for me. Thanks in advance, Thanks & Regards, Vasanth

Hi, Could anybody give me some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application? Thanks

Hi guys, Im trying to create a console app that will read from a text file and import the file into a sql database. I have completed the following already: Read from a text file and put out to console Read from sql database and put out to console Now …

Hello everybody, I've been working in my college project which is a simple movie database. My problem is the following, 1) The user has to input a keyword in a textbox and then select a field (Title, actors, director, rating, release year and category) after that the user has to …

hi i want to call a sql server stored procedure from my webform. the stored procedure return parameters. how can i "catch" these parameters and use hem ?

Hi guys, Very new to sql and my question is prob very basic. I have a table desing shown below. I will using a c# program to add new rows to the database but i only want to add a new row if the hostname doesnt currently exist in the …

i've wondering here,if i can combine windows application and web aplication.Can i develop main page in web application then i want to access to the windows application.(e.g there's a button to link process mgt page.But process mgt page is developed in windows application).Else, if i do a view page on …

Hi there, i would like to find out what the hell is wrong here [code] /// <summary> /// Get a single integer value /// </summary> /// <param name="sql">The sql query used to retreive a result set</param> /// <returns>The value of the first column in the first row of the result …

HI, I am Using VB 6, how do I sent data over the internet to an SQL DataBase

Hi, Im using 2 radio buttons for male and female as gender. So wat would be datatype for this variable in MS SQL Database. I tried a lot bt it troubled me some where a bit. Whenever im saving the radio button data in DB the problem i find is …

i've wondering here,if i can combine windows application and web aplication.Can i develop main page in web application then i want to access to the windows application.(e.g there's a button to link process mgt page.But process mgt page is developed in windows application).Else, if i do a view page on …

I have a sql table consisting of dept_name and dept_code.and on the form i have textbox for dept_code and combobox for dept_name.When i select a particular dept_name from the combobox i should get the corrosponding dept_code in the textbox.

Hello 1 and all I have created a stored procedure for table X. X contains the fields B,C,D,E,F,G. B is a primary key with data type int. I am giving the stored procedure as follows: [code]Create Proc [dbo].[spXSelect] @B int=null as Begin If @B is Null Begin Select Ident_Current('X') as …

Hi, I have a table above 8.000.000 records. I am running a query like "select * from table where id=1093203". And the query turns in 24 second. This example i tested in SQL Server 2000 v8, Windows 2003 sp2. I am running same query in Windows Xp + Sql server …

Hey, so i have 4 tables i need to join together. basically this is how it looks table j: | id | uid | cid | text | | 1 | 3 | 1 | blah| | 2 | 1 | 3 | blah| table u | id | name …

I have a quote program I have made and i'm looking for a way to lock the records once it has been approved. I have a form that is filled out and a calculation that is done based on the fields that are linked to an sql table. What method …

I am using C# 2005 and SQL Server Express 2005. My table "PreRegistration" has a field named "FormNo" of data type smallint. In my dataentry form, i need to display the next available FormNo in the text box. The program should find the last alloted FormNo, add 1 to it …

Note: I debated whether this should go in ASP forum or SQL Server forum and I think it belongs here. Ok, I have a classic ASP web application, a custom intranet, which has been used in 7-8 different installs, 3-4 different servers with no issues. It uses a SQL Server …

what exactly is a 'Database Schema' ?? and how can i make one ??

Hello all, i have SQL 2005 installed. i have written a table-valued function getdepartments() which is as below: [code] CREATE FUNCTION getdepartments() RETURNS @departments TABLE( DNAME VARCHAR(25), DEPTID VARCHAR(10), DBONUS DECIMAL(7,2)) AS BEGIN INSERT @departments SELECT * FROM DEPARTMENT; RETURN END [/code] i need to invoke this statement from java …

Hi all professionals, I am just an amateur compared to most of you. I am contemplating starting an extremely lengthy program, just for my own purpose, which basically does a holiday reservation to whichever and whatever place in SA, for now. I am just thinking this idea for building up …

Good Day All i have a table that carries a Field that has data like this [CODE] 10101010101010[/CODE] Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be [CODE] 1 …

[code] public partial class FrmNewUser : System.Web.UI.Page { SqlConnection conn = new SqlConnection("Data Source=SONIA-B408A4159\\SQLEXPRESS;Initial catalog=sonia;Integrated Security=true"); string query; SqlCommand cmd; public string name="Code"; protected void Page_Load(object sender, EventArgs e) { btnRegister.Attributes.Add("onclick", "javascript:return LenofPassword()"); } protected void btnRegister_Click(object sender, EventArgs e) { try { query = "Insert into Newuser values(@UserName,@Password,@FullName)"; cmd …

OK, basically I want to check the DB against the elearningid... if the elearningid startdate and enddate are valid, continue, else redirect to expired.php... EXAMPLE: [code] <?php function TimeBomb() { rs = sql.Execute(" SELECT * FROM elearning WHERE elearningid=@elearningid AND GetDate() BETWEEN startdate AND enddate "); if (rs.RowCount > 0) …

I'm trying to create a *.csv file using the records stored in a table. Searching the Net, I came across a code snippet that I modified for my use. The relevant code is [CODE] If dlg.ShowDialog = Windows.Forms.DialogResult.OK Then conn.Open() csv = dlg.FileName tw = New StreamWriter(csv) Dim sql = …

Hi, I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to …

Hi All, We have a local MS SQL 2000 database which is daily updated by the users. We have a remote MS SQL database under windows based hosting. Now i need to update all existing data from local MS SQL to remote MS SQL database. I also need to find …

Some of the time, we have to run/execute the SQL scripts using command prompt or the sql browser, but i were to replace these actions with just a single click of button, i need to create a functionality with java whereby users can perform these actions with an interface. But …

hi i have made one website in VS 2008 (Asp.net 3.5) using back end SqlServer 2008 and when i configure my website on my local pc so it will generate the error "Login failed for user" when i will going to run the website .

hi can anyone help me i have a billing system, how can i save the data to another table? using sql? may 1 table name is transac and all i want is if what the record have been save to my transac then it will save to another table name …

Hi , I want to retrive the xml data into my database table. The xml file is from outside of application.so i want to retrive that xml data into database with in some temporary table Thanq

hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an alternative way instead of typing (INSERT INTO.. 10x) statement repeatedly. thanks.