[microsoft:sql-server] Forum Topics

Hi i am new to ms access databases, really struggling with my tables relationships my database has more than one many-to-many relationships, for example one instructor can have many classes, one class can have different instructors, one client could have different instuctors, one instructor could have many clients and all …

protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { sqlcon.Open(); sqlcmd = new SqlCommand("select * from category" , sqlcon); da = new SqlDataAdapter(sqlcmd); da.Fill(dt); if (dt.Rows.Count > 0) { TextBox4.Text = dt.Rows[0][7].ToString(); TextBox2.Text = dt.Rows[0][8].ToString(); TextBox3.Text = dt.Rows[0][9].ToString(); } sqlcon.Close(); } } protected void Button1_Click(object sender, EventArgs e) { …

Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …

Group, I'm not sure if this is a SQL Server issue or a Visual Basic issue. However during the runtime, I'm getting the following error message: String or binary data would be truncated. The statement has been terminated. I'm not sure why or where this is being caught. Searching this …

Hi, Not sure if I should post it here or in DB section. I am extending an application. This application generates a PDF file and stores it in a SQL Server Database table in a column of image datatype. My requirement is to read the data from this column and …

I am creating PDF's using ITextSharp and Stored procs. I have a stored proc in place that calulates the totals of two columns SELECT SUM (Time) AS TotalTime, SUM (Cost) AS TotalCost From dbo.Records WHERE CustNum = @p_CustNum When i run the stored proc it returns the two answers. However …

Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections …

i want to access (Add, Delete, Update) data through lan (local area network)using vb.net looking for the connection string to access the same. Saurav

**Hai all,** I am developing web application using Asp.net frontend and MS Sql is backend, and i don't know **how can i retrieve Bit(Data Type) value from my database**, i don't know this... please anyone help...

sql 2008 to vs 2010 add edit dele update save report serch filter codes help namn po..kelngan ko po sa project ko..tagal q na naghahanap sa net putol puyol nahahnap q..hard code mas ok..thanks

This is my SP code SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE SP_Get_Age @name varchar(20) AS BEGIN SET NOCOUNT ON; SELECT Age FROM PersonDetails WHERE Name1 = @name; END GO This is my C# code private void callSP(string name1)//name1 comes properly in button click event { using …

hello i have a app that careated by C# i want connect it with sockets to sql server 2008 database how can connect it?

Greetings everyone, Can someone help me please on this error, you can also point to me where the converstion of the data type happen. If Not ListView1.Items.Count = 0 Then Do Until iLoop = ListView1.Items.Count lvitem = ListView1.Items.Item(iLoop) With lvitem query3.Connection.Open() query3.CommandText = String.Format("INSERT INTO workout_title_tbl VALUES((Select customer_Id From registered_cust_tbl),@workout_Title,@customer_Workout,@workoutType,@workoutInstruct,@date_Created,@time_Created)") …

I Am relatively new to java database accessing.. I need to access an SQL Server database..basically i need to use it in Android but I am trying to create web service in java. can i have a sample code for it?? **Please Help**

hi, i have an application with several many forms including login and mdi forms... What i need to do is to store the loggedin users logs like which user open a particular form at what time,from which ip or system,what he/she INSERT,DELETE and UPDATE or any other kind of related …

The program can run , but after i insert the user detail and go to refresh the dataTable i get this error msg "This database cannot be imported " Imports System.Data Imports System.Data.SqlClient Public Class frmMain Dim con As SqlConnection Dim cmd As SqlCommand Dim adapter As SqlDataAdapter Private Sub …

Hello! I'm writing a python script that will import all the excel files in a folder and write them into a SQL Server table. The script runs if I just point it to a single excel file, but i'm stumped at setting up an iteration loop that will read through …

I want to build a voucher system. I am developing an application and want users to login from a database (preferable MS SQL). I want the DB to randomly create codes for users to top up their accounts. The codes will be unique in that they will be based on …

Hello, i want to develop a lan-based software (Enrollment System) using Microsoft Visual Basic 2008 and a Microsoft SQL Server. I am confused on the Microsoft SQL Server that im going to use, anyway, im just a newbie on programming :). Can you guys recommend a microsoft sql server that …

**I have a form Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="CSharp.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Upload Files To DataBase</title> </head> <body> <form id="form1" runat="server"> <div> <asp:FileUpload ID="FileUpload1" runat="server" /> <asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" /> <br /> <asp:Label ID="lblMessage" runat="server" …

While trying to connect to MSSQL Server 2012 using pymssql,I get the following error. My server name in Windows Authentication is SARATH,User Name is Sarath\SarathShanker and I did not set a password. >>> mssql_conn=pymssql.connect(host='SARATH',user='Sarath\SarathShanker',password='',database='matrix') Error: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "pymssql.pyx", line 556, …

hi, how to convert db table column datatype from varchar to binary(16) in sql server 2005? thanks

as title itself is saying what i am looking for over here. I formatted my pc and installed Sql server 2005. I detached db before formating the system and attached after formating. however after attaching i am getting Db in recovery/ readonly in object explorer. I tried to change properties …

Hi All, i have requirement like to Convert rows to columns in SQL server. i have retrieved data like below: MatchId SelectionName Odds 322 Home Win 1.33 322 Draw 5.00 322 Away Win 9.00 322 Under 2.5 2.40 322 Over 2.5 1.53 and want to convert like below: MatchId Home …

My Laptop Specs: **i3 2.40Ghz 2048MB RAM Sony VAIO E Series Intel(R) HD Graphics 4000 64-bit OS** I had tried installing **Microsoft SQL Server 2008** for about 3 times now on my laptop. I still can't install it. Please help me. What to do? I really need the software for …

hi I tried to generate ageing reports in php. But I could not get result and even error. it is my code. Pls help me connection.inc.php try { $hostname = "server"; //host $dbname = "database"; //db name $username = "user"; // username like 'sa' $pw = "password"; // password for …

I am trying to create a form that allows the user to search (Access database) for a record by last name or customer number. It can be a partial last name or customer number. The SQL statement and code are below. This is the same method used successfully for a …

Hi, I'm having trouble writing a stored procedure in MS SQL SERVER. I have a table with 3 columns - REFERENCE, ID and AMOUNT. What I'm trying to do is SUM the AMOUNT based on different ID's for each REFERENCE. So it would be something like SUM(TBL.AMOUNT) WHERE ID IN …

Need help! As you can see, I'm working with a crosstab report that will display the product's "Total Sales" or "Quantity Sold" on a particular year in a monthly basis. Now my problem is, I can't figure it out how I can display the monthly total sales or quantity sold …

Hi All, I'm a little stuck with one table's design. I have a table called tblConference_Board that will be updated approximately 3 to 4 times per year. The following is my table design: `CB_ID int (PK)` `CB_Mnemonic_ID int (FK)` `CB_Value decimal (18,10)` `CB_Year int` `CB_Quarter int` This table is loaded …

Hi All, I have a table that holds monthly data in it. I need to average that data into Quarterly and Annual data but I'm not sure how to go about that. For annual I tried something like: SELECT TOP (100) PERCENT b.vSeries_Type as [Description],b.vSeries_Number as [CANSIM], Year(a.IPI_Ref_Date)as [Year], avg(a.IPI_Value) …

hi i am new to sql i want to get some values from different tables and i have made my own logic like that "SELECT course_name, course_id FROM tbl_course WHERE course_id = (SELECT course_id FROM tbl_enrollment WHERE student_id = '" + lbl_StudentID.Text + "')" what could the correct sytax for …

i am trying to make this code work with no success. Can anyone help me? ` $to = $_POST["credits"]; $messaging = $_POST["message"]; $sub = $_POST["subject"]; @mysql_query("INSERT INTO `mp_creditmail` (`Id`, `message`, `subject`, `read`) ('select Id from oto_members ORDER BY RAND() Limit $to;', '$messaging', '$sub', no");` i am trying to insert several …

I have 2 parameters ID - txtID.text Name - txtName.text I would like to select (SQL): SELECT ID ,NAME FROM TABLE WHERE If ID is not null read in txtID If Name is not null read in txtName If ID is null read all in select statement If Name not …

please help me. i connected two system using a cross over cable, and was able to see the remote servers in both systems but i am experiencing a connection problem to the remote computer. how do i connect to the remote sql database server? and how do i replicate between …

Hello all, I was hoping You could help me with this. The code below is for the login screen in my project. the data is selected from UsersList (UserID,FirstName,LastName,UserDOB,UserUsername,UserPassword,UserAdmin) What way can I modify the "cmd" command to check if the value for UserAdmin is true and display a message …

Group, I've written a short stored procedure in SQL Server 2008 to create a new Order Number. The code looks like this: INSERT INTO ORDRNUMBERREC(OrderNo,UserId,CreateDate) SELECT MAX(OrderNo)+1,'system',GETDATE() FROM ORDRNUMBERREC WITH (TABLOCKX) In VB2010, I've written the following code to execute the stored procedure: con = New SqlConnection(sConnection) cmd = New …

Hi All, I sort of want to get a "best practices" perspective regarding numeric values. First, I'll give my scenario: In my SSIS package, a CSV file is used for data extraction. Once extracted, a staging table is loaded with all the values from the CSV. One column, called "IPI_Value" …

i want to upload the attendance of students i am able to upload a xlsx file and transfer its data to tbl_temp now i have two tables tbl_s_attendance EP_Number Attendance course_id class_id 105078 105076 105075 105077 105079 tbl_Temp EP_Number Attendance 105075 P 105076 P 105077 P 105078 A 105079 A …

Hi, Does anyone know how to pass table name as parameter in a cursor? ALTER PROCEDURE [dbo].[error_calculation] @tablename nvarchar(50) AS DECLARE @part_no nvarchar(50) --Current Year Cursor DECLARE db_cursorpartno CURSOR FOR select distinct part_no from @tablename ///This gives error OPEN db_cursorpartno FETCH FROM db_cursorpartno INTO @part_no

I have to make a database system that is purely on SQL Server. It's about a diagnostic lab. It should contain at least 40,000 distinct patient records. I have a table named "Patient" which contains an auto-generated ID, Name, DOB, Age and Phone number. Our teacher provided us with a …

Can I get data from two databases (in same database server) to a c# project. How to include two edmx files? Or is there another way? Thank you in advance

Hi all. I am using Microsoft Visual Web Developer C# and am working with a database. I am using 2 tables: CONTINENT table with fields: CONTINENT_CODE and CONTINENT_NAME The other table is COUNTRIES with fields: COUNTRY_CODE and COUNTRY_NAME The 1 dropdownlist is bound to the CONTINENT table and displays the …

Hi All, I'm working on filling a user variable called "EmailString" via a db connection with SSIS. I've created a script task to do this (the only way I can see how) and in it I have the following code: Public Sub Main() ' ' Add your code here ' …

Hi all. I have run into a problem with inserting values into table. I have 2 tables: PUBLISHER with fields: PUBLISHER_CODE (Primary Key) and PUBLISHER_NAME. BOOK table fields: PUBLISHER_CODE (Primary Key and Foreign key to PUBLISHER table) and TITLE. The user enters bookCode and publisherName into 2 textboxes Here is …

I want to uninstall Microsoft SQL Server 2008 R2. But i get this error message whenever i try doing that.... TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: The given key was not present in the dictionary.. ------------------------------ BUTTONS: OK ------------------------------ Can someone help …

I am using ms access 2010 to build a database and need to include a login within the form to link directly to various online database that have different logins.

Hi Group! I've created a stored SQL procedure that will need to be modified to lock the table, run the commands and then unlock the table. I need to do this because I want any other users/programs that will need access to "wait in line" until the procedure is finished. …

Hi Daniweb people I have a really stupid question, strangely it has been keeping me busy for several days now and i just cant help but to ask for help... ive searched the whole of the MSDN libraries but no code seems to work for this I am making an …

Greeting, Can somebody help me with this code i don't know what is the problem here Dim str As String = "SELECT DISTINCT FirstName,LastName FROM SessionMembers ORDER by FirstName, LastName asc" Dim cmdStr As New SqlCommand(str, con) Dim dtreader As SqlDataReader = cmdStr.ExecuteReader() While dtreader.Read stringCols.AddRange(New String() {dtreader(0).ToString}) stringCols2.AddRange(New String() …