[microsoft:sql-server] Forum Topics

Hello, used tech: C# 4.0, sql-Server 2008 i have this stored proc: -- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block …

Hello programmers! I made two programms. One is for my marks in school and second is for library for my school. One man who work in the library in my school has error with this my software. Software can't load database anymore. When I start program I got error message: …

Hi, I have problem with my connection to the database generate from entity data model of Ado.Net Entity framework. I work in Console Application. My code looks like that: public static void Main(string[] args) { string connectionString = "Data Source=(localdb)\v11.0;Initial Catalog=BarDatabase;Integrated Security=True"; using(SqlConnection con = new SqlConnection(connectionString)) { string queryStatement …

hi In room table the roomtype and roomtypeid i created columns then the problem is that when i run the form and add data in database then in roomtypeID the show is double or single i want that in roomtypeID they show as 1 or 2 in roomtypeid column which …

hi all i update guestinfo all are update but the gender and martial status is not updated which is in comobox here is the button code private void button7_Click(object sender, EventArgs e) { guests myguest = new guests(); myguest.Guest_id = Convert.ToInt32(guest_id.Text); myguest.First_name = first_name.Text; myguest.Last_name = last_name.Text; myguest.Gender_status = Convert.ToString(gender_status.SelectedValue); …

private void getCount() { SqlCommand cmdCountPenalty = new SqlCommand("SELECT PenaltyID FROM Penalty", conOOC); SqlCommand cmdCountBill = new SqlCommand("SELECT BillID FROM Bill", conOOC); SqlCommand cmdCountPayment = new SqlCommand("SELECT PaymentID FROM Payment", conOOC); conOOC.Open(); SqlDataReader dtrCountPenalty = cmdCountPenalty.ExecuteReader(); while (dtrCountPenalty.Read()) { ++countPenalty; } dtrCountPenalty.Close(); SqlDataReader dtrCountBill = cmdCountBill.ExecuteReader(); while (dtrCountBill.Read()) { ++countBill; …

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Styl T10 1 1 Repair 1 2 Monitor 2 MPS 1 2 Repair 3 3 ImpSonic 2 I need to count how many printers, Monitors etc. are …

OK so I have two classes in the first class is where the database is handled, in the second class is where I want the output from my database select statment in be displayed on a label. How do I get the result to a label on Invoice.aspx? DBdatabase.cs public …

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

<The parameterized query '(@bid nvarchar(5),@rid nvarchar(4000),@total float,@duedate nvar' expects the parameter '@rid', which was not supplied. > The Error Was Occur when i doing this calling this function. private void setBill() { SqlCommand cmdBill = new SqlCommand("INSERT INTO Bill (BillID, RegistrationID, TotalFees, PaymentDueDate, Status) VALUES (@bid, @rid, @total, @duedate, @status)", …

hi all now guyz i add a info in datagrid view also displau now i hve some probelms that when i create a update fuction in guestinfo table then the guest_id is autogenerte then can i delete through guest_id or not and it is also not updated public void update() …

Consider this: I have a user-defined stored procedure which returns a bit value as OUTPUT. In my calling code I want to check that value. I define it in my code as follows: Dim retval As New SqlParameter() retval.ParameterName = "@return" retval.SqlDbType = SqlDbType.Bit retval.Direction = ParameterDirection.Output DataCommand.Parameters.Add(retval) DataCommand.ExecuteNonQuery() ' …

Hello daniweb community ! I'm finishing my second year of IT studies and the university is giving us the opportunity to engage in a project with a company. I found a good company but now i'm looking for a good project to work on. I was thinking doing something in …

hey guys, i created payroll system for my thesis project, i want to generate three reports using crystal report from visual studio 2008, but when i try to create connection using > OLE DB (ADO) > Microsoft OLE DB Provider for SQL server > Server = "Servername" > it has …

Hi all, I have to develop Library Management System using Java and MSSQL and I/m currntley in designning phase. Now my prblem is this, When user add to New Book to the DB, it stores with a qnuiqe Bookid which is going to be auto generated. But if there are …

Good day, I created a simple search in sql. inside the textchange event. everythis seem to be ok for text box. i want to have another search with the other text but this time i want to use the first search and concat it with the next condition.. here is …

i have an ajax Calender extender along with textbox in gridview, it works fine, when i select some date from calendar then it tranfers date to textbox and after clicking Update button in gridview , it sends date to database , Fine but when i don't select any thing from …

{ conOOC.Open(); SqlCommand cmdDisplay = new SqlCommand("SELECT * FROM [Course] WHERE ([CourseID] = @id)", conOOC); cmdDisplay.Parameters.AddWithValue("@id", ddlCourseList.SelectedValue); SqlDataReader dtrDisplay = cmdDisplay.ExecuteReader(); while (dtrDisplay.Read()) { GridView1.DataSource = dtrDisplay; GridView1.DataBind(); } this one is depends on user select which items on the dropdownlist, once they have selected should display the gridview, but …

Hello Everyone... Can someone tell me what am not doing right here? Because am trying to insert a record into a database through a VB.net 2012 windows form into a MSsql satabase. Problems: When I write the codes without the insert statement, it will work well and open the connection. …

i have tblScrutiny , COLUMNS: teamid name userid now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ?

Hi, I have 3 tables Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are in Item and …

i am making a project in vb.net 2010 with SQLEXPRESS as back end. i tried to run on my college computer but i think i may to again make full database on the college pc and then run..? is there any solution so that i dont have to make the …

good day, i have a table named information i created a stored procedure that will search for thier name, "firstname","middlename" and "lastname" that 3 field is concatenated and named it fullname My problem is that i want to count the result of my query that count the total number of …

-->>Hello I hope all is well. -->>I'm trying to join or select some data from 5 tables by using the following join statement: SQL ="SELECT RegistrationTB.Christian_Name,RegistrationTB.Father_Name,RegistrationTB.Birth_Date," "BaptismTB.Date_Baptised,BaptismTB.Parish_Name,BaptismTB.Minister_Name," & _ "CommunionTB.Date_Communised,CommunionTB.Parish_Name," & _ "ConfirmationTB.LC_No,ConfirmationTB.Date_Confirmation,ConfirmationTB.Parish_Name,ConfirmationTB.Minister_Name," & _ "MarriageTB.LM_No,MarriageTB.Date_Married,MarriageTB.Parish_Name,MarriageTB.Mr_Name,MarriageTB.Mrs_Name,MarriageTB.Certificate_No,MarriageTB.Minister_Name " & _ "FROM RegistrationTB " & _ "INNER JOIN BaptismTB ON RegistrationTB.LB_No=BaptismTB.LB_No " …

Greetings, I'm developing an HRM application and such application including functionality like hiring decision, moving decision "for example, moving an employee from a department to another" etc. All such types of decisions done throgh the same Windows Form and each type of decision has a different data from the other …

Hi All, I have 44,000 data in a table (dbo.IA_Subscription) where I have only 2 columns; one is ID and another is Magazine_Type ID filed is filled with contact_ID and Magazine_Type is filled with 3 Magazine e.g. Papaer Type, Digital Type and Web Type. Now contact_ID is not unique...one contact_ID …

Hello everyone... I love the magic that programming does, that's why am here. Right here, I am using ..........Visual Studio (VB.net) 2012 ..........SQL Server 2012 I am actually creating a program to do two main functions.... 1). To Search for records from multiple MSsql tables and display the result in …

Hi, I am experiencing irritating error (undiscriptive rather), when I want to insert a single statement into my db. Following is the code: protected void Button1_Click(object sender, EventArgs e) { SqlConnection dataConnection = new SqlConnection(); dataConnection.ConnectionString =@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; SqlCommand dataCommand = new SqlCommand(); dataCommand.CommandText=("INSERT INTO citylist(city_id,city_name,latitude,longitude,state) VALUES ((1, …

i have here my search code. i want to search for firstname, and gender, but what if firstname is empty and gender is the one were going to search. but the gender is not filtering they just filter the name. any suggestions.. SELECT --ACCOUNT_CODE --HOSPITAL_CODE MRN ,CONVERT(DATE,BIRTHDATE)BIRTHDATE ,FIRSTNAME ,MIDDLENAME ,LASTNAME …

Hello dear T-SQL community, I am working on some exciting project but my problem is not exciting and I have not been able to find a valid solution... (all related fix are arround BCP or BULK INSERT). The server where the DB is located is not allowing BCP / Bulk …

Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this …

hi all i make a store procdeure in visual studio wpf when i run a code the error is not solve here is error "Procedure getguestinfo has no parameters and arguments were supplied." and here is the code public class guests { private int guest_id; public int Guest_id { get …

Please everyone share a query for all as SQL Exercises 1. nested SQL statements

Can someone help me... I am new to vb.net with sql connection and I can't fix this error : variable name '@date' has already been declared. Variable names must be unique-- I need this to be fixed "ASAP" Im running out of time here because of the error here is …

I copied book1.xls into IISServer c:/inetpup/wwwroot objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/book1.xls") &";ReadOnly= true ; UID=admin;" Dim strSQL excelfilename = "Book1.xls" strSQL = "select * from " & excelfilename Dim objRS Set objRS = Server.CreateObject ("ADODB.RecordSet") objRS.Open strSQL, objConn,3,3 When I execute the page Error Type: Microsoft OLE DB …

I'm a bit of a SQL newbie so I'm wondering if you can help me. I've looked on Google it for some time, but maybe I'm not using the proper terms. Here is my question: I have TableA that has the following columns: ID(PK), location, departA, departB. I would like …

I want to perform an UPDATE query but i'm getting this error:  This is my Sub in vb.net: Public Sub changeStatus() Dim Sqlstr As String Dim connectionString As String = "server=xxxx;uid=xxxx;pwd=xxxx;database=xxxx" Dim strtTime As String Dim endTime As String strtTime = DateTime.Today.ToString("yyyy/MM/dd") & " " & "06:15:00" endTime …

me and my frieds are going to be buillding a website which uses php,html,css,sql,jquery. over project will be really big and snice its more than one person. we cant work on 1 computer. also its going to be hard to keep trak of all files on every different computers. is …

Hi, I have my data which looks like '0/1,0/2,0/3,0/4' or '0/1,0/2,0/6,0/3,0/4' I need to select min and max of the numbers for example for first example my output should be 0/1-0/4 and for second it should be 0/1-0/6.. I am able to get like 0-1 or 0-6.. Any help would …

Hi, I am creating a Crystal Report application in c#. However when i run the form its asking me for a username and password. I am using Microsoft SQL Server 2008 and i am using Windows Authentication to connect to the server. Therefore there are no specified Usernames and Passwords …

There are 5 columns in my table structure and they are: 1) Id - PK 2) Name 3) IdentityNo1 4) IdentityNo2 5) PassportNo Since duplicate records are inserted into the table I am attempting to remove the duplicate records. What makes the records unique is the IdentityNo1, IdentityNo2 and Passport …

Hi All, I'm having a bit of an issue with a stored procedure I have written which encrypts a value using ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE. The problem is these functions return Varbinary data types which I need to append to a Varchar data type. Can anyone help with being able to …

I cannot work out how to get an integer value from a textbox from inside a datalist for a variable to insert into SQL. Here is my code. int qty = int.parse(dlProducts.Controls[0].FindControl("txtProductQty")); and this variable will be put into an insert Query. into a textbox inside a datalist id="dlProducts" <asp:TextBox …

I have test to get a job in banking anyone cloud give me something could help me ? the position is about doing some query on database the exam will foucs on SQL help in nested SQL statements like nested select ? whats tuning ? put result into new table …

i am getting nothing , i am trying to retrieve checkbox value and email address from gridview via code, I am succeeded in getting Checkbox value successfully but cannt get email address, even grid view has it, but i cant get, just blank, here is the code: .cs : protected …

At the minute I have code that allows the user to enter a reference number and it returns the record from the database matching that exact reference. But I would like it so that the user can enter only part of the reference and it will return all records that …

I have two tables major and student majorname is the foreign key of Student table Student primary key=Reg_No I want to delete entire student record from student i used the coding like this........... Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click myConnection = New SqlConnection(connectionstring) myConnection.Open() …

i filled a gridview with tblUser, now gridview has a checkbox file (status), which is used to activate newly registered users, so i want to inform user via mail when admins activates him, mean when i (admin) checks checkbox field true, in edit mode of girdview then at that moment …

am near to cry bcz solving this problem took my whole day , simply, i am trying to get status of checkbox from grid view, so i converted it into tempaltefield and in .cs code i used findcontrol property but still getting error: Object reference not set to an instance …

I used this code delete recods from table ............ in VBP is database name Sell-is a table name The DELETE statement conflicted with the REFERENCE constraint "FK_Sells_Product_Details". The conflict occurred in database "VBP", table "dbo.Sells", column 'P_Id'. The statement has been terminated. Dim check As Integer Dim cmdproduct As New …