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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

how can a query be executed in vs2010 ?

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :ASP.Net
I work on a project labregistrations for students in VS2010 using vb i have a table in my db called registration and i want to put values (data) in it through this query.How can this be executed? Any code help please?   sqlstr As String = "INSERT INTO REGISTRATION (AcademicSemId,AcademicYearId,LabId,StudentId,RegDate) VALUES (" & Session("AcademicSemId") & "," & Session("AcademicYearId") & "," & lab.LabID & "," & Session("StudentId") & "," & Now.Date.ToString

View Complete Post

More Related Resource Links

Find SQL Query when report is executed

Hi All, I am using SSRS 2008 R2 verison of reporting services. I have a report and the data source for this report is Oracle 10i, it takes around 2 mins to execute the report. I want to find out the query, which is sent by the reporting services to the Oracle. Is there a way to find it out. Please help me with this. Thanks Vineeshvineesh1701

How do find what query is being executed on specific session ID?



I have a SP which writes to a table all processes which are being executed when application decides to stop waiting for results of the query. It works very well but problem is that it does not dump all SPIDs but only some of them which are being executing for a long time. Common pattern that a lot of SPIDs will be blocked by single SPID which will not be part of the output which is being generated. How do I dump all SPIDs and what they are doing along with SP below?


 'blk object' = t1.resource_associated_entity_id,

 (SELECT SUBSTRING(text, t3.statement_start_offset/2 + 1,
 		(CASE WHEN t3.statement_end_offset = -1 
 			THEN LEN(CONVERT(nvarchar(

SQL code works elsewhere, not in VS2010 Query Builder

SELECT caseid, recid, trandate, description, amount, SUM(amount) AS billtotal
FROM billtran GROUP BY caseid

The above SQL executes and gives me what I want under PHP/MySQL, but it won't even execute under VS2010 Express. When I put the above SQL code in the Dataset Designer Query Builder, I get an error: "In aggregate and grouping expressions, the SELECT clause can contain only aggregate and grouping expressions. [ Select clause = ,recid ]"

I don't understand what the problem is. What is the thing I must know about SQL that is different under Microsoft?

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

VS2010 Professional .NET 4.0 Remote Debugging ASP Website Project


Trying to remote debug ASP website from VS2010 Pro to Windows Server 2003 machine.  Specifically, trying to debug a Web Service, but breakpoint says, "The breakpoint will not currently be hit. No symbols have been loaded for this document."  This happens for all compiled code though.  I have read this is due to missing PDB files and the work around is to manually copy them, as noted here.  Problem is, I cannot find any PDB files for my project, except referenced libraries, which I can remote debug.


  • web.config has <compilation debug="true">
  • Debugger is attached to wewp.exe process on remote server
  • Installed VS2010 remote debugger from DVD (as I can remote debug referenced libraries)

This is beyond frustrating.  I migrated my code from VS2008 .Net3.5 to VS2010 .Net4.0 to take advantage of the inherent multithreading framework.  Debugging works when using local host and was stable until deployment to test server.

Thanks in advance,


How can I be sure that my entire project is up-to-date and free of errors in VS2010?


Seems like a stupid question, but I will go to Build > Build Solution many many times and the build will succeed many many times, then I will put in a minor syntax error and the build will fail, BUT the build will not fail because of the minor syntax error; it will fail because of an unresolved type that I put in about twenty compiles ago. And then I will fix the minor syntax eror, and the compiler will still complain about the unresolved type. Here is my code:

<%@ Register TagPrefix="FTB" Namespace="FreeTextBoxControls" Assembly="FreeTextBox" %>
  <form runat="server">
  Hello World!!  

Pretty simple, really. I go to Buld > Build WebApplication1 and it runs OK. Now, if I put in a minor syntax error, such as substitute "forrrrrrrm" for "form" and then try to Build Solution, it complains not about the misspelled word, but about the FreeTextBox. And then if I correct the misspelled wird, it still complains about the FreeTextBox. Which leads me to believe that Building the Solution does not check absolutely 100% everything that needs to be checked. Is there a more thorough way of compiling a program that I need to use?

Where is SilverLight Toolkit in VS2010?


I read somewhere that MS has integrate SilverLight Toolkit into VS2010. Where is it? I can't find it under Toolbox.

sql query that don't run



I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??

Dim conn As SqlConnection
        Dim cmd As SqlCommand
        Dim cmdstring As String = "Update Corsi Set [Contenuto]='" & TxtText.Content & "' Where [ID]='" & Request.QueryString("Id").Replace("'", "") & "'"
        conn = New SqlConnection(SqlAnni.ConnectionString)
        cmd = New SqlCommand(cmdstring, conn)

Need help with a linq to sql query


I want to display some stats in a listview contril.  The table contains a record for every impression and for every click, and every record has a datetime field for the time and date of the impression of click.  I want to be able to display how many impressions and clicks there were in a given day and hour, something like below:

Date              Time                              Impressions    Clicks
8/20/2010                                               450              14            
                     Midnight -1:00am               150               5

How to send an email with information in query string


First I will say I googled (Binged to make Bill happy) for this but could not find anything, perhaps I am not stating what I need correctly;

I have a website that a customer creates orders (for a printing company) and after the order, I would like to email the customer a link to view the status of their order;

I need to send the CustomerID in the link so on the returning page if a CustomerID is detected in the querystring, I "auto login" the client and open the "Dashboard" for the order page for that customer.

Can anyone point me in the right direction as to how to send the link and how to parse the querystring to get the values from the link;

Thank you if you can point me in the right direction.

vs2010 web deployment project restarts w3svc even when restartwwwservice = false


We've updated some of our projects from VS2008 to VS2010.  When these projects are deployed the w3svc is restarted on the target machine, even when restartwwwservice = false in the vdproj file.


This was a problem in 2008 until SP1 (http://forums.asp.net/p/1300097/2534736.aspx).  Does this same problem exist in VS2010?


This is a major problem for us -  we need to be able to deploy projects without restarting IIS.


I've tried creating a new web deployment package and setting the restartWWWService field to false, but this still does a restart when it's installed.


Has anyone come across this problem in VS2010?

VS2010 WDP Optimization


We have moved our projects from VS2008 to VS2010(Ulitmate) but staying with .Net 3.5. In VS2008 we had a web deployment project that would compile the web project to a single dll and emit full debug information, adding the new web deployment project in VS 2010 to do the same the dll is produced along with the pdb but when a dev attempts to debug the variable comes back with "Cannot evaluate expression because the code of the current method is optmized".

In VS2008 we had a targets fix file which had the setting for the optimization but these don't appear to work under 10 (plus the targets file has grown).



MDX Query parameter from SSRS


I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )



Get ServerReport selected Parameter value to use in vb query


I'm using ReportViewer in Asp.net 2.0 to view a SSRS report. I need the value of the selected parameter to use in a vb query. The parameters are populated on the server and its a single selection. Doing searches I've come across  ReportViewer1.ServerReport.GetParameters() but I can't figure out if I can use this to determine which value the user has selected in the parameter dropdownlist. Any help would be appreciated.

Crystall Report error VS2010



i write a site and get this error, i using VS2010.

  • An error occurred during local report processing.
    • The definition of the report 'Modules\Report1.rdlc' is invalid.
      • An unexpected error occurred in Report Processing.
        • Could not load file or assembly 'Microsoft.ReportViewer.ProcessingObjectModel, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

i try run on my machine its all work fine, but when i complier and run it on Window server 2008 get this error.

I read http://forums.asp.net/p/1513402/3613239.aspx I install the ReportViewer.exe but still cannot find the Microsoft.ReportViewer.ProcessingObjectModel.dll, however I got find it Microsoft.ReportViewer.ProcessingObjectModel in C:\Windows\assembly and is not a dll file. any suggestion?



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