[microsoft:sql-server] Forum Topics

Hi all, I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a …

hi, I'v built a c# application in visual studio 2010 premium with SQL server 2008 database using crystal reports. my project is not a web project. i want to install my application on another computer and i dont know what i need to do. my project has my computer connection …

hi all, I am working with vb.net 2010 SQL express 2008 and ReportViewer. I have created a form that a user can add, edit and delete data which is all stored in an SQL db. I am printing out reports for the user with ReportViewer. The issue I am encountering …

hi guys a)I'm working on this project in asp.net and sql server.I would like to host the site im my local iis server for testing purposes b4 i publish.when i import the site to iis it poses some 404 complaining about the web.config file. what i'm i not doing ryt. …

Hi All, Couldnt figure out to obtain the nearest date in query properly. find below the sample. Insert Fsample (ESN varchar(10), optn_type int, auditdate datetime) values('123',2,'2011-1-03') values('123',11,'2011-2-20') values('123',2,'2011-03-02') values('123',2,'2011-4-10') values('123',11,'2011-5-18') 2=shipdate 11=returndate result ESN|Shipdate|returndate 123|2011-01-03|2011-02-02 123|2011-02-20 123|2011-04-10|2011-05-18 Thank you in advance. Jonel

Hi I am developing an application that has two parts 1) client machine 2) server i.e. (internet web data). i want to access the table on the server (internet) how i can use the connection string. how i can connect to client to server can anybody help me.

I have created a subdomain mapped to a sub - directory of the website. The default page of the sub directory ([url]http://www.mydomain.com/foldername/default.asp[/url]) works fine, but [url]http://foldername.mydomain.com[/url] shows error Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified …

I am not sure I am under the write forum but here is my problem: I have a pretty simple program written that works just have a lot of repeated code and am not sure how to condense it in this situation. The program reads in table names from the …

hello all i have problem : [CODE] string sssql = "SELECT *FROM BooksCatalog WHERE BookID = '" + TB[2].Text + "'"; ds =DBC.Read(sssql); // class that read from sql foreach (DataRow row in ds.Tables[0].Rows) { row["BorrowState"] = "good"; // that not write that in my database here its the problem …

I am a final year computer science student and i was confronted with this topic: Design, development and implementation of an efficient Bandwidth management system. i code with Vb.net and microsoft SQL 2008 as my database engine. honestly i've not written such application before, so i need a guide how …

I am new to PHP and looking to create a reporting site. I have created simple page that will return me a data set from a Stored Procedure in SQL Server. I'm now looking to be able to create dashboards with graphs and interactive reports. Does anyone know of where …

hi everyone i need ur help here is the problem i want to insert this values into my table at the same time (Member_ID,Interest_ID,Reference,date,interest_Recived ) at the end of every month then my code is look like this private void Icalculater() { decimal x = Convert.ToDecimal(i_RateComboBox.Text); DateTime t = Convert.ToDateTime(this.fmonthtextBox.Text); …

I have in sql database in table price ,path who leads to images on a Web Server, hava i show image in web page with sql query ?

Hi Guys, I am having few issues testing a software for which I have to develop a front end GUI. Basically, the previous person failed to document on how to run the system and left all the pleasure for me :D Anyhow, the system basically is a web crawler and …

I cannot figure out how to increase the @bin I tried a cast as int and still no success. Any ideas are greatly appreciated. [CODE]DECLARE @counter int DECLARE @bin varchar(9) SET @counter = 1 Set @bin = '65R110001' WHILE @counter <= 5 BEGIN insert into laitem (ViitemName,viitemdesc,vilastused,vidateadded,virevisiondate,active,entitycode,manufactureddate, stopid,statusid, itemtypeid) values …

Hi All, I have column which consist of data like AB1 AB2 AC3 AD5 AB1 AB2 When i do order by this coulumn, its not ordering properly. It should order like AB1 AB1 AB2 AB2 AC3 AD5 Thanks

Hi The error I stated in the title appears when I try to run the following code in Eclipse. I have created the Table which is named as "Emp" in Microsoft SQL Server. I can't find the error I have done here, and I googled but nothing helped me.. Plz …

Hi! im getting this error. I dont know why. PLZ can anyone help me. this is my code [CODE] public void getLastMemID() { String concString = "Data Source=BJ-PC\\SQLEXPRESS;Initial Catalog=new;Integrated Security=SSPI"; // int ID=0; try { CN = new SqlConnection(concString); CN.Open(); SqlCommand com = new SqlCommand("SELECT MAX(ImageId) FROM ImagesStore", CN); SqlDataReader …

Hello, Could someone help me with this question that I need to complete within 4 days? I have a problem with the insert statment on the code below. This code is working fine by inserting the ststement, but the problem is that the DATE is not being inserted into the …

Hi guys, I've recently developed a gridview with edit,delete and update panel..... All is working fine except the Update button.....the error shown is...... [CODE] [B]Object reference not set to an instance of an object.[/B] Source Error: Line 48: GridView1.EditIndex = -1; Line 49: conn.Open(); Line 50: SqlCommand cmd = new …

Hello everyone! Am trying to retrieve data from sql server based on two columns. Its a web application being developed using VS2010 (vb.net) but i keep getting the error: incorrect syntax near '=' Here's my code below: [CODE]Sub GetBasicMidwives() ' Set the SelectCommand properties... With objDataAdapter .SelectCommand = New SqlCommand() …

Is there a way I can set a user as System Admin via cmd? I have been searching the internet for ways to do this. i found this: [URL="http://support.microsoft.com/kb/937682"]http://support.microsoft.com/kb/937682[/URL] , but I would like to know if there is another way of doing it. Thanks, Andrew

Hi All, I downloaded the example with SQL db for filtering from the adres below [url]http://www.eggheadcafe.com/tutorials/aspnet/c67c4daa-83c2-4baa-aea4-2c8855527acb/aspnet-gridview-filtering-with-dropdownlist.aspx[/url] And when I tried to run it from VS2008, I got this error "The connection name 'NorthwindConnectionString' was not found in the applications configuration or the connection string is empty" I already downloaded msi …

[CODE] sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "update trainn set Adultno=Adultno-1 where ID=@pram1 and adult=@pram2 and Adultno>0"; sqlCmd.Parameters.AddWithValue("@pram1", textBox3.Text); sqlCmd.ExecuteNonQuery(); sqlCon.Close();[/CODE] The code is working properly when there is an update,but when it comes to more than one I don't know what to do? The following code …

friends i am new in vb.net -i have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc. what conn. String should i use to finish my proj? tnx for your concern.

Hi, I am a new in stored procedure and I now do the following function: [CODE] ALTER PROCEDURE dbo.ViewFaultyTbl @id int AS SET NOCOUNT ON; DECLARE @indicator int SELECT @indicator=Indicator FROM FautyScanTbl if @indicator=0 BEGIN SELECT * FROM FautyScanTbl WHERE ID=@id END ELSE BEGIN END [/CODE] Indicator is a column …

Hi experts, I am developing a Windows base application in Visual Studio 2005 C# as front end and SQL Express Edition [that comes with VS .NET 2005] as backend. I have a lan containing three PCS, one as Server and another two as Clients. I want to keep the database …

Hi Some background: I'm trying to create a Server/Client Sync scenario for my application using Sync Services for ADO.NET specifically the LocalCache custom tool which sets the whole thing up for me. My server DB has 5 Tables, all of which are being synchronized to the client application, which now …

Hello to everyone! I am an engineering student and we have this class wherein we use Microsoft Access. Our instructor gave as a hands on homework using the MS Access. As I do it at home and inputing numbers and etc all that I need to input, suddenly this [COLOR="Red"][B]ERROR[/B][/COLOR] …

hello everyone i try to explain my problem by this following example i have a gridview binded to a table with columns as(name,rollno,status, and last column of the gridview contains a checkbox) now the problem is i want when i check the checkbox of a particular row...then the status column …

Hi , I am new in core java. i have develop an application. in that i am used the combobox in combobox i am displaying roll no. of students from sqldatabase. now when i want to find rollno when keypress on combobox. ie. if i have enter 2 then display …

Hey guys, so im building this application using ASP.net (visual studio 2005) and i have few dropdown lists. the dropdown list has an arrow beside it. when u hover over it, it says "choose data source". i click on it but there seems like no option to connect to analysis …

I am working with application for Excel sheets in vb.net My database is Sql server 2005 I am having around 8 lakhs of rows in my database and 64 columns. when I import a excel sheet for searching the Duplicate of excel sheet rows in database i get this Error …

hi i have 100 records in my datatable .Here i want to insert these records into SQL without looping . thanks

I have uninstalled sql server 2005 but failed to uninstall SQl Server 2005 Management Studio Express. To install Sql Server 2008 Management Studio I need to uninstall Sql Server 2005 Studio otherwise I can't proceed further! Can anybody suggest an easy and clean way to uninstall SQl Server 2005 Management …

Hello everyone, Please am working on a project basically for storing personal data for some employees. I have a dropdownlistbox which gets its content from a table in SQL-Server. I also have a textbox which i want its text to be the same with the selectedted item of the dropdownlist …

how can i save the datagridewiev that i change it's information in the sqlserver

Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 …

I am getting this error when i try to connect to the server... Hot to rectify it... "This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

Still working to figure this stuff out :) My question is, is it possible to set a combination of columns with a unique constraint? For example: [CODE] ColumnA | ColumnB ----------------- Value1 | Value2 <- OK Value1 | Value1 <- OK Value2 | Value1 <- OK Value2 | Value2 <- …

if @fromDate = Datetime.MinValue BEGIN set @fromDate = (select MIN(applicant_statuss.created_on) from applicant_statuss) end if @toDate = Datetime.MinValue BEGIN set @toDate =GETDATE(); end the following error is Comeing : Msg 107, Level 16, State 2, Procedure sp_InterviewerPerformance, Line 21 The column prefix 'Datetime' does not match with a table name or …

Hi I am php coder and new to asp. I am trying to build a simple login page using asp and the db connection works fine. When the user submit the form and at the sql query section i am getting the following error "Microsoft OLE DB Provider for ODBC …

Hello Group, I'm running with MS XP Professional, version 2002, service pack 3. Many of you may well have already heard that there are some problems being encountered by some users with trying to install the update for SQL S/Pack 3. KB970892. As I do a lot of traveling with …

Hi Everyone, I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "[COLOR="Red"]ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The …

hi all, please help me on this... Is there a way to get the SQl View's String Command used to create said View? For Example, I have a View named tryView, now I want to get the string command used to create tryView like this one... [QUOTE] CREATE VIEW tryView …

There is some problem when i check username and validate it against password from my database.After checking password from request.getParamter() it should say "You have been successfully login"... Perhaps I am getting my own else block message"Incorrect Password..." which means there is some problem with the password thing. Here is …

Hi, im new to c#.When i execute the following code i get "vshost.exe has stopped working" message. Firstly i insert some data to a table in sql server 2008.then i want to retrieve the MAX(Mem_ID). My insertion is working properly. But when im trying to retrive MAX(Mem_ID). It gives above …

- I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help …

Hi Guys, I am using SQL Server 2008 R2 on Windows Server 2008 Standard Edition.I tried to uninstall one of instances in SQL Server and I believe I "Select all the features" to remove from the Select the features windows.After uninstalling, I tried to run SQL server with another existing …

hi Dears, i am very very new in programming and i have a problem with inserting something into table, this is when i connect it with database iam able to read everything in database, private OleDbConnection myCon; public Form1() { InitializeComponent(); myCon = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Aidi\Desktop\AccessDBase\WindowsFormsApplication1\WindowsFormsApplication1\Students.mdb"); } i have create …