6,934 Topics
 | |
| | I have installed visual studio 2008 I have installed sql server 2005 Now the problem is i want to make a application in which i enter the product id in text box and i shud get all other details such as cost quantity in cost textbox and quantity textbox respectively.. … |
| | Hi I have created a project using C# and SQL SERVER 2005. I want to deploy the project so that I can create .msi file. Can anyone help me with the steps I should follow to create the setup file? Also in which editor I should add then database and … |
| | Hi, recently i needed to query a table , however i was denied "Select " permissions (because permissions had not yet been exported as the db was). Should my application enable for administrator to grant permissions , if that error occurs OR should permission granting be done through MS SQL …  |
 | Hi In my Project I used to connect to sql server2000,which is not in local computer.I use visual studio 2005 to develop the windows application.Once I run the apllication it gave me error message ,below I mention the error meassage I got [COLOR="red"] A network-related or instance-specific error occurred while … |
| | I have been searching the web for this but cant find it anywhere, i want to search my mysql database with php but i want it to find records if just one of the search term word are met. eg. Search term from form = "one two three" My database … |
| | Please help me in getting maximum sales in their own region by sql query |
 | I'm so completely new at trying run a local SQL server that it's laughable to watch me try. Anyhow, I made the install to my laptop and it seemed to go okay with no errors or anything like that. When I look in the configuration manager it says that SQL … |
 | A reply on so many data and SQL questions, this attachment has 20 forms with all different connection samples and data related queries. This will put any beginner on the right track to successful coding in vb6. I have put together this sample from numerous others over the past few … |
| | how to import data from excel to sql server using vb.. Thanks |
| | Hi everyone, So I need to find out if a date entered is a Sunday. If it is, I gotta do something special with this data. I'm not sure if Datepart will help or how to use it effectively to extract if it's a Sunday or if it's 1st day … |
| | I'm trying to understand the sql connection a little better. I have some code that returns data via a stored procedure on the sql server. Here is the code to execute the procedure and put the data in a data grid: [code]Dim tblSteps As DataTable = New DataTable Dim cnPMSQL … |
| | [QUOTE]My following code is only retrives number month(1,2,3,4....12) and not month name(January,February,.....December). Can anyone help me to retrieves month name in sql query. Before that i had try using function datepart, Monthname and date_format but i still din get my answer.Thanks[/QUOTE] [CODE]con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\YS.mdb" con.Open() sql = … |
| | hi i made a login page and created some user. now i like to make a sql queries with that user name. suppose username joe so he enter joe as a user name then login page sent to another page where sql qeries will be execute for that user: joe … |
| | Hi this function is to add a Note to the database. Now I want to remove the Note when there is no text available in the Note. I am unable to delete the row from the database and so the next time when the page loads the Note reappears. Kindly … |
| | Hi there. Im new to asp programming. And I am doing a research project for my school. I'm create a website with MS SQL SERVER 2005 with ASP. But the problem is the right connection. I have searched the web almost 2 weeks but nothing happened. Here's what my code … |
| | Here's my SQL Statement: SELECT * FROM tblHeader WHERE Requestor='"&label1.text&"' Why doesn't it work? |
| | Hi there, I need help urgently! I need to add xml declaration and namespace as shown below: <?xml version="1.0" encoding="UTF-8" ?> xmlns="http://online.ogcbuyingsolutions.gov.uk/schemas/products" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://online.ogcbuyingsolutions.gov.uk/schemas/products products_1_17.xsd"> I have written the stored proc in SQL 2008 to generate an xml output using thefor xml explicit and that is all fine. The problem … |
 | According to a new report, published today by SANS, the overwhelming majority of all cyber-security risks can be laid at the door of just two areas: unpatched client-side software and vulnerable Internet facing web sites. The report was compiled by Rohit Dhamankar, Mike Dausin, Marc Eisenbarth and James King of … |
| | I created a table in mysql db. it has a column with auto increment value. i checked inserting data through mysql console putting jst ' ' to the place of the auto increment value in the query. it worked ok. but when i do it through my java application (using … |
| | Hi there, I'm trying to write a SQL query based on the following tables. [code=sql]create table purch ( integer user_id, * integer product_id, * integer item_count, date purch_date * ); create table product_categ ( integer product_id, * integer category_id )[/code] Could someone tell me how to find the lag between …  |
| | some body help me.I want to know how to put the dropdown list from database at my textbox cursor. full problem definition is like this. I want to create a Hint system for SQL which will give the structure of of Query. for example if user enters trigger he will … |
| | Can someone help and show me how to display using (VB.net) these two tables combined into one. I'm really struggling trying to figure this out after hours of work, I decided its time to ask for help! So in SQL Server 2005 I have the following tables... [B]Students[/B] PKId Cart_Id … |
 | :'( Hello everyone, i wrote an application that makes database backups and zips them. Can anyone please tell me what i need to do in order to get the apllication to work on IIS 6 windows server 2003 SQL 05 1. The application works fine on machines for both XP … |
| | i have the following Query , i built it in sql server 2008 query builder [code=sql](SELECT CourseNo FROM ppu_RegistrationInfoDetailes WHERE (StudentNo = @StudentNo) AND (SemesterNo = (SELECT TOP (1) SemesterNo FROM ppu_RegistrationInfo AS ppu_RegistrationInfo_1 WHERE (StudentNo = @StudentNo) ORDER BY AcademicYear DESC)) AND (AcademicYear = (SELECT TOP (1) AcademicYear FROM … |
| | hi every body. i have a stored procedure with a select statment that looped by a cursor . this is the code [CODE] DECLARE res cursor READ_ONLY for (SELECT DISTINCT GroupNo FROM ppu_MajorPlan WHERE (PlanYear =(SELECT majorPlanYear FROM ppu_Student WHERE (StudentNo = @StudentNo))) AND (MajorNo =(SELECT MajorNo FROM ppu_Student WHERE … |
| | Hello everyone. I am new here and would like to know what would be the best way to go about setting up a website account creation system that will also store there account into a mysql database but also add it to a game database witch is sql. Thanks |
| | Hi all getting this error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" [code] if($_POST['paypalsubmit']) { $upsql = "UPDATE orders SET status =2, payment_type =1 WHERE id =" . … |
| | Apologies for the vagueness of the title but I cannot see a way to sum this up in a title... I have a table storing the individual words of sentences. Think one column is for a sentence id, the other is for a word in that sentence. So there are … |
| | [QUOTE]I am facing the problem in select the item dates. This is because i only want the condition of month from table dates. So i think the data set i write it get the error. Any one can help me,Thanks.[/QUOTE] [CODE] con.Open() sql = "SELECT DISTINCT Month(dates) FROM summary WHERE … |
| | Hi all, Wondering if somebody can help me.. Bascially I have two tables bid table and proposal table. I'm trying to print to screen all the proposals made by a particular user! The problem is that only those proposals that have bids made on them are printing to screen. So … |
| | ANyone of you would please refer me preparation material for 1Z0-007 Introduction to Oracle9i: SQL exam?This is first step to be OCA certified. What I've found as of now is: [url]http://www.amazon.com/OCA-OCP-Introduction-Oracle9i-Study/dp/0782140629[/url] [url]http://www.amazon.com/Oracle-9i-Exam-Cram-1Z0-007/dp/0789732483[/url] Thank you in advance!  |
 | Hi all; i'm trying to connect my program to an SQL Server Express database... however i am just getting an error that simply states: "Login failed for user 'sa'." Within my code this appears on: objConnection.Open() my code so far is: [code] Imports System.Data.SqlClient Imports System.Data Private Sub Form1_Load(ByVal sender … |
| | i am using visual studio2008. the submit coding show temporay storage of data on form but it is not inserting into the data base. On the other hand sql server authentication show permanent submission.  |
| | Hi Friends, I am facing a very bad problem.I have added an SQL Database using VS 2005>>Add New Item>>Sql Database.The problem I am facing is not able to execute an INSERT or UPDATE.But the thing is that just after inserting and viewing the contents of the same table in the … |
| | Today is [URL="http://www.saferinternet.org"]Safer Internet Day[/URL] 2009, apparently. Every year since 2004, one day in February has been designated as Safer Internet Day in order to promote a safer and more responsible use of online technology and mobile phones. It is aimed primarily at children and young people across the world. … |
| | It has been a long time coming, but Microsoft has finally announced the release to manufacturing of SQL Server 2008. "Microsoft developed this release of SQL Server with the customer in mind," said Ted Kummert, corporate vice president of the Data and Storage Platform Division at Microsoft. "SQL Server 2008 … |
| | That, my friends, is the message being touted by the latest Security Threat report to emerge from [URL="http://www.sophos.com"]Sophos[/URL] which says that one web page was infected every five seconds (count them) during the first half of 2008. Last year it was only, and I feel bad enough saying only, one … |
| | [B]Gripe about Microsoft Sql Server Management Studio[/B] I just wasted a day because of sql 2005. I just updated (i know late) but can't believe how buggy it still is. I had set my 'set rowcount' option under to 100 hoping that it would limit the rows i was viewing … |
| | It’s that time of the year again, and the Microsoft Tech.Ed Developers Conference 2006 Europe has hit the beautiful city of Barcelona, capital city of Catalonia in Spain. Hot off the press news for today is the keynote speech by Eric Rudder, senior vice president of technical strategy with Microsoft. … |
| | According to Oxford, UK based database security specialists [URL="http://www.secerno.com/"]Secerno [/URL]databases are open to attack from growing insider threats that give employees carte blanche to access confidential data. Naturally, the company has a product to plug, a database assurance platform called Secerno.SQL, but to be honest I am more interested in … |
| | How much money does Microsoft need? As much as possible would appear to be the answer, considering that it has announced a $1.50 fee to download the Office 2007 Beta as from August 2nd. Claiming a requirement to cover server costs as a result of the 3 million people that … |
| | Good question, but the answer may not be as straightforward as the announcement this week by Microsoft, and the ongoing online media coverage, suggests. The impression given is that Microsoft is supporting the Open Document Format in Office 2007 by sponsoring an open source based translator. This will take documents … |
| | Reports of the death of PDF support within Office 2007 and Vista are not only presumptuous but wrong. Despite the high profile publicity given to a spat between Adobe and Microsoft over the ‘Save as PDF’ function seen in the [URL="http://www.microsoft.com/office/preview/beta/getthebeta.mspx?showIntro=n"]Office 2007 Beta[/URL], there is no doubting that users will … |
| | Most people have had experience of, or currently use Microsoft Office, either at work or home, but I would think most people would find it hard to spot the differences between Office 2000, XP, and 2003. Apart from updated aesthetics on the latter, not much has changed through the generations, … |
 | If you need to execute SQL Statements\Stored Procedures\UDFs which return\don't return results, Here I've developed this class to be used in Data Access Layer. |
| | Here's I wrote some code to create login on SQL Server. 1- Add references (Microsoft.SqlServer.Smo, Microsoft.SqlServer.SqlEnum and Microsoft.SqlServer.ConnectionInfo) to your project. 2- Call method CreateLogin which takes to some arguments (documented) |
| | This is a query aggregator that stacks up queries and parameters until you hit the hard limit of 2010 set by the SQL Server/Driver, or you call .RunQuery() Scott Knake [URL="http://www.apexsoftware.com"]Custom Software[/URL] Apex Software |
| | [B]Introduction[/B] .NET Remoting provides a rich and extensible framework for objects living in different AppDomains, in different processes, and in different machines to communicate with each other seamlessly. .NET Remoting offers a powerful yet simple programming model and runtime support for making these interactions transparent. In this article we will … |
| | This prog uses SQL Server's Master Databases xp_cmdshell stored procedure (Shell Commands) to send messages in a LAN.Make Sure the driver name is 'netsend' and it points to Master Database. Check and change the username and passwords in the Java Program also.Make sure you have sufficient priviledges to execute stored … |
 | Good Day All I have SQL 200 and a SQL 2008 in one Machine. At First there was SQL 2000 and i install SQL 2008. Now we have a ilog Application written in C++. am not sure what that developer uses to connect to the SQL. Now the Application can … |
The End.