DataSource Controls :: Code Behind Fail SQL String?

Mar 16, 2010

ive an access database with a table, in this table there is only one data column and one counter column (id, pet) i want to draw random a record. Reading on the web i came with this SQL solution: "SELECT TOP 1 tab_pets.pet FROM tab_pets ORDER BY Rnd(id)" and it works perfectly.

The problem is while using this statement in my code behind (in a class) as it draw always the same record, hence generates the same random each time. I though that the access Rnd() function would be handled by the access driver and not by my application, how can i resolve this?

View 4 Replies


Similar Messages:

DataSource Controls :: Incorrect String / Format The QueryBuilder String Correctly In Code?

Jul 7, 2010

I'm concatenating a string in codebehind to use in a sql select statement.

in aspx

<asp:Label ID="LabelHidden" runat="server" Visible="False"></asp:Label>
SelectCommand="SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)"
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_Employees" Name="ID"
PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="LabelHidden" Name="ActivityName"
Type="String" />
</SelectParameters>
in codebehind
foreach (ListItem li in ListBox_Activities.Items)
{
if (li.Selected)
{
queryBuilder += li + "', ";
}
queryBuilder = queryBuilder.Substring(0, queryBuilder.Length - 1);
LabelHidden.Text = queryBuilder;

When i run the code it comes up blank. I did a query trace and it seems to be running as

exec sp_executesql N'SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)',N'@EmployeeID int,@ActivityName nvarchar(50)',@EmployeeID=4,@ActivityName=N'Production Technical Support'', Tools Development'','

with exta "'s

How can i format the queryBuilder string correctly in my code?

View 3 Replies

DataSource Controls :: SQL Server Authenticate Fail?

Jan 23, 2010

I want to login my SQL Server by using SQL Server Authenticate but this i fail to do thatI have already configurate "sa" account and change to "windows and sql server authenticate" still not workingCan someone tell me or show me the tutorial how to properly configurate to using "sa" to login by "SQL Server Authenticate"?

View 3 Replies

DataSource Controls :: Executing Two Stored Procedures That Either Pass Together Or Fail Together?

Mar 2, 2010

I open a sqlconnection and sqlcommand. I execute a stored procedure and get the scope_identity from that procedure to be used within another procedure that needs to be fired. Unfortuntley if the second procedure fails forwhatever reason the data change for the first procedure commits anyway. I kind of want to do a began transaction end transaction on the c#.net side. Also I need to execute a stored procedure multiple times....

View 2 Replies

DataSource Controls :: Searches Using Full Text Index And 'contains' Fail When Include 'noise Words'?

Mar 11, 2010

I created a simple search form which populates a gridview from sql server. I use 'contains' on a varchar(max) field which has a full text index. I find if I do a search for "Mexico Argentina", I get multiple results, which is good.One thing my sql server stored procedure is doing is inserting the word 'AND' between words. I do this because I want all words to be found. So if the user inputs "Mexico Argentina", I am converting that to "Mexico AND Argentina"But if I have even one 'noise word' in the search string, I get no results at all. For instance, there might be a sentence in my database table saying "I prefer Mexico to Argentina" but if I put that sentence in, I get no results at all. The database is seeing my converted string:I AND prefer AND Mexico AND to AND ArgentinaAnd finds nothing.I also have another form, which does a more advanced search that allows 'exact phrase'. If the user chooses 'exact phrase', then I don't insert AND anywhere. Instead, I surround his phrase with 4 apostrophes - 2 before the phrase, and 2 after.So now the database sees:' ' I prefer Mexico to Argentina ' ' (I've put a space between apostrophes here to make it clearer to view.Now I not only get no results, I get an error message.

View 1 Replies

DataSource Controls :: System.FormatException Was Unhandled By User Code - Input String Was Not In A Correct Format?

Jan 20, 2011

"System.FormatException was unhandled by user code - Input string was not in a correct format"
This is driving me crazy! Can anyone see what the problem is?

[Code]....

View 15 Replies

DataSource Controls :: Connecting To SQL Server In Visual Studio 2008 Using Code - Error: 25 - Connection String Is Not Valid

Feb 2, 2010

Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.

Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.

View 2 Replies

DataSource Controls :: Fails At Rdr = Cmd.ExecuteReader(); And Also Fail At ZipCodes.Add(rdr["h.*"].ToString());?

Feb 25, 2010

Im trying to take the example from this website http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-2008-proximity-search-with-th and make it work on my site. Its this part im having troubles with

[Code]...

here is my code from my function that doesnt work.

[Code]...

Any suggestions on how to get it to work? it fails at rdr = cmd.ExecuteReader(); im also worried it will also fail at ZipCodes.Add(rdr["h.*"].ToString());

View 2 Replies

DataSource Controls :: How To Fail Data Flow Component From Script Component

Aug 3, 2010

I am trying to stop the data flow when certain conditions happen in the script component. Like if a row in the data set has an invalid date, I dont want that dataset to be inserted in the tables or go through OLEDB Destination, rather I want the entire data flow for that dataset to stop and go back to the control flow page.

I have tried mulitple solutions but nothing worked. Conditional Split ends up inserting the correct rows, but I just dont want anyting to be inserted when one row is bad, where as I do want the entire dataset to be inserted if all rows are good.

How can I fail the component when certain conditions happen int eh script component.

View 1 Replies

How Can The Exact Same Code And Stored Proc Work Fine The First Time But Fail The Second

Mar 3, 2011

I have a gridview 'gvTemplates' that loads from the Page_Load method. It is using a stored procedure and this works fine. Then I do a search function on that gridview and that works fine. So when I click the search cancel button, which calls the same exact code that loads the gridview from Page_Load, I get the dreaded 'Input string was not in the correct format'.How can the exact same code and stored proc work fine the first time but fail the second?Gridview:

[Code]....

View 3 Replies

DataSource Controls :: "Fail To Convert Byte To Byte[]" When Storing Image To Database

Apr 3, 2010

Not sure if this is the correct section to ask this but this is regarding storing datatype problem.im trying to convert an image file retrieve from a folder and convert it to Byte so that i can save into database

In below function i retrieve and convert the image from a folder to byte

[Code]....

Then i set ImageUrl in PageLoad
[Code]....

My image datatype in database is image

View 1 Replies

DataSource Controls :: Variable Connection String Parameter In A DataSource Control

May 20, 2010

I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:

<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%&#36; ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%&#36; ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>

As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.

View 1 Replies

DataSource Controls :: Can The Select Command Of A SqlDataSource Be Given By Code In The Code Behind File

Apr 16, 2010

Can the select command of a SqlDataSource be given by code in the code behind file. Also by calling the SqlDataSource.Select can the select statement be executed?

View 3 Replies

DataSource Controls :: Binding An ObjectDataSource To A Property In Aspx Code, Not Code-behind

Dec 3, 2010

I want to bind an ObjectDataSource to a property in my asp page and I want to do it in the page's aspx code, not in code-behind. I've already done it in code-behind, as follows:

[Code]....

I'd prefer to get rid of the ugly code-behind and just do this in mark-up. Something like
[Code]....

This gives me a run-time error: Cannot create an object of type 'System.Object' from its string representation 'SelectedBook' for the 'DataSource' property.Is there a way of doing this declaratively and not in code-behind? Further, what if what I want is to actually use a child property of the property in question? For example, if my Book object has a ReaderComments collection, can I databind to it decaratively in the aspx mark-up?

View 1 Replies

DataSource Controls :: Passing Parameter To Datasource In Code Behind?

Mar 25, 2010

I need to pass the control parameter to Sql Datasource in code behind,

<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"

View 3 Replies

Security :: Fail To Log Out When Using Ajax For Adding Controls

Sep 30, 2010

My masterpage has a loginStatus control to let users log out and it works very well on normal pages .Recently, I created a new content page associated with the mentioned master page. Such new page allows users to add textboxes dynamically through ajax asycpostback.
Unfortunately, loginstatus right now fails to work when i click it. I traced the process and i found out that the loggingout event was not fired when i click it.

I follow this video to make such "Dynamically add control" page.

http://www.asp.net/ajax/videos/how-to-dynamically-add-controls-to-a-web-page

View 2 Replies

Forms Data Controls :: Fail To Parse Variable To A Link Button?

Feb 14, 2011

I want to create a link button with following code. However, this linkbutton doesnt work correctly: when I clicked it, it cannot go to the target url and will cause an exception.

<asp:LinkButton PostBackUrl='LearnPage.aspx?cid=<%#Eval("cid") %>' runat="server"><%# Eval("cname")%></asp:LinkButton>

(The linkbutton is one column of a grid view)

Debugging the code, I found that the value of cid is not parsed to the url. Actually, this code <%#Eval("cid") %> is not recognized as a variable, the target url appears to be LearnPage.aspx?cid=<%# Eval("cid") %> instead of LearnPage.aspx?cid=VALUE.

View 1 Replies

DataSource Controls :: Query String Add Another DropdownList?

Mar 6, 2010

Trying to add another 2nd dropdownlist to Query String... Below This Query String works Perfectly:

Query = String.Format("SELECT {0} FROM {1} WHERE NACategory = '{2}' ORDER BY {3}", PrimaryKeyColumn, TableName, DDLCategory.SelectedItem.Text, SetSorting())
I've tried to add a 2nd DDLSubCategory.SelectedItem.Text - But its throwing and error message.
Exception of type System.StackOverflowException was thrown.
Query = String.Format("SELECT {0} FROM {1} WHERE NACategory = '{2}' AND NASubCategory = '{3}' ORDER BY {4}", PrimaryKeyColumn, TableName, DDLCategory.SelectedItem.Text,
DDLSubCategory.SelectedItem.Text, SetSorting())
Can Someone take a look I'm not sure how to write (add) 2nd DropdownList (DDLSubCategory.SelectedItem.Text)

View 6 Replies

DataSource Controls :: How To Programatically Set A Connection String

Sep 13, 2010

I am thinking of putting a drop down list to choose a couple of options. Depending on what is selected I want to then specify a specific connection string. I use the ConnectionString="<%$ ConnectionStrings:SomeConnectionString %>" format. How can I handle this in the .aspx page?

View 4 Replies

DataSource Controls :: SQLDataSource Connection String On The Fly?

Sep 12, 2010

I need to set the SQLDataSource connection string on the fly. Right now, this is what I have:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
OnSelecting="SqlDataSource1_Selecting"
SelectCommand= (working select stmt here)</asp:SqlDataSource>

Then, I have this:

[code]....

View 4 Replies

DataSource Controls :: How To Split String In SQL SERVER

Apr 25, 2010

I have tried to break the below string like

DECLARE
@strFilterCond Varchar(Max)
set @strFilterCond=''
SET @strFilterCond=' ISNULL(Cast(EmpID as Varchar(1500)),''Undefined'') = ''000012946'' AND ISNULL(Cast(EmpName
as Varchar(1500)),''Undefined'') = ''Abosch, Karen'' AND ISNULL(Cast(tblEmployees.JobLookupID as Varchar(1500)),''Undefined'') = ''Undefined'' '

The Result String are like:

ISNULL(Cast(EmpID as Varchar(1500)),''Undefined'')
= ''000012946''
ISNULL(Cast(EmpName as Varchar(1500)),''Undefined'')
= ''Abosch, Karen''
ISNULL(Cast(tblEmployees.JobLookupID as Varchar(1500)),''Undefined'')
= ''Undefined''

I am unable to Break the string. break this string in sp. I do not know how to loop through the string.

View 2 Replies

DataSource Controls :: CLR Connection String From Web.config?

Jun 16, 2010

I am using CLR project in my website.I have used bulk insert in there.I am not able to use context connection in the procedure.Is there any way to get the connection string from web.configor from context connection.

View 5 Replies

DataSource Controls :: Get The Connection String Of Sql - Don't Have Sql Management

May 15, 2010

i work with sql database i want to connect to sql server i dont have sql manegment who could i c the connection string the palce of the sql that wen i write these comand sqlconnection con = new sqlconnection("the connection string")

View 4 Replies

DataSource Controls :: String Is Truncated When Inserted Into DB?

Feb 10, 2010

I am trying to insert some string values into database.

The problem here is that, the string is truncated without warning..

Here is my vb.net code

[Code]....

And here is how I declared the varible in stored procedure

[Code]....

And If I insert "myCode01234567890" then it's truncated without warning at all.

How can I let it throw an exception rather then truncate the string without any warnings ?

View 9 Replies

DataSource Controls :: How To Get A String For Comparison Purposes

Jan 19, 2010

I have a table with userID's stored in it and I want to SELECT a user out of that table to see if it's the current logged in user. I'm using this as logic to determine what action a button click will do. For example the button click will do something like this:

[Code]....

My broblem is getting the UserName from my table of data. I've tried it like this:[Code]....

But when I try debugging it shows that CurrentUser's value = Nothing

My UserNames (ToUser) contain letters and numbers (nvarchar(30)).

View 10 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved