[microsoft:sql-server] Forum Topics

I get error while connecting to server .i have sql server 2008 r2. [B]can not connect to local A network related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not assible. verify that the instance name is correct and that …

I am using SQL2008. I want to generate log file of each and every transaction carried out on my table. How can i do this?

eu preciso de puchar somente um valor de uma tabela do sql, que eu estarei usando este valor para definir os usuários as roles, irá funcionar assim, o usuario loga, então é criada uma conexção no banco de dados e nesta conexão ele verifica em qual role este usuario esta …

Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall …

[COLOR="Green"]exception occur i my code is: Violation of PRIMARY KEY constraint 'PK__lib_book__1ADC427003317E3D'. Cannot insert duplicate key in object 'dbo.lib_book_details'. The statement has been terminated. [/COLOR] [CODE]SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(); da.UpdateCommand = new SqlCommand("Update Lib_book_details set book_tag_id=@book_tag_id,book_name=@book_name,book_author_name=@book_author_name where book_category_id=@book_category_id", cs); da.UpdateCommand.Parameters.Add("@book_tag_id", SqlDbType.Int).Value …

HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in …

following is my code [CODE] namespace Test1 { public partial class Form1 : Form { string emp_code = ""; public Form1() { InitializeComponent(); } private void Uploadbutton_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); filenametextBox.Text = openFileDialog1.FileName; }//Uploadbutton_Click private void save_to_DBbutton_Click(object sender, EventArgs e) { SqlTransaction transaction = null; SqlConnection connection_string = …

i have a private sub that reads 4 lines of data from a text file, and then uses whats read and stores them in varibles. see below [CODE] Dim FileName As String = configfileV Dim TextFromTheFile As String ' Whole text Dim Lines() As String ' File splitted to lines …

hey, i meed to do a school project in asp.net and i am relly bad, i need to connect database to a login (i use visual 2008 and sqlserver 2005), this is the start poin, pls help me whith this, thanks

hi guys i've stored images in sql server. how do i retrieve the images and displaying them on the same page that sends the request. i kinda figured how to retrieve the images using the [CODE]file.outpustream [/CODE]. just need to know o i display the image using an image tag.

In my application i have database connection but i dont know how to attach my database with application Front End : C#.Net Back End : SQL server 2005 I need to create a setup to run my application on another machine ....

How to retrive the images in datarepeater from sqldatabase

I am trying to connect to SQL SERVER 2008 from vb.net but failed with Error 40. If I try to connecton to server\sqlexpress, error 26 is raised. step by step guide or tip would be helpful.

I feel guilty about posting again but I need help again and I have tried other sources of help e.g google and asking someone who is familiar with vb.net but still can't find the solution to it. It must be another simple fix but I cant find any reference to …

[CODE] Private Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load loadprodin() End Sub Private Sub loadprodin() Dim i As Integer objCon = New SqlConnection(conStr) Try objCon.Open() obj = objCon.CreateCommand() str = "Select * from product ORDER BY p_code" obj.CommandText = str sda.SelectCommand = obj sda.Fill(ds, "product") dt …

I return 30 tables or so from sql in a stored procedure. In the stored procedure I select these tables via... [CODE]select * from myTable1 select * from myTable2 select * from myTable3[/CODE] etc. These tables lose their sql table name when returned in a dataset and have default names …

Hi, I want develop a web site which contain database driven report and chart etc. Database for I intent to use for my application is MSSQL 2005. Plz give me a step by step guide line to configure PHP,MSSQL and Xampp etc. I am using windows 7 ultimate and xampp-win32-1.7.4-VC6. …

If I want to make a file connect SQL by file C# which I don't use connect in web.config But I can't call 2 class because when file aspx and Cs they have call [CODE]public partial class _Default : System.Web.UI.Page[/CODE] Help me create file connect SQL in Cs use all …

[COLOR="Red"]Book_Return_form Book_tag_id=textbox1 Member_id=textbox2 Book_return_on=textbox3 Book_due_date=textbox4 Fine=textbox5[/COLOR] In this form when I put book-tag_id the rest items come automatically a/c to database and I hv done all till textbox4(book_due_date). Now problem is with fine(textbox5) Fine is calculated acc to membership_type,there are three types of membership silver,gold,platinum Fines are:silver=30,gold=20,platinum=30 so the calculated …

[B]Book_Return_form[/B] [COLOR="Red"]Book_tag_id=textbox1 Member_id=textbox2 Book_return_on=textbox3 Book_due_date=textbox4 Fine=textbox5[/COLOR] [COLOR="Green"][B]In this form when I put book-tag_id the rest items come automatically a/c to database and I hv done all till textbox4(book_due_date). Now problem is with fine(textbox5) Fine is calculated acc to membership_type,there are three types of membership silver,gold,platinum Fines are:silver=30,gold=20,platinum=30 so the calculated …

How to fill a combobox with a data stored in a table in sql server?.... Can we use stored procedure to do so? I tryed this code but it keeps giving an error message: "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll" What does that mean???? My code: Private …

i cant really understand this error. from what am doing, "SS3B" comes from textbox6. and here is the sql code to insert it to database. But it keeps giving the above error. Beside, i am not converting anything. [ICODE]cmd.Parameters.AddWithValue("@FormedClass", TextBox6.Text.Trim())[/ICODE] Please where is this error coming from? And what is …

HI, i have the following code and i am getting the error [CODE]private Reservation getReservationDetails() { Customer c = GetCustomerDetails(); ManagerCustomers mgrCustomer = new ManagerCustomers(); int customerID = mgrCustomer.SearchCustomerByIDCardNumber(c.IDCardNumber); DateTime reservationAdded = DateTime.Now; int numberOfPeople = Convert.ToInt32(nudNumberOfPeople.Value.ToString()); string dateOfEvent = dtpReservationDate.Value.ToLongDateString(); string timeOfEvent = dtpEventTime.Value.ToLongTimeString(); DateTime dateTimeOfEvent = Convert.ToDateTime(dateOfEvent + …

Hi..I have a table named tblTask and another one named tblDaily_Task_Schedule. the relationshipis such that a task can have many daily_tasks. the primary key of tblTask is Task and the primary key of tblDaily_Task_Schedule is Daily_Task and its foreign key is Task (from tblTask). Each subtask in the tblDaily_Task_Schedule has …

Hi all, I have this code for the password reset form, It is supposed to generate a new password and the encrypt it to update the database then send an email to the user the new password for the user to log in and change the password. This is because …

Hi everyone! i am trying to find the average from an arraylist conatining database values. My database table have 9 columns and has 168 rows. Now i need to find the average at an interval of 12. My database table has time as 1 column and 8 other columns with …

[B] m trying to make dll class but in m facing errors in it plzzz help me to resolve the...i really need help!!! my full code is:-[/B] [CODE]namespace selectfinedetails { public class TransactionService { SqlConnection cs; private void OpenConnection() { cs = new SqlConnection(); cs.ConnectionString = "Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True"; …

Hi, i'm working with a sql (2005) database and using visual studio 2010. I've created a system where one of the forms is a find/search form. A user can enter in for example, a customerID and once they click on "find/search" the customerID will be searched in the database and …

create function funAdd2(@a int, @b int, @c int output) returns int as begin declare @c = @a+@b return (@c) end

i am trying to get the picture string from the database and when it is a null it gives me this error. [COLOR="Red"]Unable to cast object of type 'System.DBNull' to type 'System.String [/COLOR] [B]This is my code[/B][CODE]public List<Item> GetAllItemFromMenuID(List<int> ListOfItemIDs) { conn.Open(); List<Item> listOfItems = new List<Item>(); try { foreach …

hi..im doing a C# windows form application in visual studio 2008 and for the database im using SQL EXPRESS 2005..i need to create a crystal report. my question is when i start creating a new crystal report, using wizard, i get 1 window where i have to choose Data: i …

i make a stored procedure create proc member_finedetails as select lib_member_details.member_id,lib_member_details.membershiptype_id,membership_desc,fine_per_day FROM lib_member_details INNER JOIN membership_details ON lib_member_details.membershiptype_id=membership_details.membershiptype_id now iwnt to work on it by making dll class...i m confused how to make class of it.plzzzzzzz help me to make dll class of this stored proc...

I'm returning over 30 tables in a sql stored procedure which come back in a dataset. I store this in session state and hold for 20 mins before refreshing. My problem is, I need to be able to search the dataset for a particular table by name. At the moment …

Hi all, I'm not the best with coding and was wondering if some one can help me out. The page is inserting information into a database but when i added an extra section to insert i get the error [CODE] Could not find stored procedure 'Insert_PublicationsA'. Description: An unhandled exception …

Hey, As you can see i have a function to retrieve the product description based on product code. For some reason this is refusing to return a value even though the value im entering into test is there in the table, i can see the value of the input enters …

i m working on a project and still now i m working with data adapter but now i have to work in dll.. [COLOR="Red"]tag_id=textbox member_id=textbox book_retun date=textbox due_date=textbox fine=textbox[/COLOR] as i put tag_id in text box all textbox get automatically filled... for fine it is related to membership_desc silver=10 gold=20 …

Hi Guys I recently installed the SQL Server 2008 R2 - Developer on the top of Windows Server R2 (Standard) on VM machine hosting by windows 7 64 bit.I Installed a default SQL Instance and I didn't get any error message during installation and everything goes fine but now when …

When i click button an I always get an Error that[COLOR="Red"]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes …

I have a SQL file that needs to be BCP exported to pipe delimited because of limitations on the recieving end. I have tried the following with no sucess; [BCP sql statement] + '.txt" -t"|", -c -T' [BCP sql statement] + '.txt" -t\|, -c -T' [BCP sql statement] + '.txt" …

Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall …

Hello...!!! help me if u can..Thanks in advance!!! [COLOR="Red"]database table=issue_details in which columns are issue_id is identity,book_tag_id,member_id,book_issue_on.due_date database table=return_details colums are return_id identity,issue_id,book_returned_on,fine_per_day database=membership_details columns are membership_id,membership_desc(gold,silver,platinum) [/COLOR] [COLOR="Green"]Now my return form is:book_tag_id=textbox1 member_id=textbox2 Issue_date=textbox3 returndate=textbox4 fine=textbox5 [/COLOR] [COLOR="Red"]textbox5:-fine membership_desc=silver,gold,platinum fine_per_day for silver=30 gold=20 platinum=10[/COLOR] now what code i will …

Hello...!!! help me if u can..Thanks in advance!!! [COLOR="Red"]database table=issue_details in which columns are issue_id is identity,book_tag_id,member_id,book_issue_on.due_date database table=return_details colums are return_id identity,issue_id,book_returned_on,fine_per_day database=membership_details columns are membership_id,membership_desc(gold,silver,platinum) [/COLOR] as u see in return databasetable return_id is identity but issue_id is int Now my return form is[COLOR="Green"]:book_tag_id=textbox1 member_id=textbox2 Issue_date=textbox3 returndate=textbox4 fine=textbox5[/COLOR] …

how to disply last enter data of a particular name like table name = abc contents in the table : 1.abc 2.pqr 3.abc 4.xyz now in visual studio i want to search last enter data of abc

Hi every one How are you my friends? I need your help I began to programming ruby for 2 weeks and now i want to work on ruby on rails and of course i need a good DBMS, so i decided to use a SQLServer for my work but with …

Hi again, I need an professional advise how to implement dropdownlist in very professional way. So, my code is: [CODE] <asp:DropDownList id="ddlStudents" runat="server" CssClass="textbox" OnSelectedIndexChanged="ddlStudents_SelectedIndexChanged" AutoPostBack="true" EnableViewState="true"> <asp:ListItem Value="0">Choose</asp:ListItem> </asp:DropDownList> [/CODE] The rest of data I get from SQL DB. Is it the right way to populate the default value …

Hi, I am using windows application in c#. In one form their is two Richtextbox i want to save these richtextbox value as encrypted format in sql server and again displayed by decrypting it. Can anybody help me... Thanks in advance

Hi Everyone, I have this problem. I am done with the coding, and I want to access it using a url. The program is working perfectly in my local computer, but when I try to go to IIS, add a new website, assign port, like what I did in my …

I have a program which which enables staff to sign in to the application by checking their username and password in the database, to verify their log in. I have added a field job description in the staff table, and would like to disable buttons on the main menu depending …

hello everyone help me in this code [COLOR="Green"]database table membership_details membership_id,membership_desc,fine_per day,membership_fees [/COLOR] [COLOR="Green"][COLOR="Red"]return table book return id identity,book_issue_id int,book_late_fine [/COLOR][/COLOR] issue table issue_id identity,book_tag_id [B][code]da.InsertCommand = new SqlCommand("Insert` into book_return_details Values(@issue_id,@book_returned_on,@late_fine)", cs); //da.InsertCommand.Parameters.Add("@book_issue_id", SqlDbType.Int).Value = ?????????????[/code][/B] what code i will insert in ???? so that issue id get saved …

Hey! So i just started reading through some Database tuts, because i needed it for a project that i am making. I am using the HomeandLearn tutorial. So i have a database called "AdressBook" and then this code. [CODE]Public Class Form1 Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As …