[microsoft:sql-server] Forum Topics

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; namespace Discussion { public partial class Reg : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Submit_Click(object sender, EventArgs e) { string Sname = TextBox4.Text; string Username = txtUse.Text; string …

i want quantity * weight (both column's total) in the textbox in crystal report. the data should retrive from sql database and should display in crystal reports.

Hi, I have a problem with my project, regarging deletion of an element in an asp:ListView, which is connected to a SQL database using ODBC. I have succeeded adding and updating a row, but deleting does not work. When I try to delete nothing happens. I think the problem is …

can anyone,plz send m the code for retreiving & updating images onto the sql-server using vb.net...ASAP... regards, preetham......

I keep getting an error "not all code paths return a value." I've tried placing the return statement in several places to resolve the issue. Obviously I don't understand how to resolve this seemingly simple and common problem. Also I'm using a using statement for the datareader and a try …

Hi, So i have a table called Resource in SQL in MS ACCESS,which has a field called Resource_Type which has values Permanent and Contract, what i'm trying to do is get the count of the number of permanent and contract employees so as to display it's ratio. This is my …

I wanted some help with vb.net code to use the previous, next and continue button. The program reads a text file and displays the info in textboxes on the form. It will then insert a new record into the sql database. It then moves to the next line on the …

i was thinking of downloading some database software that would help me learn sql. so far i have only *read* sql , ie havent done any practical sort of thing. i made a post earlier in this forum , where i was told that sql server express will be a …

I have 2 tables that i have joined together to be able to evaluate the availabilty of rights to a user. the query is as below SELECT R.RIGHT_ID,RIGHT_NAME, RVIEW=CASE WHEN R.RIGHT_VIEW = 0 THEN NULL WHEN R.RIGHT_VIEW = 1 AND A.RIGHT_VIEW IS NULL THEN 0 ELSE A.RIGHT_VIEW END, RADD=CASE WHEN …

Good day, I am having troulbe with my computation here. i want to compute for the Custom_Haulage_In_Transit but when i exec my sp the value of the Custom_Haulage_In_Transit is 0. can anyone help me with this please.. here is my code SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant …

Hi All, I've tried the following to format my date in 'dd/mm/yyyy' instead of 'dd/mm/yyy hh:mm:ss' when importing data from csv to DataSet. CONVERT(VARCHAR(10), [dateColumnName], 103) AS [DD/MM/YYYY] and CONVERT(DATETIME, [dateColumnName], 101) AS [DD/MM/YYYY] Both give me the error: Undefined function 'CONVERT' in expression What would be the correct method …

Hello, I have a question and I thank everyone for helping me in advance. I am using Visual Studio 2010, ASP.NET and C#. I have a table in SQL server DB. Server page (news.aspx.cs) is collecting all the data from the table (`select * from news`). Using `container.Controls.Add(new LiteralControl(news.ToString()));` I …

I have approx 80 rpt files ,the client want to convert them in to ssrs, is there any free tool?client using mssql 2008R2

Hello everyone, I hope someone can explain something to me. Im a Junior Developer with very limited knowledge in VB.net, but I am self teaching. I will soon have projects to do whilst at work, and although my coding is pretty ok now, one thing eludes me, and I cant …

Hi to all, I want to install SQL SERVER 2008 on my XP 32-bit OS. After clicking on "New SQL Server stand-alone installation or add features to an existing " link unser installation tab, Setup Support Rules window shows success status of all rules except "Restart Computer". It neither directly …

I have an HTML page that makes a query to SQL database when clicking on button "OTSI". My problem is that after populating the table with the data, I cant sort it anymore. I am using a standard tablesorter library ([TableSorter](http://tablesorter.com/docs/)). Here is the page making the query: [page with …

I am generating time with a sql script $query = "select current_timestamp as time"; When my system time is in 24 hrs format it returns a 24 hr format time. but when it is 12 hrs format it returns a 12 hr format time. But I want my time to …

Group, I'm thinking I may want to use the Date data type in SQL Server. However I'm still very unclear how to read, write and compare using this kind of data type. I realize this has a time component which is of no importance right now (it will be later …

I'm using Sql Express in Eclipse here is the code import java.sql.*; public class Login { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub System.out.println("This is my new world"); //String url = "jdbc:sqlserver://\\SQLEXPRESS;databaseName=pay;integratedSecurity=true"; String url ="jdbc:sqlserver://SQLEXPRESS;databaseName=pay;integratedSecurity=true"; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch (ClassNotFoundException …

Hello everyone, I was wondering if anyone could tell me how to connect and query sql databases in c#. Thanks in advance

Group, I'm having an issue with SQL Server that has me baffled. I need help. When I originally loaded SQL Server 2008 Express and created my database, I called it "DataDesignSolutions". The tables were created through VB Studio 2010 Express. It's path was "C:\User\Don\Documents\DataDesignSolutions.mdf". I'm not sure how, but somewhere …

Please help me im new in making database i dont know what tables will i create and its content pls.. 1. Develop a database design for a Student Attendance Management System. Create an ER Diagram to illustrate the relationship between the entities in your database. Below are the suggested list …

I am new to VB. Currently i am doing a Stock manage program with VB and SQL 2008. When Receive new stock from Supplier,I put recive item in a winform with DataGrid view. some thing like this **Item Description Received Qty UnitPrice Total** 1001 Acer Laptop 10 455 4550 1005 …

How to know which version 1.Microsoft SQL Server 2008.(Express) 2.Microsoft SQL Server 2012.(Express) Both installed on my machine,am I running(using)?

Good day, I am having trouble with my condition, i dont know where should i put where in my query here is my code.. SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant ,Order_Quantity ,Held_by_Finance ,Rejected_OOS ,Rejected_Others ,ISNULL(Open_Order_Quantity,0) AS Open_Order_Quantity ,ISNULL(Order_Quantity_NKA,0)as Order_Quantity_NKA ,ISNULL(Order_Quantity_RKA,0) AS Order_Quantity_RKA ,ISNULL(Order_Quantity_Others,0) AS Order_Quantity_Others ,ISNULL(Stock,0) AS …

Hi, I would like to know how to find duplicate records based on exact match on some columns and slight difference on others... for example, I have a table with the following fields 1. Name nvarchar(50) 2. City nvarchar(50) 3. State nvarchar(50) 4. Age int(10) Now, I wish to search …

hi guys. i hve a database name event. i hve a studentaccount table and faculty account table. studentaccount table has id,vstudentname columns and faculty account has id,vfacultyname columns. i want to add both table ids to combobox. how can i acheive that. i hve successfully managed to do it for …

Okey pros i have a small question.assume that below sinario where i have a Two tables called Organizatioin and Organization_Members (One organization can have many members 1 to Meny) **Organizatioin** Organization_ID - PK Organization_Name Tel **Organization_Members** Member_ID - PK Organization_ID - FK First_Name Last_Name Tel I recently developed a system …

hi everyone i need some help. am using visual studio 2008 with sql server 2005. i have a table name "mca1sub1" nd its fields are "cStudentCode,vassignmentI,vassignmentII,Internal,Total". now in my project whenever a faculty adds a new student thn "cstudentcode" in table "mca1sub1" is automatically updated . i have left all …

Table name is Chatting. stored procedure name is chat. problem is i cn see confirmation msg tht the message has been sent but i cnt see that data into the table. what am i doing wrong. /*** table chatting USE [Event] GO /****** Object: Table [dbo].[Chatting] Script Date: 04/03/2013 23:53:29 …

I have this code Dim con = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio 2010\Projects\ESI_PF_Payroll_V1\ESI_PF_Payroll_V1\Pay.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True") con.Open() cmd.CommandText = "SELECT Firstname,Lastname FROM Employee where Firstname = @Firstname and Lastname = @Lastname" cmd.Parameters.Add(New SqlParameter("@Firstname", TextBox1.Text)) .Value = TextBox1.Text cmd.Parameters.Add(New SqlParameter("@Lastname", Lname_txt.Text)) .Value = Lname_txt.Text dr = cmd.ExecuteReader While dr.Read Label4.Text = dr(0) …

I recently had a strange thing happen in an ASP.Net application I wrote in VB. When each session starts, one of the first thing it does is create a record in a SQL table and captures its ID value, which is an identity field. Two sessions were started very close …

Hi Guys Im a newbie in vb.net and trying to insert data into students table and some related details to scores table. Point is, a student registered in a class(level) must offer subjects (courses) for that class. I insert a student in students table (see Cmd below). This is easy. …

I have sql database with table Images, in that table there are 2 Columns ID (identity), DisplayImage (image). Table has 2 rows for first row i have written insert into Image values(1,'Libraries\Pictures\Lotus.jpg') and 2nd row as INSERT INTO [dbo].[Image] ([Id],Images) SELECT 2, (select * FROM OPENROWSET(BULK 'C:\Users\Public\Pictures\Sample Pictures\Tulips.jpg', SINGLE_BLOB) AS …

Hi, I'm trying to update the user information from textbox when the user click view my account information in the main page it will take them to another page which will display their account information they will be able to change everything excpet for the username becouse it is primary …

Hi guys, let me get to the point: I want have a button that when clicked allows the user to browse to any folder in any location whether it is a flash or the c-drive. Depending on the location and folder selected the user must see all image files in …

i figured out the problem it is that Hash function generates different hash each time for same value i.e 12345 and thats why it doesn't match during login with the one that i submitted during signup. so is there any way to make the hash stable for same value e.g. …

Hi all, I have a database with a set of relations created in SQL Server express. Is it possible to view or recreate the sql statements that created the database? Thanks for your time. Ryan

Hi. I have taken over the maintenance and development of an application created using C# in Visual Studio 2010 that makes use of an edmx file to provide mapping to a database (Microsoft SQL Server Compact 4.0). The database itself holds only tables with columns but no data at the …

Hi All I am upgrading a SQL 7 database to SQL2008 R2 and just cannot undestand why 2008 has a problem with the code for this view (my experience with SQL 2008R2 is limited): SELECT dbo.tbl_orgbusinessunits.BusAreaCode, dbo.tbl_orgbusinessunits.Region, dbo.tbl_orgbusinessunits.CompanyCode, dbo.tbl_orgbusinessunits.BusAreaCode & ' ' & dbo.tbl_orgbusinessunits.BusinessAreaName AS Branch, dbo.tbl_orgcompanies.CompanyCode & ' ' …

Hello there, I recently faced problem with my website www.zomedia.in. I am using sql server 2005 and asp.net 4.0 with c#. My database tables are automatically filled with some unknown html css junk codes such as (</title><style>.apyk{position:absolute;clip:rect(438px,auto,auto,438px);}</style><div c) (check http://zomedia.in/ZomediaSongs/ZomediaMp3.aspx and you can see the gridview with junk data in …

I have a trigger on insert CREATE TRIGGER [dbo].[InsertNewCustomersAsGroupMembers] ON [CustomerBase].[dbo].[Cutomers] AFTER INSERT AS BEGIN SET NOCOUNT ON; -- Insert statements for trigger here DECLARE @inserterdCustomerID uniqueidentifier UPDATE [CustomerBase].[dbo].[GroupMembers] ?---? END GO I want to get the values of the inserted record at [CustomerBase].[dbo].[customers] into the trigger inorder to update …

Hi to all, I try to insert a values in SQLSERVER 2005,It shows "Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table 'designation' when IDENTITY_INSERT is set to OFF." BEGIN TRAN INSERT INTO DESIGNATION (ID,DESIGNATION) VALUES(17,'TEST') COMMIT Kindly Suggest How to Solve …

I have an entity named Country with fields: CountryID, CountryName where CountryID is a primary key. And i like to create a general stored procedure that does INSERT, UPDATE and DELETE operations. How can i do that?

My page have textbox , lable and one button when the user click the button it should display message if the user in the database "email has been sent" the message will show otherwiser it will show "email is not in the system" this is what I did , but …

Group, I'm stuggling to get values from an sql database table into several textboxes. I'm not getting an error, but I'm also not getting anything to show up in these textboxes. Can you offer some thoughts as to what I need to do to fix this? Private Sub btnUpdateOrder_Click(ByVal sender …

Group, I've got part of my code started to populate the DataGridView with the data I need to return. When testing it, I have this long pause and no returned data. I finally have to kill it via <Control><Alt><Delete>. I've tried reading through mulitple websites to find some information to …

Group, I've read through the tutorial regarding Listviews and SQL's (http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). Thanks for the article. It was very imformative. So I thought I might try this with the project I'm doing. I really like how these listview look and what they can do. But I realize I need to know …

i'm helping a friend and i'm almost done with the program what i can't figure out is i need to sort the number of votes from lowest to highest my database is just ms access and i'm trying to display the photos of the candidates who got the highest votes …

SELECT Facility.[Facility Name] FROM Facility LEFT OUTER JOIN Reservation on Facility.FacilityID = [Reservation].FacilityID AND [Check-in time] = '" & Integer.Parse(cboHour.Text) & "' AND [Check-in date] = '" & lstDate.SelectedItem.ToString & "' WHERE Reservation].ReservationID Is NULL AND Facility.[Facility Type] = '" & cboFacilityType.Text & "' I have this sql statement which …