[microsoft:sql-server] Forum Topics

I’m having some trouble and can’t seem to find the solution. Hopefully someone here can help me out. I have two tables in a SQL Database and I’m trying to select some information from both tables where the column‘UniqueID’ has the same value. Here is the information I require from …

Hi, Here is the code. Set con1 = CreateObject("adodb.connection") Set rs3 = CreateObject("adodb.recordset") con1.Open "Provider=sqloledb;Data Source=xxx;Initial Catalog=yyy; User Id=sa; Password=@1234;" rs3.Open "select a.courseid,a.semester,a.period,c.Category,b.credit,a.gradecode,d.GradePoint from x a ,y b,z c,m d where a.rollno='" & pprollno & "' and a.semester<>'" & prsem & "' and a.period<>'" & pperiod & "' and a.categoryid=c.categoryid …

I have an issue with some new code that I am trying to thread, I am using the code below to start my thred [CODE] Dim t As Thread t = New Thread(AddressOf Me.Main) t.Start() Panel2.Visible = False [/CODE] in my me.main I have a counter using a var, if …

I have the following code that works fine, it opens and excel file and uploads it into SQL. these excel files can have over 120 thousand records. I would like to put a progress bar on the upload so the end user knows how long the upload will take. The …

I want to have an alternative way to increment my student no. the current way I'm doing to is in my database, mssql. there's a property called Identity Seed(201200001 - my studentid format) and Identity Increment (1 - no. of increments). The 2012-is the school year, while the 00001- is …

I have a program that I wrote that creates a database in SQL Server called States_02 as a sysadmin user. Later on I want to grant SELECT permissions to that database to another user, web I always get an error that it cannot find States_02 or I don't have permissions …

i already have sql database ,server,login,password,,,i have to check from visual studio windows form,,,,to check test connection

i have four computers connected to broadband ADSL router MS SQL Server is installed in all computers while i have done steps given here [url]http://support.microsoft.com/kb/914277[/url] it had worked on local networking some time ago but now its not accessing remotely. i m confused its just because of broadband ADSL. if …

Hi! I created a really simple CRUD app in C# using MS SQL as back end. I connected the DB using connection string and use dataset, and data adapter to pull data from the db Im searching for the simplest way of checking record if it exist in a table …

Hey guys, So, I have a CheckedListBox that will be used to choose what columns they want to select from a database. Is it at all possible to display it in the format of [Table Name].[Column Name]? So far I have this: [CODE]con.Open() theQuery.Connection = con theQuery.CommandText = strColumns theAdapter.SelectCommand …

Guys, When i run this sscript i got an error in Where clause? Where should be place this where clause? [CODE] SELECT p.ESN, p.ReturnDate,s.Receiptdate,e.Shipdate FROM USProductRecovery p with (nolock) OUTER APPLY((SELECT TOP 1 Receiptdate FROM ESNSalvReceipts s with (nolock) WHERE ESN = p.ESN AND Receiptdate > p.Returndate ORDER BY Receiptdate …

Hi, I want to get Indian Standard Time (IST) in Sql Server 2005. How can I achieve this? Note: SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET() this query works fine in Sql server 2008. Is there any option in Sql Server 2005? Thanks in Advance

Hey guys, So at my company there are two i.t. guys, me and another dude, but he does not have the time, nor brain to teach me a couple things for connecting to out sql database for my app so I have to go online. Im having real trouble as …

Hello everybody and thank you in advance for any suggestions and help I hope to receive. I have Mysql experience but now I am working on my first M$sql database project, and I am getting frustrated. I am using php and would like to export a query. It is quite …

Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto …

Hello, I would like to create a small procedure that fetches the names of the columns of a table and uses them as a variable name. Let me explain. TableA Ref, FullName, FirstName, Age, ... 1, Jones, Charles, 32 2, Bridge, Dom, 26 3, Goodtime, Jack, 46 ... And I …

How to convert MS access database to MS SQL express 2005?

hi, i have a project written in visual studio 2008. and i copied the folder to the network drive. and from another pc when i run the exe file of the application an error occurs because the connection string is different, how can i make the application which is in …

Guys , Im creating a small CRM and this is my first time !! and what i have done is i have done some coding in vb and linked it with sql server express in the back-end!!Im new to it and the database is created by me and the webpages …

Hello again! So now i can save the picture in the database, now i have to retrieve it. this is my code for the saving of the picture, [CODE]Dim ms As New MemoryStream() studentpic.Image.Save(ms, studentpic.Image.RawFormat) Dim arrImage() As Byte = ms.GetBuffer ms.Close() Dim strFilename As String = lblfilePath.Text.Substring(lblfilePath.Text.LastIndexOf("\")) Dim cnn …

Public Sub getconcom_name() ledcmbsrcitem.Items.Clear() Try obcon.cmd.CommandText = "select con_id,f_name + ' ' + m_name + ' ' + l_name as 'name' from contact where type='company'" obcon.con.Open() Dim dr As SqlDataReader dr = obcon.cmd.ExecuteReader Dim oDataSet As New DataSet() While (dr.Read) ' MsgBox(dr.Item(0)) ledcmbsrcitem.Items.Add(dr.Item(1)) End While Catch ex As Exception MsgBox(ex.Message) …

Hello everybody !!! I have a problem that. When I back up using "Microsoft.SqlServer.Management.Smo". It works perfect on my PC. But when I bring it to another PC. It doesn't work at all. Please give me some help!!! The file attach below [ATTACH]23303[/ATTACH] Thanks for your helping !!!

Hi All, I need some help in understanding something. I have an existing database and I make some changes in Sql Server Management Studio, how can I adapt those changes in the Visual Basic project. As an example if I change a table name in Sql Server Management Studio how …

HI, Am having a table named "test" in the server A -> running Sql Server 2000. [CODE] synchronized in server B (Insert,update and delete in the server A)[/CODE] Am having the same table named "test" in the server B -> running Sql Server 2005. I don't know, how to carry …

Hai Everyone In my asp.net application i am creating a user with user name and password, with these username and password i want to create a database user. Example: If i create a user in my application like username: sam password: abc then an account to be created for above …

Hi, I am very new to C#.I am trying to create a webform to save data in SQl server 2008 using c#.My problem is when i click on the save button, the code saves the 1st record every time instead of saving the new record.all my textboxes are showing the …

Hi, I am trying to add up the quantity of various items found in a table, that is controlled by a second/third joined table using the IN search criteria. However I am unable to work out getting the SUM of all the items. The tables are as below: [ICODE]Table One: …

Hi, My application is in VS2008 and coded in Vb.net. I have my database in Sql Server 2005.I have a Database table say Table1 in My Database named Test. Now i want to export the data in Table1 to a MS-Excel(.xls) file on the click of a button. An excel …

This is my code, but its taking time to save record in excel. In SQL Server table have 11201 rows and 80 columns. please suggest private void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; app.Visible = true; worksheet = …

Guyz i need changes in this stored procedure "between" or anything like ven i enter a start date and end date on as 26 dec twice i get error set @Result = (select COUNT(*) from Employee_Leave where Employee_Id = @Employee_Id and Leave_Date = @start_Date AND ) and does not duplicate …

I am trying to display the result from a query in to a table. I can do this pretty easily when doing queries from mysql, but cannot get it to work with mssql. Below is the code I used to actually make sure I could get the data (and it …

Hi friends, can you guys help me to find the best way to track information changes in sql server 2000, like a free utility. The problem is that i need to track every single table because i want to figure something out. we have an ERP System and there is …

i have two column in table select Col1 + ' ' + Col2 from test It gives output as Arun Kumar But i want output as Arun Kumar Can anyone help me out

Hi.. I am populating my gridview as follows:- protected void Button1_Click(object sender, EventArgs e) { string con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataAdapter sda = new SqlDataAdapter("Select * from DropDownFilter", con); sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } and then i have checkbox for every row now i want to delete the checked rows …

I want to connect mobile and server for my project help me the way to do that That is sending and receiving sms to server ..and storing it according to its field name im using asp.net (c#) and mssql

Hi, I need to use query to check if a person has made a purchase during the month of his / her birthday. If yes, I have to give the person 10% discount. So, I have my database as such (Some of the tables are omitted due to its relavancy): …

Hi Guys I want to crete the SQL Tigger.There is table called Fruits.In fruits table it contain ITEM_CODE,ITEM_NAME and PRICE.So there is application that used to insert the values into fruits table. So I want once ITEM_Name or ITEM_CODE is update then sql trigger execute and It insert the update …

I have suddenly deleted a sql server databse file from Sql server management studio. and recovered it using a data recovery software. but now unable to open this database. the error is "aaa.mdf is not a primary database file error 5171". i need urgent solution plz. help me to solve …

I'm a beginner to C# and going to develop a application using C# and SQL server 2005. one of my tables has a field named with DATE. data type is also 'datetime'. i can insert data to the database using my application properly. now i want to filter my data, …

what are the diffrences between CREATE INDEX [WITH IGNORE_DUPLICATE_KEY OFF] and CREATE UNIQUE INDEX it sounds the same! and if anyone knows when creating a plain INDEX just CREATE INDEX whether it creates a clustered or nonclustered index couldnt find an anshwer to that thanks in advance

Hello! I've got trivial problem and have no time to re-read manuals. I need to construct a function in SQL2005 which selects from DB and returns datatable. Something like this: [CODE] create function GetAllStudents() returns Table as begin ( select StudentID,StudentName,StudentFamilyName,Birthday,HisClass from Students ) return DataTable [/CODE] I need it …

hi frnds , i have a combobox containing countries name and their codes like INDIA:CNT001 then i have a textbox that store the code of country i.e CNT001(fetching from database) Now i want to match that code with the combobox code so that the combobox is set to that item …

Can anyone help me to display the data retrieved from SQL server in text area of html in C#

I am creating a small application using vb.net 2008 and sql server.I want to create a search form .When i click in the SearchToolStripButton in all forms the 'Search' form will be loaded with the data from the header table into a grid.How to write code for the following 1)When …

hi, is someone can give me a code example of insert data from datagrid to sql table? thank's, shay.

Hi all, I'm new to vb.net and Sql server... So it may be a newbie question, but i've searched many places and did't find the answer.. so, here i go: I've just installed sql server, and i want to databind some textboxes in a form... but i dont really know …

Hi, I got this problem in my program when trying to execute stor procedure and xml file.. below is my code and script : Please help. code: Public Overloads Function ExecuteNonQuery(ByVal connection As IDbConnection, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As IDbDataParameter) As Integer Try …

I've used SQL authentication and windows authentication in my connection strings to SQL server just fine. I've got a login form that the user has to put their username/password in and it verifies to AD to ensure that is who it is and then logs in. Currently it is set …

Hi, i want to write a query for employee's who's name start with "a" and end with "b". Thnks in advance :)

How can I get SQL Date and time into statusstrip with timeer control