9,022 Topics
Hello , i have desined a user control for menu item. One of those Parent Item has Child Item...however these child items need to b poplulated from the database( am usin sql server 2005 ) . How to do it ? plz do let me know... cya Rohan
Hi, In the registration form am abt to make, i want the system to generate the password for the user. The simple way to enter the data to the backend is : [code] SqlCommand cmd_insertuserDetail = new SqlCommand ("Insert into fwm_user (last_name, first_name, birth_date, address, city, postal_code, country, email, password, …
I hav to do a project on online examination using java and j2ee concepts. I donno from where and how to start. I donno which concepts to use. Am not confident with the concepts. But am sure I can learn and do.. plz someone guide me to do the project. …
Hackers managed to get root access to a large Internet Service Provider, reportedly via a zero day vulnerability over the weekend, and destroy data from 100,000 websites as a result. The UK-based ISP, VAServ, has [URL="http://www.theregister.co.uk/2009/06/08/webhost_attack/"]stated[/URL] that the attackers apparently exploited a vulnerability in virtualisation software called HyperTM in order …
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. …
Microsoft announced a new program the other day called [URL="http://www.microsoftstartupzone.com/BIZSPARK/Pages/At_a_Glance.aspx"] Microsoft BizSpark[/URL], where they give away a boat load of software and services to young startups and presumably lock them into Microsoft long-term. For a small start-up with little capital, this has to be a very attractive offer. Microsoft not …
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 …
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)
Here's I wrote some code to backup your database 1- Add references (Microsoft.SqlServer.Smo and Microsoft.SqlServer.ConnectionInfo) to your project. 2- Call method BackupDatabase which takes to arguments database name and backup file path with extension .bak (preferable)
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 …
aspnet_regsql is a tool user for installing membership, role and personalization tables to Sql Server. 1. Porting all tables to Sql Server 2. Porting only membership tables to Sql Server 3. Removing all membership and role tables 4. Removing Personalization tables. I am be posting a detailed blog on Membership …
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 …
class_db.php is a database class that provides methods to work with mysql, postgres, and mssql databases. Other database types can be easily added. The class provides a common interface to the various database types. A powerful feature of the class is the ability to cache datasets to disk using a …
Hello, I have simple ASP.net web form. With a simple click on a button i need to call a the Multithread process in order to execute my querry in SQL Server DB. I know that my querry willl take up to 45 min to be executed. While the process is …
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 …
How to Show Data record from Database in [B]ListView[/B] from [B]SQL Stored Procedure[/B]..I used google to get the info..but i didn't get it..
Of course i am a newbie in c# and not much experienced about programming, so this must be an easy thing but i just cannot find the solution. I've been working on a project in Visual.NET C# Express. I've built the main view first, then added database connections, then started …
Hi, please I need a query that performs the following: I have a table like this: set_id | rec_id 10 | 1 10 | 25 10 | 32 20 | 61 20 | 90 30 | 77 Now I have suppose rec_id = 61 and rec_id = 90 I need …
What I want to do is get a users current login username, and pass it to an SQL query which will search a table and return all entries belonging to that person. Ive managed to pass the username onto a label when that person logs in. [code] Protected Sub Page_Load(ByVal …
Hi friends, I am learning ASP.NET. I have designed a login form with username and password.The code i have given in Button click event is: SqlConnection con; SqlDataReader dr; int t; con = new SqlConnection("Persist Security Info=False;Uid=sa;Password=q1w2e3/;Initial Catalog=YOGADATA;Data Source=PC-1"); con.Open(); SqlCommand com = new SqlCommand("select * from Login", con); t …
I've only written one stored procedure in the past and I'm being tasked again to write another one. The purpose of this SP is to do a bulk insert from a .txt file and then to move the file to an "archive" when it's done with the bulk insert. The …
Hi all, I am novice in the c #. Having completed the Application contains SQL database. But when I run on another machine gives me an error message as follows: [url]http://img103.herosh.com/2009/09/02/819895428.jpg[/url] Please note that I have the installation of the .net framework, And the connection string I used is: SqlConnection …
Hi I have a program that i need it to be a portable prog i meant in destination system there isn't sql server and without it i need my program work successfully but this program used sql server they said me i have to change my database into SQLEXPRESS ,before …
Hello, I have an append query in my access, that is linked with sql server 2005. I want to use an append query that I maked in access, i want to use it in sql server so it can append the records to a specific table. My query is as …
Hello I'm having a problem to calculate the sum of digits from a field. Example: 1234 I want to sum 1+2+3+4, in order to obtain the result 10. Using the following query I obtain the result, but only by mere coincidence: SELECT model, CONVERT (NUMERIC(6,0), SUBSTRING(model,1,1)*1.0+SUBSTRING(model,2,1)*1.0+SUBSTRING(model,3,1)*1.0+SUBSTRING(model,4,1)*1.0) FROM product The column …
As the title says, how can i convert a string value to a Microsoft.SqlServer.Managment.Smo.Datatype ??? :-/ Example of code that im looking for: [CODE] Using Microsoft.Sqlserver.Managment.Smo; public partial class 'FormName' { String datatype = "Nvarchar"; Microsoft.SqlServer.Managment.Smo.Datatype dt = datatype; }[/code]
I need the query which will fetch the data from DATE_TIME1 to DATE_TIME2 with interval of 2min or 3 min or 15 min which is variable. The DATE_TIME data is available in the table in the interval of 1 min. ex in the table: 29-Aug-2009 10:00:00 29-Aug-2009 10:01:00 29-Aug-2009 10:02:00 …
I am having a problem restoring my clients MSSQL database onto my desktop using Enterprise Manager. Apparently the database itself contains information about where the original database was backed up from & irrespective of what alterations I make in Enterprise Manager the restore fails. Is there some other program I …
I am writing a code in C# to read, add, delete and update a sql database row by row. Whenever I try to delete an entry, i get a "[COLOR="Red"]concurrency violation error: the DeleteCommand affected 0 of the expected 1 records.[/COLOR]". Please help me to solve that error and also …
Hi, I have a project in asp.net which includes mssql database. when i tried to back it up simply by copying the folder, I then tried to open the project through visual studio, but it did not open. So how can i back up my project ? also my operting …
Hi I have successfully installed SQL Express 2008 on SBS 2003 a few times now- all connection issues overcome! I am now in the situation where I want to migrate the Express 2008 database (4GB limit) on the SBS 2003 production server to a valid SQL 2008 standard SBS edition …
How to make a constraint to check if the entered time is in valid form?
Hello - I'm just looking for some feedback and some discussion from other DB pros about the viability of a DB design I came up with. The goal is to create the DB back end to an application feature that keeps track of company name history in the event of …
How to set the default value of an attribute to the value of another attribute in another table using Visual Database Tools?
hi i am making pos system i am using msflexgrid.. and i have make combo box visible when user clicks on grid... i have data combo which contains all supplier company name.... now my problem is that i want to load the combo box with relevant products as user selects …
hi all, i am trying to add check box to my datagrid view and update checked rows to sql server. please help me. i am using vs 2005 and sql 2000 thanks in advance.
Hi all, I've got my restore database code working good but was wondering if there is anyway to get some feedback from the SQL server during the restore? [CODE] Dim sqlstr As String sqlstr = "restore database " + dbNameFinal + " from disk ='" + tbBAKpath.Text + "' with …
hi all ive got more like a very newie with sql. thing is @college ill use sql7, wich i dont have it installed. ive searched for it on the net, but cant find it. i just find sp, but not just the program. does anyone know a link to download …
How do i update a database from dataset. [code]SqlDataAdapter.Update()[/code] is not working
Hi all, I am doing a project on creating send and receive sms application just like a software named Mozat M2U. I just want to know what are the different ways of sending and receiving sms. When I am doing my research, some of it uses sms gateway which is …
Hi I'm new to developping applications in VB.net I need help with a simple select statement. SQL statement: Select "LYC Code" from [General ledger Setup] I don't how to write that particular select statement in vb.net when there are spaces in the names of the table and field . Can …
I am installing sql server 2005 express as a pre-requisite along with my VB.net application setup. When I run-setup, set-up starts and after 2 or 3 minutes it gives error as follows : [COLOR="Red"]Component SQL Server 2005 Express Edition SP2 (x86) has failed to install with the following error message: …
hi 'm aparna. Am developing a web application with j2ee and SQL server 2005 EXPRESS EDITION as the back end. When i connect it with JDBC , my connection turns out to be successful. WHen i run the application, the web page is openin, but the problem is values are …
hi, how to save an image into database. ie how to insert an image into database and how to get the image back. i am using the asp.net(C#.net) and mssql server 2000 . so can u tell me the solution.
The End.