SQL Server Reporting Services for SQL SERVER 2000 AND Visual Studio.NET 2005 .NET 2.0
Hi, Which version of SQl Server Reporting Services will work with SQL SERVER 2000 in pararrel with ASP.NET 2.0 (.NET 2.0 framework)? Thanks, Azam HighOnCodingWanna get high!
Hi, Okay I got the answer. Yes, we can use the SQL SERVER 2005 Reporting Services with SQL SERVER 2000. HighOnCodingWanna get high! ...Attach SQL DB to SQL Server 2005 using VB.Net
Is there any way to attach a SQL DB to SQL Server 2005 using VB.Net? If so can you also set security?
Can you rephrase your question? Attach SQL DB from which version of SQL server ? Look up books online for sp_attachdb and sp_detachdb.***********************Dinakar NethiLife is short. Enjoy it.***********************
I have a DB that was created in SQL Server 2005. I have a website that displays data from systems all over the world. Each system sends it's data to it's own DB. The customer can then go to a website and see the data at real time. What ...Sql Server Script File(.sql) Execution by Vb.net Code
I have a problem.
I m working on "light weight sql server" project.
and i want to execute .sql file through vb.net code with the help of sqldmo library and sqlns namespace.
but i donot know any method to directly execute the .sql file.
i am successfully making the full script of select database of sql server.
please help me....
You can use SQL-DMO object in your .net projects by referencing Sqldmo.dll file which is in C:\Program Files\Microsoft SQL Server\80\Tools\Binn folder is default installation parameters are used.
I...creating ssis packagte for sql server to sql serer using C#.net
Hi friendsdoes any one has code or urls which can help me to create the ssis pacakage which will transfer data from sql server to sql server databaseswith some manipulationsthanks so much Lad LaxmikantPune
You are probably in the wrong forum. This forum is for questions relating to ASP.NET Dynamic Data.
thanks,David...Storing Excel File in SQL DataBase Using .NET
Please any one tell me how to Store excel sheet in DataBase using our .NET
Thanks in ADVANCE
Try this article by Steve Orr:http://steveorr.net/articles/EasyUploads.aspxDarrell Norton, MVPDarrell Norton's BlogPlease mark this post as answered if it helped you!...How to store / retrieve PDF or Image Files in Sql Server
Here is sample code on how to store and retrieve image files using SQL Server. There are a couple things you need to know.
1. If storing PDF files and you wish to allow the end user to view them using the browser you must have them open adobe and click Edit>Preferences>options and uncheck open in browser. This will allow the application to start running and interpret the binary information. Failure to do this will result in a blank web page.
2. Using standard gif, jpeg and such will open directly in the browser no problems.
3. I suggest you store you file type in the dat...How to read Transaction Log files from SQL Server using .NET
Hi all,Is anyone of you knowing about how to read .ldf (Transaction Log) files from SQL Server using .NET.e.g, suppose i m having following Database structure:database : testtable : tbltestfield : fldtestNow, i m inserting new record in blank table of fldtest using front-end application and now i want to write this event of inserted record in file or eventlog..with all necessary details contained in Transaction Log files - like table name,time range,descriptions,field values etc.How to do that for specific to handle SQL Server events of Insert,Update,Delete? only.Awaiting for your...Writing Stored Procedure in .NET 1.1 and using in SQL Server 2005
I am working on an application in ASP.NET 1.1 and SQL Server 2005 as database.I wanted to use SQLCLR feature of SQL Server 2005. Is it possible that i write Stored Procedures in C# 1.1 and deploy on SQL Server 2005? as it is in case of C# 2.0.
Please refer some good tutorial for it.
Regards,Imran GhaniImran Abdul Ghani
SQL Server requires 2.0. The .net team made a number of changes to the memory manager and gc so .net could be hosted in SQL Server....How to insert Video Files into sql server and retrieve the them and play in aps.net page?
How to insert Video Files into sql server and retrieve the them and play in aps.net page? thank you guys
This is a pretty complicated question with a long answer. I think the first question is "Are you sure / why do you really want to store the files themselves in SQL Server?" The easiest and more common method is to just store the location of the file on the disk, then render the page and just write out the link (in one way or another) to the page....This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers".
Can I confirm it is because: the remote db is of SQL Server 2008?
There is a soln mentioned in http://forums.asp.net/t/1324047.aspx
Did anybody try this (installing 2008 express: http://www.microsoft.com/express/sql/download/)? I am just checking again, whether it will disturb my existing SQL Server installation, in any means...?
Though it is mentioned that it will g...A .NET Framework error occurred during execution of user-defined routine or aggregate -While creating a SQL SERVER 2005 Stored prodecure in VS.NET 2005
Running [dbo].[insertlogin] ( @log = hiten, @pas = hiten ).A .NET Framework error occurred during execution of user-defined routine or aggregate "insertlogin": System.Data.SqlClient.SqlException: Must declare the scalar variable "@Log".System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.Pro...Storing AES encrypted files in SQL Server and retrieving these files to decrypt them.
Hi folks,Ive been working on a little app that lets u choose a file from your PC and encrypts it using AES encryption(Rijndael). The encrypted bytes are stored in Sql Server. I wanted to be able to retrieve the encrypted bytes so I can decrypt them. The process works fine. However when i open the decrypted file I have a ton of gibberish looking characters appended file but the decrypted text is fine. Can my goals even be achieved with this method? I have heard there are issues with doing this due to how SQLServer stores binary and padding issues with AES. Here is the code. &...Converting a gridView using an Sql Datasource to a gridview who is not using an SQL DataSource
How can i rewrite this page so that i doesnt make use of an SqlDataSource?
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="LoginHistory.ascx.cs" Inherits="Private_UserControls_WebUserControl" %>
<%--<link rel="stylesheet" href="BaldwinPortal.css" mce_href="BaldwinPortal.css" type="text/css" />--%>
<body style="margin:0 0 0 0;padding:0 0 0 0">
...How to transfer a GUID created using vb.net into a SQL database using a stored procedure
I am able to create a guid using:
Public Function GetGUID() As String
' Returns a new GUID
however when I try to add this to a parameter using the following:
Me.cmdSpAddOptions.Parameters("@QuoteDetailID").Value = GetGUID()
I get an error, I have also tried this:
Dim uidQuoteDetail As String = GetGUID()
Dim myuid = New System.Guid(uidQuoteDetail)
Me.cmdSpAddOptions.Parameters("@QuoteDetailID").Value = myuid
but get the error "Object must implement IConvertible"
A...Using Sql Server with VB.net
I am trying to create an asp.net application that will delete an item from inventory when the itemid is entered into a textbox and a button is pushed I only wnat it to delete the item if the QOH is 0 and then return the corresponding item name, and return an error if the item is still in stock. Could anyone help me on the stored procedure. The only table involved is the inventory table.
"DELETE FROM <TableName> WHERE ItemID = @ID AND QOH=0"
if records affected > 0, woop woop. else, errormessage="Who you talkin' bout willis?";
like my psuedo-code?Ka...