[microsoft:sql-server] Forum Topics

hi there, i know maybe this topic has been discussed by other member, but i still not understand how is work. i hope can get more detail solution on it. i wan to do a page at the backend,when the date is end of this year(12/31/2007) then will execute the …

[B][COLOR=red]Hello everyone, [/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]someone help me ? i have a problem with vb script i paste the coding here just chek it out where i am wrong [COLOR=green]raj.ActiveConnection = MM_ravi_STRING[/COLOR] i got error here:( Thanks email me on [email]ravindrakale007@gmail.com[/email][/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]<[/COLOR][/B][EMAIL="%@LANGUAGE="][B][COLOR=red]%@LANGUAGE="VBSCRIPT"%[/COLOR][/B][/EMAIL][B][COLOR=red]> <!--#include file="Connections/ravi.asp" --> <% Dim raj Dim raj_numRows[/COLOR][/B] …

i want to delete a selected row from the database.the entries of database is shown by a gridview and i do <OnRowDeleting="GridView1_RowDeleting"> in source code. i select and bind as follows. [mycode] string str = "select PNR,CreditCardNumber as 'Credit Card Number',EmalAddress as 'Email Address',PassengerName as 'Passenger Name',PassportNumber as 'Passport Number',IPNumber …

could any one help in inserting images or files directly into mssql database using cold fusion and also should pull the data directly from the database without using any temporary folders both inserting and retrieving.

Hello all! :-/ I am creating a program which reads data from a database. How can I change the connection string to format anyone who would use this program on there computer? My current connection string is made to specifically read from my folder(s)... conn.ConnectionString = "C:\Documents and Settings\servername.\Desktop\Pamela\CheckReader\Database\CheckInfo.mdb" Thanks …

Is it possible to display the datagrid's rows coloured according to certain criteria, what shall i use....I mean to let SOME of the rows of the datagrid to be displayed colored, how shall i do it? am working on VB.net and SQl Server

I'm in need of some help with 3 tables I have with MSSQL. Is there a way to use a single database query to get the results I'm looking for? (See the bottom for an ideal returned recordset.) Thanks! TABLE: APPLICATION APP_ID APP_NM GRP_ID -------------------------------------- 1 Script 1 1 2 …

What is the proper way to implement a 1:0,1 relationship between tables? I have two cases where I would like to use this. First, I need to track members of a school. Since students require more info than faculty I created two tables, Person and Student. The Student table contains …

I've been thinking pretty heavily about what I want to do as far as a career is concerned. I knew that I wanted to work with computers, but I hadn't figured out in what capacity. I recently narrowed it down to Network Administrator or Database Administrator. I've since decided that …

hi there, i have posted my code...please am seeking help, syntax wise Here's my code , please i do need help myda = [COLOR=green]New[/COLOR] SqlDataAdapter("Select Distinct COUNTRY from FO_TestingLines_TBL order by COUNTRY", ConfigurationSettings.AppSettings("myconnection")) ds = [COLOR=green]New[/COLOR] DataSet() myda.Fill(ds, "AllTables") OPERATOR.Visible = [COLOR=green]True [/COLOR]COUNTRY.DataSource = ds.Tables(0) COUNTRY.DataTextField = ds.Tables(0).Columns("COUNTRY").ColumnName.ToString() COUNTRY.DataValueField = …

Hi All, I want to develope database-driven application using JSP and JRun as the server. THe thing I want to know is how do I connect to the MSSQL Server 2000 database using JSP? What type of JDBC? And how to install the JDBC driver? Thanks in advance... :)

Hi, I have few reports which have been created using the Microsoft Sql Server Reporting Services.Now i want to create similar reports using Oracle Reports 10g. Will i need to start from scratch the creation or is there migration tool that would reduce the efforts for the same. Thanks in …

I have a simple login screen where I want the user upon entering the correct userid/password , for his userid to be inserted into a table in a database so to keep track who visited his web page. My ISP is supposedly has created a DS named "win5_zjconstructioninc_com" but the …

LibraryDB is a database system that keeps track of information concerning the books and their circulation in an imaginary library. [B]Disclaimer[/B]: The data that populates the database are artificially constructed and by no means correspond to actual real-world data. The schema for the LibraryDB database is given below. [INDENT]borrow([U]transactionID[/U], personID*, …

i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you …

I need to create connection pool i think shared connections and controlled through semaphores. or its only on connections string level? , i saw code in java but NET nothing.

I've just finished a long term contract and looking for another big project; 3-6 month contract or a full time offsite position as an ASP.NET developer/architect. I have 6 years of a full cycle development experience with ASP.NET 2.0 (C#) and Microsoft SQL Server 2005 development. * I have strong …

Hi all, I am trying to insert date but not able to, im using SQL server. This is my code: [COLOR=#0000ff]Dim[/COLOR] str [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]String [/COLOR][COLOR=#0000ff]Dim[/COLOR] cmd [COLOR=#0000ff]As[/COLOR] SqlCommand [COLOR=#0000ff]Dim[/COLOR] con [COLOR=#0000ff]As[/COLOR] SqlConnection [COLOR=#0000ff]Dim[/COLOR] sql [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]String [/COLOR] [COLOR=#0000ff]Function[/COLOR] AccessDate([COLOR=#0000ff]ByVal[/COLOR] dateandtime) [COLOR=#0000ff]Dim[/COLOR] myday [COLOR=#0000ff]Dim[/COLOR] mymonth [COLOR=#0000ff]Dim[/COLOR] myyear myday = Day(dateandtime) [COLOR=#0000ff]If[/COLOR] …

I have an SQL database and an ASP.NET home page. I want to add, delete, update/create data directly to the database from the home page. How can I do this. Give an example if possible

I'm Using Microsoft Visual Web Developer 2005 Express Edition to design a web site, and it displaying this error " Saver Disabled" any time that i try to run the programm , pls what is d couse of this problem and how can i solve it. am using SQL Server …

i have one Problem, please tell me what should i keep in mind, about the following Errors "Application uses Value of wrong type for the current operation" This is th errors in vb6 Set prmNum_key = ComNum_key.CreateParameter("Num_Key", adBigInt _ , adParamInput) Set prmExtension = ComExtension.CreateParameter("Extension", adBigInt _ , adParamInput, , …

hello, I have a table with int Primary key. Is there a way to set identity property on this field w/o dropping/recreating the table? Thank you.

Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. …

Hi All, When I deploy an VB.NET application to manage documents formatted following Microsoft Office such as MS Word, MS Excell... But I want to store them by database as MS SQL Server or MySQL. Please help me do that. Thanks, Kinh

Question - ASP + Ajax Hey! Not sure if this is the correct section to post this. ;) Well, I have a table in my sql server 2000 database *************** tblAddress ---------------------------- City_Name (varchar) Venue_Name (varchar) ******************* The "City_Name" column contains all the name of the cities in my country …

Hai, I need to read the Foxpro(dbf) file, and execute that file in MSSQL through Java code. That means Migrate the Foxpro dump file into MSSQL. Also i am using the Struts Tags for create new application. But the Tag was not working. I am using the following code for …

Hi all! I am new in this forum! Its really nice to see forum members helping each other out. Anyway let me cut to the chase, I have been programming in VB.NET since last year. Even though I'm not very good at it, but at least i was able to …

[COLOR=#0000ff]UPDATE[/COLOR][COLOR=#000000] table1 [/COLOR] [COLOR=#0000ff]SET[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC] [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#808080]([/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]SELECT[/COLOR][COLOR=#000000] ID[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000][DESC][/COLOR] [COLOR=#0000ff]FROM[/COLOR][COLOR=#000000] tmptable[/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] tmptable[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN [/COLOR][COLOR=#808080]=[/COLOR][COLOR=#000000] table1[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]ID_SUN[/COLOR][COLOR=#808080])[/COLOR][COLOR=#000000] [/COLOR] [COLOR=#0000ff]WHERE[/COLOR][COLOR=#000000] [/COLOR][COLOR=#808080]EXISTS [/COLOR][COLOR=#808080]([/COLOR] [COLOR=#0000ff]SELECT[/COLOR] ID[COLOR=#808080],[/COLOR][DESC] [COLOR=#0000ff]FROM[/COLOR] tmptable [COLOR=#0000ff]WHERE[/COLOR] tmptable[COLOR=#808080].[/COLOR]ID_SUN [COLOR=#808080]=[/COLOR] [Table1][COLOR=#808080].[/COLOR]ID_SUN[COLOR=#808080])[/COLOR] [COLOR=#808080]I tired this but i coudn't uptade tow columns at once[/COLOR] [COLOR=#808080]do i need to seperate them or i have any mistake? …

Asset Table +-------+---------+-----------+ | Date | Asset | Value | +-------+---------+-----------+ |1/1/07 |Building | $1000 | |1/2/01 |Computer | $ 500 | |2/1/07 | Fax | $ 100 | +-------+--------+------------+ Result Table I would Like; +-------+---------------+ | Month | Total Asset | +-------+---------------+ | 1 | $1500 | | 2 …

hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number …

Hello everyone! [COLOR=#000000]I ‘m new to SQL Server 2000... [/COLOR] [COLOR=#000000]My industrial supervisor wants me to study about the best practices for database maintenance. I’m not sure about the content of my project. Could anyone give me some guidelines…? [/COLOR] [COLOR=#000000]Thank you[/COLOR]

Hi I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below: _DBConnection = New SqlConnection '(ConnectionString) _DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False" _DBConnection.Open() when I …

Hi all I want to select data from a database and display it on a GridView. My problem is it doe not return anything when i use the WHERE clause but when i use SELECT * it works. I am new in ASP.NET, please help. here is the code i …

Hi Everybody, I am a newb in SQL Server 2000. I have a genuine question. Actually what is the use of this sql server, just to store information/datas of small size??? that is: Name: Anish Age:22 Sex: Male in this format?? Maybe this question arises in my mind due to …

Hello there I want to retrieve data from the sql database according to departure plase and Destination selected on the dropdownList, Something like "WHERE departurePlace = @DeparturePlace AND Destination = @Destination", I want to display the results on a different page (i am not sure if its possible). Can you …

hi i want to obtain a value of a table with date restrictions, so i created two fields, one for the inicial date and other for the final date. when i try to do that the result is always null...i don't no why... i use this statement: "SELECT caminho_foto FROM …

[COLOR=#0000ff]hi everyone, iam a newbie in asp.net.even it sounds silly doubt to u ,plz help me.i want parameters in a sql query to insert a record.i wrote the program like this,but iam not able to insert the data.so,plz say my mistake . Dim[/COLOR][COLOR=#000000] str [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]String [/COLOR][COLOR=#0000ff] [/COLOR]con = [COLOR=#0000ff]New[/COLOR] …

Hi, I need to export data from two seperate tables in database to the same sheet in excel. ie, the data from the tables should appear one below the other in the same sheet of excel. Could any one tell me how this can be made possible.Also could any one …

I cant call : [111.111.111.1].Database.dbo.fn_test(@test) (Not working !) but i can call : Database.dbo.fn_test(@test) why ? and if no way to call this, can i populate in a function a TABLE variable using a Stored Procedure to do this ? CREATE FUNCTION fn_test(@idcode int,@idoper int) RETURNS TABLE AS RETURN (EXEC …

[B][COLOR=red]am trying to develop a website, and d following error displaying when i was trying to run it, [/COLOR][/B] [B]Server Error in '/WebSite12' Application. [/B] [B][I]Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.[/I] [/B] Description: An unhandled exception occurred during the …

Hi all. I am trying to setup a Login Script in VB.net. I have been trying to use the below code: Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim mypath = Application.StartupPath & "\security.mdb" Dim Password = "" Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Phoenix\Develop\mailorder\mailorder\security.mdb") Dim …

hi..good day to all.. i want to ask.. i have a page "coverletter.aspx".. in the page_load, i would like to [B]check whether the surveyID contains any cover letter or not[/B]..if there is any, i wanted to load the cover letter and display into textbox letter.text...else..i want to load the default …

Hi All, I have a question and I hope you guys can help me out. If you have worked with php-mysql, you might have noticed that there is a featured to encrypt a password while inserting it in the database using the password() function. I am looking for a similar …

hi friends........ I have created a database in a web server.... i have the server ip address .... and also i have the control pannel acces fot for tat particular server.... but how i will acces tat particular location using my sql server please help me......

hi i m using sql ad vb.net for my project can somebody plz send me the code of last button

[B]Server Error in '/WebSite11' Application. [/B] [B][I]Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.[/I] [/B] [B]Description: [/B]An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where …

Hi all i have 2 DBs: Energy & Users [U]Users:[/U] -id (pk) -nick [U]Energy:[/U] -id (pk) -title -userid (fk) -dateposted Description of workflow: there are a number of titles in "Energy", and each user has more than 1 titles. I would like to display Users's Nick, and LATEST TITLE (which …

i have a problem.. i just can't see where i did go wrong.. when my page loads, i want the name and email appear in the textbox so that user can edit their name and email...but then, it doesn't update the record, but continue to save the old value of …

hai all i am undertaking a project of sending sms to mobile phone using sql server 2005,pls guide me how to do that,[COLOR=red]this is urgent please:'( [/COLOR]

Hello, I am new to this forum. I want to learn ASP . I am basically a VB programmer with good experience. I want to learn ASP with SQL SERVER. Kindly provide me the links with some good tutorial to start with Thank You