.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

How to show final SQL from parameterized SQLDataSource before sent to SQL server?

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :ASP.Net
 

I have a SQLDataSource that I'm having a little trouble with. I am using a parameterized FilterExpression and am not getting something right. So, I want to see what the final SELECT output will be that the SQLDataSource is generating and will be sending to the database so I can see what the SQL looks like. How do I do this?

 

Added:
Here is my code so far:

DetailSource.SelectCommand = "SELECT * from Pictures ";
DetailSource.FilterExpression="ParID = '{0}' AND CardNum = '{1}' AND SeqNum = '{2}'";

DetailSource.FilterParameters.Clear();
DetailSource.FilterParameters.Add("ParID", GridView1.SelectedRow.Cells[1].Text);
DetailSource.FilterParameters.Add("CardNum", GridView1.SelectedRow.Cells[2].Text);
DetailSource.FilterParameters.Add("SeqNum", GridView1.SelectedRow.Cells[3].Text);

Response.Write(DetailSource.ToString()); 

 

Thanks! 




View Complete Post


More Related Resource Links

How to do a parameterized bulk insert into SQL Server 2008 R2 from C# (.NET 4.0)

  
Hi, I'm trying to execute a BULK INSERT with a parameterized SqlCommand from a C# .NET 4.0 project. This is the code: private System.Data.SqlClient.SqlCommand sqlCmd2; private string sqlCmd2String = "BULK INSERT ExchangeTrackingLogs.dbo.ParsedLogs FROM @name WITH (FIELDTERMINATOR=',', ROWTERMINATOR='\n', FIRSTROW=2)"; private System.Data.SqlClient.SqlParameter[] sqlCmd2Params = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar) }; (...) sqlCmd2Params[0].Value = source; sqlCmd2.Parameters.Clear(); sqlCmd2.Parameters.AddRange(sqlCmd2Params); sqlCmd2.ExecuteNonQuery(); where source is a string containing the full path to a file, i.e. a value "C:\\TEMP\\MSGTRK20100701-1.LOG_EXHUB01". When I execute this code, I get an Exception with Message "Incorrect syntax near '@name'." In the database trace I see an RPC:Completed event with TextData equal to exec sp_executesql N'BULK INSERT ExchangeTrackingLogs.dbo.ParsedLogs FROM @name WITH (FIELDTERMINATOR='','', ROWTERMINATOR='' '', FIRSTROW=2)',N'@name varchar(36)',@name='C:\TEMP\MSGTRK20100701-1.LOG_EXHUB01' I tried using verbatim string literals, but doesn't seem to help. Any idea?

Can't connect my VWD express "sqldatasource" control to a SQL Server Express Database

  
Good day Sirs,   As the title is saying, I cant seem to connect to my SQL Server Express Database using "sqldatasource" control in Visual Web Developer 2010 Express Steps Taken: clicked "configure data Source" option in the Sqldatasource then "New Connection..." Changed my Data source: to " Microsoft SQL Server Database File (SqlClient) Here comes the problem: 1. I am choosing a Database file name but a problem keeps on popping:     "ServerName This file is in use: Enter a new name or close the file that's open in another program" 2. Then I tried to choose a detached database file (mdf) and it was attached now another problem pops:    "ServerPath cannot be opened becuase it is version 661. This server supports 655 and earlier.   I am using windows Home Edition: does it contribute to my problem? My server and VWDE is in the same equipment(laptop)   Does anyone have an idea why is it like this? Thanks

select image , show image, crop image and then submit to server.

  
How do i do this using javascript, asp.net 3.5 and C# ?step 1) user selects the image using browse buttonstep 2) clicks on upload button -- when user clicks on upload button i have to show the image immediately before sending the image to server, because, 1) image size could be very large 2) image dimensions could be long where my application shud not accept.step 3) ask the user to select the region (like face) from the image, zoom in /zoom out step 4) click on submit button to send the selected region to the server and then save it on the server as image.I have seen couple of tools but are not useful to me.Is there any tool that follow these steps?I want to do the work @ client side,with which 1) i can reduce the amount of data transfer.2) user have the option of selecting the image and play around with it.any help would be highly appreciated.thankssuman

SQL Server Money datatype pushed to SqlDataSource

  

I have a table in my SQL Server db with fields of money datatype.  It seems as though SQL Server likes to have 4 decimal places for the money datatype, but is there any way in the settings of this table or that money field to change this to 2?  I know how to programmitically trim the last two zeros, just wondering if I can manually set something so I don't have to do this every time I retrieve the money datatypes from the database table.

Thanks in advance! :)


Modal Popup Extender server side Show() does not work

  

Hello. Im using a modal popup extender to tell my user that the page has successfully been updated and then redirect them to a new page with the ok button. The thing is that i do NOT want this extender to fire when i press the button. I would rather call the Show() function myself. Right now i have a simple test page with a button that calls the popup extender Show() function but Nothing happens. If i set the targetID to the button it works but Im not able to call it through codebehind.

Any thoughts?

<%@ Page Title="" Language="C#" MasterPageFile="Master.master"

dont show JS hidden row after server event fired

  

Hi all,

i designed a gridview named outergrid and within that GV i designed a innerGrid, when the user click on expand button from the outergrid then the inner grid have to show. Now im doing some row filter works using JS, let us assume i have 5 rows in outergrid after filtered first 2 rows will be hiden so now 3 rows displaying, when user clicks on the expand button then im calling RowCommand Event of outergrid now the child grid has populated but the problem is 2 hiden rows(on outergrid) are now visible, how to make these hiden rows not to show while populate innergrid.


C# Database created but does not show up in Server Management Studio unless I manually attach it.

  

I used C# Linq to Sql to create a database. I look on the hard drive and the database .mdf and .ldf files are there. I open Server Management Studio 2008, attach to SQL express and the database is not there unless I actually attach the database.

 

First, is this correct behavior?

Second, is it possible to create a Sql Express database that is automatically registered(?) in Management Studio? If so, please give pointer.

 

Thanks very much.

 

 


Miscrosoft SQL Server Analysis Service does not show conditions and calculated members

  

Hi,

I am using MS visual studio 2005 to modify a report. The reports has got some filters (conditions) and calculated fields but when I open the report, all it shows me blanks values in condition window screen (where it displays Dimension, hierarchy, Operator, Filter Expression, Parameter fields) and also it does not display any calculated fields in the calculated members widnow. 

I am using SP1. Do I need to re-install the software or am I misisng some tool to turn on.

Thanks in Advance

Naveed


Is there a way to show xHTML content in a SQL Server Reporting services?

  
Is there a way to show HTML content (in a table column) in a SQL Server Reporting services ?

How to show output of sqldatasource value?

  

Hi,

I am  trying to send the output value of a sqldatasource to a textbox.Is there a way I can grab the sqldatasource select value?

Here is my select command:

Dim com As SqlCommand = New SqlCommand("SELECT TOP (1) ProjectName FROM aspnet_starterkits_Projects ORDER BY ProjectName DESC")

Thanks!


SQL Server 2008 Management Studio - "Show policy health state for all nodes"

  
What does "Show policy health state for all nodes" option do in SQL Server 2008 under the Object Explorer?

Screen Shot


Selecting from SQL Server DB 2005 - with SqlDataSource C#

  

I just need to know how to select in c# select from my sql server database for the purpose of seeing if data already exists.. do not need to display the data (i know how to select the data and display it in a data grid) but I am checking to see if dates are already in the database before performing an insert since there can not be duplicate dates... it is late but I only can figure out how to use the data as it applies to viewing or if bound to a control...

Also I am not using the aspx... in tags... my c# is seperate... (am I not making sense? sorry super tired)

do I have to use a stored procedure just to see if the row exists??? any info greatly appreciated...  


Slow performance with SQL Server 2005 executing parameterized queries with LIKE and an aggregate com

  

We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause.  If we use a non-parametrized query (but keep the WHERE clause the same) the query performs much faster and, in fact, executes a different plan.  Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005.  Obviously, we'd like to use parametrized queries to prevent SQL injection but the slow perf is unacceptable.  We need the LIKE to support wildcard scenarios.  If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries.  We're wondering, however, is there another option that would give us the perf without sacrificing safety?  I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...

Mike Bouck


Slow performance with SQL Server 2005 executing parameterized queries with LIKE and an aggregate com

  

We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause.  If we use a non-parametrized query (but keep the WHERE clause the same) the query performs much faster and, in fact, executes a different plan.  Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005.  Obviously, we'd like to use parametrized queries to prevent SQL injection but the slow perf is unacceptable.  We need the LIKE to support wildcard scenarios.  If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries.  We're wondering, however, is there another option that would give us the perf without sacrificing safety?  I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...

Mike Bouck


Using Value from SqlDataSource to Show/Hide Element.

  

Hello -

I am new to ASP.NET so please forgive me for any ambiguity!

I am in the process of re-developing my website into ASP.NET from a product called LogiXML. My background is in front end design using XHTML, CSS and Javascript with a good understanding of SQL so this is a HUGE leap for me.
Taking guidance from the asp.net homepage I decided to go down the MVC route using VB.

So.

In one of my Views I have created an asp data source to count the number of scheduled meetings:

<asp:SqlDataSource

SQL Server Management studio - cannot show requested dialog NColIndex

  

 

Hi,

I've just bought a 64 bit system running Windows Server 2008 and SQL Server 2008.

 

I wa shaving trouble getting the backups to work so I thought I'd better attached a database so that there was something a bit more meaty to copy.

However when I try to attach a database file I get the message

 

SQL Server Management Studio

Cannot show requested Dialog

NColIndex

Actual value was -1 (Microsoft.SQLServer.GridControl)

 

I'm logged in to SQL as SA

 

Am I doing something wrong here?

 

Can anyone advise me what to try next?

 

Thanks

 

malcolm

 

 

 


SQL Server Linked Server -IBMDASQL SQL select statement does not show rows

  

Exec ('SELECT * FROM filename') at TST_IBMDASQL

The above SQL statement using Linked Server IBMDASQL, does not show rows it only show the following message:
(1 row(s) affected)

And then if I run the statement, Exec ('SELECT * FROM filename') at TST_IBMDASQL, twice quickly i get the above message then on the second
run i get the message:

OLE DB provider "IBMDASQL" for linked server "TST_IBMDASQL" returned message "SQL0519: Prepared statement S000001 in use.
Cause . . . . . : The application program has attempted to prepare statement S000001. This statement is the SELECT statement for cursor C000001 that is currently open. Recovery . . . : Change the statement name in the PREPARE statement or correct the logic of the application program so that it closes cursor C000001 before attempting the PREPARE statement again.".
Msg 7215, Level 17, State 1, Line 1
Could not execute statement on remote server 'TST_IBMDASQL'.



Its like the whole statement is running on the remote and not returning anything other than the message "(1 row(s) affected)"

This has been working great for years until I formatted the computed and reinstalled everything. Its also working fine on the laptop and at work
and i've compared all settings - all looks ok.

There mus
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend