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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Dynamics sql correct way to write it --> eu_securityrole LIKE ('+% Doc %+')'

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server
 

Hi,

How do you write properly for a string :

set @CRM_FilteredSystemUser = 'Select * from FilteredSystemUser where

businessunitidname = + Spain +

 and CRMAF_FilteredSystemUser.isdisabled = 0 

 and eu_reporthubname is not null

 and CRMAF_FilteredSystemUser.eu_securityrole LIKE ('+% Doc %+')'

 

eu_securityrole LIKE ('+% Doc %+')'       AND  businessunitidname = + Spain +

Sorry ... it works like that below... I just don't know the correct way to write it in dynamic sql

 

where businessunitidname = 'Spain'

 and CRMAF_FilteredSystemUser.isdisabled = 0 

 and eu_reporthubname is not null

 and CRMAF_FilteredSystemUser.eu_securityrole LIKE '%RAM%' 

View Complete Post


More Related Resource Links

Write Custom WebParts for SharePoint 2007

  
The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible

Serial Port Communication Read and Write using C#.net

  
In this simple article you will learn that how you can Open and read COM port data using System.IO.Ports Namespace.
Simply just create New Project of windows application in C#.

Import ServiceProcess APIs
C#:
---
using System.IO.Ports

VB
Imports System.IO.Ports

Write Parsing functions which parse port data according to attached device

Does this look correct for saving a file/ new record to a database

  

So thank you for all your help so far, So I think i got this right,
but would like for you all to look it over to see if there is any
areas I might run into trouble with:

//using asp.net mvc 2
the table (sql server 2005, using entities framework)
"Pattern_Media"
table fields
"Pattern_Media_GUID  uniqueid 
"Pattern_GUID  uniqueid
"Media varbinary(max)  
"height int
"Width int
"Media_Type String (50)


the form:
<h2> Add Media to this pattern</h2>
<% Html.EnableClientValidation(); %>
<% Html.BeginForm("AddMedia", "Pattern", new { id= Model.Pattern_Guid} , FormMethod.Post, new {enctype = "multipart/form-data"}); %>
   
    <%: Html.Label("height") %>
    <%: Html.TextBox("height") %>

    <%: Html.Label("width") %>
    <%: Html.TextBox("width") %>

    <%: Html.Label("Media") %>
    <input type="file" id="Media" name="Media" />
   
    <input type="submit" name=

How to write SQL Datasource programatically in VB

  

Can someone pls help me to rewrite this programatically!

 

<asp:SqlDataSource ID="DS" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                SelectCommand="SELECT * FROM [Products] WHERE ([ProductID] = @QSID)">
                <SelectParameters>
                    <asp:QueryStringParameter DefaultValue="" Name="QSID" QueryStringField="ID"
                        Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>

 

Thank You in advance!

 


How to write xml file?

  

Hi,
I am having a three text box. I want to write the fields given in text boxes to xml file and the xml file should be open as save dialog box for the user to download the xml file. I want without saving the xml file in the physical path of the server 
Any idea let me know?
Thanks
Sabarish

Hi,

I am having a three text box. I want to write the fields given in text boxes to xml file and the xml file should be open as save dialog box for the user to

How to write in .dbf file with c#

  

Hi all

can anybody help me to solve my problem : writing in .dbf  , as following is my code with this error :

[ ERROR [07002] [Microsoft][ODBC dBase Driver] Too few parameters. Expected 3 ]

 

SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=test;Integrated Security=True");
        SqlDataAdapter da = new SqlDataAdapter("select * from test", cn);
        DataSet ds = new DataSet();
        da.Fill(ds, "test");
      
        string odbccon = "Dsn=TEST.DBF;dbq=E:\\FOX;defaultdir=E:\\FOX;driverid=533;fil=dBase 5.0;maxbuffersize=2048;pagetimeout=5";

        OdbcConnection connection = new OdbcConnection(odbccon);
        connection.Open();
        OdbcCommand createCommand = connection.CreateCommand();
      

     
        createCommand.CommandText = "CREATE TABLE test (ID int, name varchar(50),last_name varchar(50))";
   &n

Willing to Write Urdu in my text box

  


 hi want to write urdu in text box of my application if anyone has the solution how to do this kindly let me know
 


Correct me with report.setDatabaseLogon and .setDataSource

  

Hi All,

I was getting a load report failed error on the server before (locally it was working fine). I tried everything one of the solutions that helped me partially was adding below lines to the code.

 ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");

When I add the above Line to Local Mechine it is working fine and returning data.(Records)

But When I publish this code to server I am getting a screen that has

Server Name : Filled

DataBaseName : EMPTY

UserName :Filled

Passsword:Filled

screen and I am unable to enter the databaseName.

Scenario 2:

ext.SetDataSource("DataBaseTest");

ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");

 When I add these 2 lines to local mechine all the crystal report with heading and date is coming up but the data from the sql server is not appearing. Actually this is loading the report correctly but unable to get the data from the data base. (Not displaying any records although it is supposed to display 100 Recs)

When I deploy it to the server it is acting the same way.Displaying the record with heading , date, page number etc, but no data

Do you know what should I do to

Crystal Report gives System.AccessViolationException: Attempted to read or write protected memory. T

  

when a crystal report for same id is opened again at same time or refreshed then it gives the

"System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."


Stack Trace is :-


Stack Trace:

[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]
CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetConnectionInfos(ConnectionInfos ConnectionInfos) +0
CrystalDecisions.CrystalReports.Engine.Table.ApplyLogOnInfo(TableLogOnInfo logonInfo) +362
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetTableLogon(Tables tables, String user, String password, String server, String database, Boolean ignoreCase) +258
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDatabaseLogon(String user, String password, String server, String database, Boolean ignoreCase) +204
CrystalDecisions.

{ End Bracket }: Engineers Who Write

  

Writing is good exercise for developers and software engineers. Richard Ward explains how writing can help you focus your thoughts and communicate more precisely.

Richard Ward

MSDN Magazine November 2008


Write On!: Create Web Apps You Can Draw On with Silverlight 2

  

We build a Silverlight 2.0 application using the InkPresenter to let users annotate a pre-defined collection of images, perform handwriting recognition, and save the annotations and recognized text into a server-side database.

Julia Lerman

MSDN Magazine August 2008


Mobile WCF: Write an IM App with the .NET Compact Framework

  

The .NET Compact Framework 3.5 provides a subset of Windows Communication Foundation (WCF) functionality that you can harness to communicate between Windows Mobile devices and desktop PCs. We'll show you how.

Andrew Arnott

MSDN Magazine Launch 2008


Share Code: Write Code Once For Both Mobile And Desktop Apps

  

If you're building .NET client apps already, target them to Windows Mobile using the same skills and toolsets.

Daniel Moth

MSDN Magazine July 2007


.NET Profiling: Write Profilers With Ease Using High-Level Wrapper Classes

  

Here Joachim H. Fröhlich and Reinhard Wolfinger show you how to get all the great functionality of the .NET Profiling API the easy way, with custom wrappers.

Joachim H. Fröhlich and Reinhard Wolfinger

MSDN Magazine April 2006


Wandering Code: Write Mobile Agents In .NET To Roam And Interact On Your Network

  

In artificial intelligence, an agent is a logical entity that has some level of autonomy within its environment or host. A mobile agent has the added capability that it can move between hosts. In this article Matt Neely brings mobile agents from the halls of academia to a dev shop near you.

Matt Neely

MSDN Magazine February 2006


Unit Testing Tips: Write Maintainable Unit Tests That Will Save You Time And Tears

  

Everybody's talking about unit testing and you want to get into the game too. But you don't want the tests to take up all your development time and energy. Fortunately Roy Osherove is here to dispel some testing myths and put you on the road to efficient unit testing.

Roy Osherove

MSDN Magazine January 2006


C++: Write Faster Code with the Modern Language Features of Visual C++ 2005

  

The next version of Visual C++ has a new syntax that is both elegant and powerful. It has new optimization technology that has improved the speed of Microsoft. It has new compilation modes that ensure Common Language Infrastructure compliance and verifiability for the .NET Framework, and it has new models for interop. In this article Stephen Toub explains these and other improvements to Visual C++.

Stephen Toub

MSDN Magazine May 2004


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