[microsoft:sql-server] Forum Topics

I have visual studio 2008 pro installed along with a sql server 2008 sql server 2005 mobile. I have installed service packs for the data base file wont open on my computer but it does on the school computers. I don't know what the school computers have on them. The …

I have to add a not null column in a table. I am using [code]IF NOT EXISTS(SELECT * FROM information_schema.columns WHERE column_name = 'xyz' AND table_name = 'abc') BEGIN ALTER TABLE abc WITH NOCHECK ADD xyz MONEY NOT NULL END[/code] It gives me error ALTER TABLE only allows columns to …

while sending request parameter to this stored procedure i need to insert an department _id ,fy_id, vertical_id , while inserting .Before that i set one temp int variable and then assign it to query And checking the condition of temp variable if temp variable is 0 then could not only …

Hi folks: I get the following error when I try to convert sql to access: Microsoft JET Database Engine missing (;) at end of sql statement. The first part works fine but I get the error running second part. Below is the complete coding in vb.net for data transfer. [code] …

hi how can i add data to a unbound datagridview in C#. i have columns with a combo box column and a check box column and a calender control column. how can i add data to these columns in a datagrid view in C# please help me thanx appriciate a …

[CODE]<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>" SelectCommand="SELECT AdCampaign.ID As [ID], AdCampaign.CampaignName FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)" DeleteCommand="DELETE FROM [AdCampaign] WHERE [ID] = @ID" > <SelectParameters> <asp:SessionParameter Name="EmailAddress" SessionField="EmailAddress" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="ID" Type="Int32" /> </DeleteParameters> </asp:SqlDataSource>[/CODE] In tge previous code. When …

I have been using ms sql 2005 for a while now. But recently one of my server has became too slow. I have not added neither changed anything on that server. It's a HP 380 G6 with 32GB ram and 2 processors 2.26ghz each. kindly help.

Dear all, I have a table that contains image data type and has more than 20,000 records. I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this …

Hi! I´m trying to have a datagrid with some data. It includes a subquery and does only work if I define the parameter. I don´t want that. I would like to group it. The query is: [CODE] SELECT count(*)*1.0/ (select count(*) from events_may_2010 where agent = '5013' and convert(varchar,call_date,112)= convert(varchar,GETDATE(),112) …

:( im new in vb.net i read some tutorial i still dont understand on how to retrieve data from sql server into datagrid. can someone teach me on how to set it. if got easy tutorial for me also can i have a button call "retrieve" and when i click …

Hi All, I am new to SQL and I want to know how I can run loops in SQL such that for every element in one table I want to extract all elements from another table. i.e. If we have Table-A and Table-B then for every element in column1 of …

Hi, I was wondering what is the "cleanest" way of combining two datasets by taking all the values from one data set and only the values from a second data set that have an index that does not appear in the first. Both data sets have the same columns. Even …

Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | …

I dunno if I'm posting in the correct forum but I need urgent help. I'm currently a student doing my final year project in school. I've been task to come up with a prototype/solution for a Single Sign On(SSO). I've been researching for about 3 weeks now but I can't …

hi guys, i have a trouble on my sms gateway project,, with ASP.net engine and sql server2005. i have massage like this "Cannot open database "db_sms" requested by the login. The login failed. Login failed for user 'USER-7DA292602D\user'." any body to help me?? thanks for replay...

Hi... I have two tables without primary keys and with a common field meterid... I can't add a primary key to any of these tables... Now i need to join both tables.. Can anyone write the query for this...plss... select * from table1,table2 where table1.meterid=table2.meterid; isn't working... The result of …

hi, is it possible to populate a sql server ce database from a rss feed using visual studio 2008? and if so could you show me an example? Many Thanks

Exception Error: [code] private void Form1_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=LINLINPC\\SQLEXPRESS;Initial Catalog=POS;Integrated Security=True"; conn.Open(); MessageBox.Show("Connection"); conn.Close(); } [/code] I got this error(The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.)

does anyone konw why is this code giving an error saying: There is already an open DataReader associated with this Command which must be closed first. the error is coming form the place where i have cold the line the code is below: C# Syntax [CODE] public String[] LoadUSEmp() { …

[code] Statement statement = connection.createStatement(); String frmdate = request.getParameter("date1"); String todate = request.getParameter("date2"); SimpleDateFormat df = new SimpleDateFormat("DD/MM/YYYY"); //Date frmdate = df.parse("strdate1"); //Date todate = df.parse("strdate2"); try { // java.util.Date date3 = df.parse(frmdate); // java.util.Date date4 = df.parse(todate); java.util.Date ufdate1 = df.parse(frmdate); java.util.Date utdate2 = df.parse(todate); java.sql.Date fs1 = new …

What is the problem with the following login code? [code] Dim conn As SqlCommand = New SqlCommand("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts;Integrated Security=True") conn.Prepare() Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("select", conn.Connection) command.Parameters(1).Value = txtusername.Text command.Parameters(2).Value = txtpass.Text Dim i As Integer = command.ExecuteNonQuery conn.BeginExecuteNonQuery() If Page.IsValid Then Response.Redirect("~/salesbill.aspx") Else Lblerror.Text = "Username …

I have been working on a form that reads records from a SQL database. I have the binding working in that it populates all of the fields with the correct data. But if I am viewing record 1 and record 2 changes while I'm looking at 1, then browse to …

Hi I would like to show the data in a hierarchical manner as: bluehills > hills > south where hills comes under bluehills and south under hills in a hierarchical manner. How this is possible how can i retrieve in this manner using procedure Please help Thanks in advance MS

Hi I've been trying to solve the following problem for a few days but everytime I get the error msg even when the entered value doesn't conflict with the statement. Plz I need an urgent help I have the following tables: [B]booking[/B] bookingId (PK) subjectId (FK) [B]Subject[/B] subjectId (PK) termId …

hey, i have a problem in adding data from MS SQL(mdf file) database to datagrid view: the code is below please can someone help me with this. C# Syntax [CODE] db.openConnection(); String query4 = @"Select TActionDes,TAssignedTo,TDueDate,TStatus,TDateComplete,TComment From TopicAction Where TopicNo = @topicNo and Phase = @phase"; SqlCommand command4 = new …

hey, i have written method to get the names of the employees from the database. how can i sort this to alphabetical order the code is below C# Syntax [CODE] public String[] FillComboBox() { int NoOfRows; String firstName; String lastName; db.openConnection(); DisplayLoginUserName(); String query = @"Select * From Employee;"; SqlCommand …

hi, how can i add data to a datagridview cell from a SQL client database file(mdf file) is the below code correct, it dosen't work , why is it??? C# Syntax[CODE] db.openConnection(); String query = @"Select FirstName from Emplooyee"; SqlCommand command = new SqlCommand(query,DB.getConnection()); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable …

hi.. im working with my thesis, can anyone help me to generate auto increment number. for example,when the form load for the first time it will appear transaction 1, and then next time i'll load the form it will be transaction 2, so on and so forth. i am using …

hi, i have a method that get the firstname and the lastname of an employee in the database and merge it together and then put it to an array and returns the array how can i return the array from the method. the code is below. C# Syntax [CODE]//This methods …

I have problem when saving data from gridview into SQL database. When i save the data, only certain data was saved. I want to save all the data. Data that was not saved is from the column where i display a drop down list while editing from the gridview. Another …

I have almost finished a site that I've been working on but have one last thing that I don't know where to add. I have a bulk insert sql query that I want to insert into the .vb code behind and have no idea where to put it. Basically, the …

I am a c# and MSSql Server beginner, one of the project that i created is the library system database, I used MSSql Server as my database and c# as my interface. I have no problem to run that application coz it runs smoothly and better without any error. One …

hello. i have a database with school names, their budgets and their expenses. i have to write trigger not allowing to increase expenses, but only to lower their value. if someone wants to increase it, there should be message. i know i have to remember somehow the old value and …

Hi, i've tried several times, but haven't succed in making this: Classroom2 Name: | Date: Oliver | 12-10-10 Homer | 12-10-10 [COLOR="red"]Peter | 11-11-10[/COLOR] Classroom1 Name: | Date: James | 20-10-10 Lars | 20-10-10 [COLOR="red"]John | 11-11-10[/COLOR] How do i make a SQL statement that ONLY selects the lastest dates …

hi, i am using VS standard 2008 and a sqlclient file, i want to get two fields from the database(same table) and merge it (as firstname lastname) and display in the datagridview combo column in the datagrid view, how can i do this, please can someone help me thanxx

hi, im trying to divide two fields in a database like this: crterm=bal/pi but im not sure how to write it in sql. any suggestions?

Ok, so I'm done with my "Code Break" and I'm back in "action". A couple months ago I completely dropped programming to pay attention to other things in my life. I was only on the forums a brief period of time anyway, so most people probably don't remember me at …

Hello Friends, I have a web application where data are stored in a SQL Server database by using an online form in the website. Now I want to have an offline application which will store data temporarily in DB (say MS Access) and later on the data will be converted …

Can anyone recommend a solution for getting labels and grid headers from a sql server 2008 database -- other than creating a table with all the column names and headers/captions and translating them. SQL Server 2008 tables don't have a caption column property which would be useful ... I am …

Dear Dani web user, Can anyone help me how to generate series of date that has start and end date and pick up the data along the way. I have used Stored Procedure below but its not working [CODE] -- CREATE TEMP TABLE declare @YTDbyMonth Table ( --Period nvarchar(100) DateStart …

Hello - We are trying to do a restore which is started manually (not an agent job) via rdp. I'm being told that the restore fails if the the rdp session shuts down. I don't think this would cause the restore to stop. I haven't seen the error logs yet, …

I'm getting schema info but not so far able to bind it into datagrid columns, see code below I can print out the column-name and description and want to bind those into data grid columns [code] Dim schemaTable = dbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, _ New Object() {Nothing, Nothing, "VolDataNew", Nothing}) For i = …

hi, i work on a widows application sql server ce database and i want to know how to add the rows of a datagridview to a datatable. thanks

i want to insert textbox's content into money column in sql.but i don't know how to do it. Please help me Thank u!

Hello friends! I'm writing a program that is connected to a mdf database and i need to query the database, but I have tried several ways to do it but without success :( ! This is my code: [CODE] string Query = null; SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User …

It gives the proper output when i run it 7 times. But it also gives the ColumnNotFound error at line 152 all 7 times. When i run it for the 8th time it gave an error of Incorrect syntax near 's' at line 133 which is "statement.executeUpdate(movieValue);" . When i …

Some of my tables have no key since auto-number won't ensure no duplicates are entered. Other tables have multiple fields as key because this is the only way to uniquely identify. Migration did not like certain tables or queries due to this, are keys required? Also my Forms and queries …

can somebody tell me how does data reader work in following list and what will the result of............if(dr.Read()).. [CODE] public List<clsproductprp> RetFind_rec(clsproductprp prp1) { SqlDataReader dr=null; List<clsproductprp> obj = new List<clsproductprp>(); SqlCommand discmd = new SqlCommand(); try { if (con.State == ConnectionState.Closed) { con.Open(); } discmd.CommandText = "spFindFromProduct"; discmd.CommandType = …

Hello, I'm using Windows 7 Ultimate 64bit, Visual Web Developer 2010 and Microsoft SQL 2008 Express SP1(local). SQL server is set to windows authentication, I'm on admins account but the problem is that I can't work with database. It keeps doing errors with connection etc. (I have to use VirtualBox …

Dear all, I'm stucked with my XML problem. I have these stored procedures to save XML data into server hard disk. [CODE]CREATE PROCEDURE dbo.sp_XML_Employee(@Database varchar(10), @FileName Varchar(2000)) AS DECLARE @bcpCommand varchar(4000) SET @bcpCommand = 'bcp "SELECT EmployeeID, EmployeeName FROM ' + @Database + '.dbo.MasterEmployee ORDER BY EmployeeID FOR XML RAW(''Employee''), …