[microsoft:sql-server] Forum Topics

I have an asp.net web page that a user is loading a file to that I want to parse data out of. The following text is some sample data (I'm told that it's supposed to be .csv but as you can tell, it's really not.) Resource:Wills MD, Robert P; Ward …

I am using a custom made application that is using MSDE 2000 transact SQL. Thing is that I've made a simple batch file in order to save databases automatically every day but it seems I made a mistake... I never expected the server to save in the same file if …

hi any body plz help me I want to create new table from an existing table with data and definition.

Hi friends, im using VS 2008 TS. For the last few weeks i was having this problme that i cannot connect to the SQL sever from my Crystal reports data source config. When i try to craete a new connection it doesnt display any DB server in the server drop …

Yoe guys, need your help.. I want to know on how to setup my client computers and the server so they can connect to sql server 2005 Developer Edition. Client computers are Windows XP. Server is Windows Xp installed with a SQL Server 2005. They are on the same Workgroup. …

Hi I am using SQL express 2005 and I need to be able to take old data (data inputed two weeks ago or older)from a table in data base A and move it to a table in database B. I have very little experience with SQL so any suggestions will …

hi we are doing ATM project in VB.NET using sql connection....how to create database in sql...there are two labels in my project namely pinno and acctno.i had database with three fields pinno ,acctno and amt.how to check the details i entered in textbox1,textbox2 are same when compared with database...pls answer …

How do I retrieve data from MSSQL Server using Javascript? I am used to doing things in PHP, but I want to have an interactive form which is able to display Sales Tax after user types in his zip code. My query is similar to: "select top z.rate from zipcodes …

Hello, my code is below: [CODE] private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'sampleDataSet.contact_Query' table. You can move, or remove it, as needed. //this.contact_QueryTableAdapter.Fill(this.sampleDataSet.contact_Query); OleDbConnection aConnection = new OleDbConnection(dbconnection); OleDbCommand aCommand = new OleDbCommand("select id, name, mobile_num, date_created from contact …

hi can any 1 write code for me to check wether the ur already exists in sql database using c#.net

I'm trying to create login form in C#. I store username and password in SqlServer 2008 express using the stored procedure [CODE]ALTER procedure [dbo].[InsertNewUser] ( @UserName varchar(30), @Password varchar(30) ) as If exists(Select 'True' from Users where UserName = @UserName) begin --This means that the user name is taken select …

I have a bit of a unique situation. I am loading a DropDownList (asp.net) from a SQL DB. Let me explain my scenario. [Products] [DB2.dbo.Orders] -Product_ID -Order_ID -Product_Name -Order_Product_Name -Product_Price -Order_Product_Price -Order_QTY [DROP DOWN] [PRICE_LABEL]* [OrderQTY] +ADD ProdName1 ProdName2 ProdName3 [PRICE_LABEL]: *(gets pulled by Select Product_Price where Product_Name=DropDown.Selected) After I …

When printing or exporting a SSRS report, is it possible to hide information? I don't want a hyperlink that is used for report navigation to be visible on a PDF. I would prefer that a user doesn't have to manually toggle visibility. Thanks.

I'm making some sort of mistake in the following code: [CODE]use xPress_CR select * from (SELECT * FROM dbo.T_JOBS WHERE ENDDATEANDTIME = null UNION SELECT * FROM dbo.T_JOBS WHERE STATUS = 'Failed')[/CODE] Any idea what I'm doing wrong?

I need some help regarding Paging on a Gridview. I have a few dropdownlists and textbox and a gridview. At first load, the gridview will be populated with data from the sql server. And, I did a search and it works for the first page. When I press the second …

I have field in sql called gender,and when i click in browser for male or female it sholud get updated in my database also.. how to do that.. guide me pls...........

[I]<<split from [URL="http://www.daniweb.com/forums/thread289067.html"]here[/URL]>>[/I] As tha same i 2 had tried but t is coming error like [B]Default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, [COLOR="Red"]error: 40 [/COLOR]- Could not open a connection to SQL Server)).[/B]

I'm attempting to write the formula for a computed column in SQL Server 2005 using SQL Server Management Studio 2008. I get the error validating formula and I'm not sure how to write the formula to work. If it were standard math the formula would be: (mmtot * 22) + …

I am inserting an int value using numericupdownvalue from a form to database, using the following code [CODE]SqlCommand cmd = new SqlCommand("insert into student where student_no='"+numericupdown1.value+"'",con)[/CODE] Now I have another form that is when loaded, will read the inserted value made by the numericupdown.value, using the following code [CODE]numericUpDown1.Value = …

Hi, i have followed a tutorial and modified it to get a image stored as a blob from MSSQL, it is working perfectly - however i utilised handlers in this tutorial. and while it is working fine - id quite like to understand what is going on! [code] <%@ WebHandler …

i have a windows form application, and i want that when i execute the program, program must show me the main form quickly, but my program firstly do some operations (connecting to sql, filling the combobox etc. ) because in form_load function i call a function to fill the combo …

I am trying to write a php code that will determine if a user has viewed the Facebook app before, and if they havent to show a "welcome page" instead of the normal "index" page. Is there a way to read the sql table and forward them to a "welcome …

What are this? I read this on some forums. It goes like this [CODE]da.InsertCommand = new SqlCommand ("insert into table values('')",con);[/CODE] a dataadapter calling an sql command? Could someone explain me this?

I'm writing a small search tool that searches a SQL Server database using Full Text Indexing. I have two text boxes with four radio buttons between (NEAR, OR, AND, AND NOT) Ex. CONTAINSTABLE(jobs, *, ‘computer NEAR California’) This works fine but if I start adding more text boxes\radio buttons (As …

hello there... acctually i m creating a desktop application in vb.net so on the data insertaton page i had got an error that is "the ConnectionString property not initilized".. so i m posting all my code here... kindly help me.. [code] Public Class Registration Private Sub Button1_Click(ByVal sender As System.Object, …

how to change Hardware requirements for sqlserver in AUSUS mother bord

Hi I need an urgent help...... I Have made a project on C# where i have use MS-SQL as a database....after that i have published the program which creats exe of my program.......after creating exe 1) I download .net framework 3.5 to friends computer. 2) Then i install MS_SQL Server …

SCENARIO 1 : I have 3 projects in my solution: 1) Web Project (Presentation Layer) 2) Class Library Project (Business Logic) 3) Class Library Project (Data Access Layer) Following are the dependencies among these 3 projects: 1->2->3 (It means I have referenced PL in BL and BL in DAL. In …

I'm tyring to connect to the sql server on my lcoal machine and have this error. "An error has occured establishing connection to the server. Failure may be caused by the fact that under the default settings SQL server does nto allow remote connections.(provider:Named Pipes Provider,error 40 - could not …

[CODE]SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Data Source = kumar\\SQLEXPRESS; Initial Catalog = phonebook; Integrated Security = TRUE"; connection.Open(); SqlCommand cmd = new SqlCommand("Select * From contacts", connection); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds, "contacts"); comboBox1.DataSource = ds.Tables["contacts"]; comboBox1.ValueMember = "phone"; comboBox1.DisplayMember = "name"; …

Hi all i have a problem in a task assigned to me in sql 2005 i have table contains column called ID which is an integer i would to retrieve top 10 rows order by ID in descending order and i want the result of this query to be in …

I have a column in my database that has a list of keywords. sometimes the keywords are a couple of words and sometimes just one. Each keyword (can be more than one word) is separated from a comma. for example - this is my column - hi, how are you, …

Private Sub cmdsummery_Click() Set wss = DBEngine.Workspaces(0) Set dbs = wss.OpenDatabase("Gagedetails.mdb") Set rss = dbs.OpenRecordset("tblGage") 'Set rss1 = dbs.OpenRecordset("tblopeName") Do While Not rss.EOF OSQL = "SELECT DISTINCT OpeName1 FROM tblGage WHERE Date =" & SQLDate(txtdate.Text) Set rss = dbs.OpenRecordset(OSQL) MSQL = rss("OpeName1") NSQL = "INSERT INTO tblOpeName (name)" & " …

Hello, Is any one know how to display a crystl report in C# windows application and bak end is SQL Server 2005

Hi I need to write a sql script to split a string in two or more parts. e.g. I have a string: "tag: key1, key2, key3" I would like to use the ":" as a seperator and thus end up with two strings: "tag" and "key1, key2, key3" Is this …

i have developed a student form asking student details such as name, address, class, standard etc... The details are saved to STUDENT table (SQL Database). There is a another form with datagridview control showing data of STUDENT table. The form2 can be shown on student form by VIEW button on …

I am following the code in a previous thread and cannot access SQL database. See attached login.aspx and login.aspx.vb files. Database file is a simple "Users" filw with AutoID, username, email and password. What am I doing wrong? Any help is greatly appreciated.

hi Im building an asp.net application which sends data to another webservice and then sends the data back. I get it to receive the data and save it into a sql database. But I cant get it to display in the gridview. I have been struggling with this for over …

Hi, I'm kinda new to the c# programming and I have an assignment to make a simple app for accounting. So, I made a DB in visual studio, made a new project that is connected to that DB. Table B has a column 'FK_TableA'. On a form I have put …

I am doing a bulk insert on a web page to a sql server (via a browse and upload button) and currently when a user supplies a file thats in an incorrect format, we simply return them a message stating that it is in incorrect format but what I would …

Hi Guys!! I am new to InfoPath, using 2003 just need a bit of help! I am using sql Server as backend, and I need to validate the form values in the backend, something like if already exists(userid, product) not be able to submit the form again, inorder to reduce …

hi i have create a database in sql , it is opened in my system, and i shared the database into another system,i was updating my datas from another system, form and database everything is working fine , but the problem is when i try to open the report it …

people plix help me with ASP code for login. am using MSSQL i want users who have registered using their emailadress and passwords to be able to login.

Hi, I have dettach my database from SQL server2005 and attach it on Visual Studio2008. and then make the connections. when i run the program it shows the data is avaliable but when i stop the program and then run it.it show u dosent have any data why its happends. …

So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they …

Dear Sir, I need information about store procedure in SQL and how can i access textbox values into store procedure. and connection string for remote server (sql server 2005 installed on server) pardeep

Is there a problem with my code? i'm trying to refresh a few form checkboxes based on text typed into machinetxt.text with what is currently stored in the database. i put this into the refresh button click event. here is my code: [CODE]Private Sub machinerefreshbutton_click(ByVal sender As System.Object, ByVal e …

I have been using the code below to edit SQL database fields from the data stored in a dataset. Problem is I have to repeat this long code for each database field to be edited....I find this very tiring...IS THERE A SHORTER WAY OF EDITING SQL Database FIELDS. (Am using …

hi i've parse the string in c sharp and got the array of string and i want to save this array of string in sql databse in different column like id in id column, description in description column. Now my problem is whenever i execcute my insert query the data …

Imagine functions (as in coding): there is a function call, to each function there are parameters and whereas the names and the amount of parameters is specific to a function, the value of that parameters is specific to the function call. For example: Add (Number1,Number2) ADD = function Number1 & …