[microsoft:sql-server] Forum Topics

Been trying to run a schema script from within vb.net. No matter how I format it I can't I just get all kinds of syntax errors: Here is my VB script: [CODE]Dim sqlservername As String sqlservername = Tservername.Text Dim SQLStr As String Dim ConnString As String ConnString = "Data Source=" …

I know this is probably really easy but I'm at a complete loss and I've been unable to find anything on the web. How do I get the name of the local SQL2008 instance? Please help!!!

Hi guys, I'm stuck at this query I'm writing. I'm hoping someone will be able to help me. I have 2 linked tables: subjects and visits with a relationship on subject_id: table subjects: Subject_id, name, birthdate table visits: Visit_id, Subject_id, parameter1, parameter2 Now I need to query that will get …

I have a Sub Routine as below: Private Sub SaveRecord() Call InsertIntoTable1 Call InsertIntoTable2 Call InsertIntoTable3 Call InsertIntoTable4 End Sub I want to use the transaction object in such a way that it starts just before the first Insert Call and ends after the last Insert Call. The situation is …

i want to retrieve 2nd row of a column from datareader object... i want to show 1st row value of datareader..... if seattype_code == "00", 2nd row value if seattype_code == "01"...and so on..... what method shud i use for dr..as it is not working that i tried..? dr = …

Hey All, I wanted to find if it this is possible. I have a db in sql server with some large tables and I would like to transfer the entire db from one server to another server without having to create the tables and so on. Is this possible? Thanks

I am just starting to work with Visual C++ Express 2008 and have run into a situtation I could use help with. To add a new data source to a project I am told to start the data source configuration wizard, this I can do. Next I am to select …

Hello, I have an access database with 3 tables. The table i am working on is tblemployee. On a form i have a combo box with the employee numbers. Now, when a user chooses an employee number from the drop down box, i want the initial and name of that …

Can I reformat a phone number in SQL manager. I imported a foxpro dbf with the dts wizard and it imported the phone number as (609) 555-1212 I need it to be 6095551212

Please I am now making a project using C# and I want to connect to a database how to do this using visual studio 6? Thanks

I have SQL Server Express 2008 installed in my computer. I need to create a Login to this using C# code. That is, I need to implement the same functionality that is performed when you create a Login to SQL Server using the wizard. Also I need the program to …

Hi, I have developed a windows database application in vb.net 2008 express and sql express 2008. Is there a way to create reports in the application? Thanks

Hi, I have a problem with an insert into ms sql(web-based). I keep getting an error Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ';'. /admin/dataentry2.asp, line 147 the actual code the asp page is [code]function addRecord() v_Name = replace(Request.Form("Name"), "'", "'") …

hi, I'm kinda puzzled here, i just finished working on my application and tried to use windows setup wizard. my program needs a database with it, so i included the database in the application folder. the question is... is their anyway to lock the database file so that no one …

what is mean by query optimization in sql? dint get proper answer in google

how do find out sql storeprocedure error in asp.net pages

[url]http://www.picturebang.com/images/331323386942[/url] Hi to all, this the first post in the forum and i have some of questions need to be made in SQL Statements.. i tried to answer some of them and the other i don't how to make it.. so plz help me becauze i'm a new in SQL …

I am using the following code to retrieve the last entered value from a table and insert it into a textbox called rf. The code below works but the DB remains open until I restart my computer. [code] Sub Page_Load() If Request.QueryString("VesselName") Is Nothing Then VesselName.Text = "Blank Name" 'some …

Hi, I already have a VB program to parse the data from the webpage and loads into the table for 3 values And I need to modify as it refers to the new page and the column is 14.And also, in this new page i need to search for a …

Hi Guys, I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access. In the form, the user enters their information as well as checks the applicable check boxes. When they have completed the …

I have the problem: "List all details about software records. Sort the output by package ID within tag number." I'm a little confused about what they mean "within tag number" Is the following sql right or wrong, if wrong can you help me fix it? Thanks. [code=sql]Select * from software …

I went through many threads here, I also found a few threads related to what I need, but none worked. So please if anyone can check if there's any mistake in my code or tell me what exactly I should do... Actually I am able to view the data which …

hello to all , i have problem , my sql table called Kings and its look like this ID Game1 Game2 Game3 Game4 Game5 Game6 Game 7 Date Username 1 213 222 323 232 522 212 122 3.4.09 user1 2 214 212 325 432 262 222 292 3.4.09 user55 3 …

Hi, I am having a bit of trouble. Here is what I have. Main Form - the atari pong game High Score Form - the grid view of the simple SQL database PONG database contains: ID (identity auto increment) and FinalTime (string) Basically I cannot get the stopwatch text box …

I have created Database. table and procedure inside that. I want to generate sql script for this. How can I do that in .Net 2005? also after generating script, how can i run that to create tables in another computer?

I have a table off which I need to parse out the data using certain criteria. The table contains 3 datetime columns called '[B]ReadingTakenOn[/B]', '[B]StartedOn[/B]', and '[B]StoppedOn[/B]' Here's the criteria for selecting the records: The Dates in the 'ReadingTakenOn' column should lie between the Start Date and Stop Dates (both …

In The Name Of God Hello All i will connect to my table in sql server 2008 but display this message to me. [url]http://www.uploadgeek.com/share-10D4_49F1AEF5.html[/url]. can anyone tell me how can solve this prfoblem? thanks alot. goodby.

Hi, I have a problem with my login control. I changed the code in order to use my own database (SQL Server 2005) and no matter what i do i get the message "Your login attempt was not successful. Please try again. "!!! in the web.config file i chose my …

I am trying to connect to a database but I have no clue how to do it or if it's even possible. The server address is: sql306.byethost5.com How would I connect to this server if the username is usn and password is pwd?

Hi am using sql server 2005.. I hav a query like this. [CODE]create PROCEDURE [dbo].[csp_UpdateAutoPart] ( @Code NVARCHAR(6) ,@Quantity INT ,@UnitPrice DECIMAL ) AS BEGIN -- Update the autopart details UPDATE dbo.AutoPart SET dbo.AutoPart.Quantity = @Quantity ,dbo.AutoPart.UnitPrice = @UnitPrice WHERE dbo.AutoPart.Code = @Code end[/CODE] While executing it, almost 32 rows …

Hi. I am making a project on student attendance register in vb.net2005 with sql2000 server as backend. I am getting the data at runtime from database in data grid viewer. But if a user wants to edit a record, i want to give rights that he is able to edit …

For example you want two tables that have a column that has an identical id and that id you want to print out in another table. how will you code it?

public class QRYExecuter: SqlDataReader { } class is defined as above while building this, i get exception below: The type 'System.Data.SqlClient.SqlDataReader' has no constructors defined pls, can u solve it?

Hi, I would like to install SQL Server 2000 Enterprise Edition in my PC having Vista OS. Pl explain me the step by step process to install SQL as both Server & Client. (K. S)

hi there:wave: I need some help. I am using vb6.0, a mshflexgrid. I am displaying data to mshflexgrid that is from sql data base. What i need to know is that "how will i move automatically (by row) to the mshflexgrid". I am thinking to use a timer but I …

I'm looking for some guidance on getting a list of local SQL08 Instance names in to a selection box. I don't know where to start, thanks all.

anyone has an idea where i can setup the language (the dateformat) for my ms sql database?? Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas??

Hi, Consider there are 3 tables as following: Table1 ============================================================================================= | SerialNum | Date | B | C | D | Table2Number | Table2_Amount | Table3Number | Table3_Amount| ============================================================================================= | | | | | | | | | | | | | | | | | | | | | …

hi, there, i am coming up with this form and i am having problem with my connection string .i am unable to enable the user instance. It is because of that, I am unable to connect asp with the database. My connection string in the web.config is as below: <connectionStrings> …

Hi friend I have a question of 2 parts I have to insert new entries from a file in a table once every month Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of …

hi, there, im coming up with codes to connect asp.net interface(Track) with asp.net interface(Clerk). i am not sure if my codes are correct. at the same time, i am not sure how to write codes to write the select statement which can connect asp.net interface with sql server. please help. …

hi there, im having problem with the whole codings here. i can't execute the programme.please help.tell me whats my mistake. i need to connect it to the microsoft sql server [code=asp.net]<%@ Page Language="VB" %> <%@ Import Namespace="System.Data %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Configuration" %> <%@ Import Namespace="System.Data.SqlClient" %> …

Hi I'm new at this I have created a database Person with (ID,Name,address) in MS SQL an d I have the following code [CODE]protected void Button1_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlConnection conn =new System.Data.SqlClient.SqlConnection(); conn.ConnectionString ="integrated security=SSPI;data source=SQL Server Name;" +"persist security info=False;initial catalog=northwind"; try { conn.Open(); string sql = …

HI All, i want to develop web application which does the Custom t-shirt designing in C#.net and sql server. Any .net control available for the same or demo control. please let me know, Any idea will be ok. Waiting for reply, Thanks in advance, Nitsh

Hi , I have a problem with my program. i want to insert a text box value into sql table ,the text box entering value is the price of an item. then my database table field datatype corresponding to that is 'Money' field. then i can't insert the value to …

Can anybody tell me why i am getting duplicate value.when i try to make query.here is the sql statement.what i have written.Kindly find the screen shot also. [code] SELECT m.productname,m.unit,e.quantity FROM (MaterialRequisitionOrder AS p INNER JOIN MaterialRequisitionDetail AS e ON p.requisition_no = e.requisition_no) INNER JOIN Materials AS m ON e.item_code …

hi this is prob a very simple question. I have a website that that is acting as a monitoring program. On the homepage i need to display Currently monitoring $$ servers Where $$ is a select count statement from a SQL server db. My question is how do I do …

Hi, Im using Visual Basic 2008 to make my program. I want to be able to input data from textboxes to my database tables using a buton, I created the database with the SQL server compact built into VB. I am really usnsure and getting really frustrated with how to …

Hi I wrote below coding ,and last Message "Test" never appear in my project ,it means while loop never works.Plase tell me what is problem in my coding [CODE] public partial class Form1 : Form { public static int Number_Records; public static DataSet ds; public static DataTable dt; public static …

Hiya, Im looking to set up an events schedule, and i'm unsure where to start. Basically this will take a Startdate then insert a row in a table then a add 7 days to the inserted row date and insert another row etc until a specified date. I've looked at …