How do I make a Sqldatasource perform its InsertCommand with VB.NET? Normally, a control on the web page would call this command, but I want to use it in Code Behind.The full routine will be to check and see if the sqldatasource is NOT empty then run an UpdateCommand, but if is empty then run an InsertCommand.
View 3 RepliesI'm trying to define a sqldatasource for writing out SQL Filestream data. For example, I have a SQL table with a column named Data, which is FileStream. The column type is VarBinary(max)
InsertCommand = "INSERT INTO MYTABLE (Data) VALUES (@Data)"
<asp:Parameter Name="Data" Type = ???? What goes here????>
In the code-behind to load the data, I want something like,
e.Command.Parameters("@Data").Value = StringToByteArray("HERE'S THE CONTENTS OF MY FILE")
I have StringToByteArray defined as Encoding.Unicode.GetBytes(String.Empty+inputParameter)
I have two pages for different companies with nearly the same ASPX markup and code-behinds (main alterations include certain fields from the same table being read-only in one and editable in another), #1 has a Select (for populating the DetailsView) and Update while #2 has Insert, Select and Update. #2's Insert and Update functions are not operating while #1's are just fine... I've gone through optimizing #2's codebase and I for the life of me cannot figure out why it's not functioning properly. What follows is #2's markup and codebehind for the relative functions accessed:
[Code]....
Here follows the code-behind:
[Code]....
I want to call a method in the code behind file from the aspx file, but I can't get the TypeName propery correct.
I can call methods in the dll:s in the bin folder and from files in the app folder, but not from code behind in the aspx page. What do I need to do.
I have a Gridview where I am presenting the data from a backend SQL DB. The values are populated into the Gridview without any problem and I am also able to Delete the rows and Update the info using the built in "Edit" Button, But when I try to insert some new value in a blank space nothing happens when I click on "Update" button. It just refreshes the page without any changes made. Below is my code for InsertCommand and also for DeleteCommand and UpdateCommand (which are working fine). There is also a column for "Record ID" which is the primary key in the table and is used in the Delete and Update command which is what I think is making these command work while it is not used (I don't know how to include it) in the Insert command.
View 2 RepliesI want to use a button to fire up the SqlDataSource InsertCommand. how do I do that? do I have to use FormView with 'DefaultMode="Insert" ?
View 2 RepliesCan 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 RepliesI 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?
I have a formview that has this button:
[Code]....
But I need to create a new button, that within the code behind calls CommandName="Update"
I want to call a function present in code behind from front page (html : source code)
i want to use like this:
Source code
<a href='<%# linkAlpha("B").ToString()) %>' title="B" id="B_List" runat = "server">B</a>
Code Behind
protected string linkAlpha(string value)
{
// /market-research/<%#Eval("customname")%>/
string str = "";
if (Request.Url.DnsSafeHost == "localhost")
{ // /market-reports/<%# Eval("customname")%>/
str = "Alpha_Category.aspx?q=" + value.ToString().Trim();
// Response.Redirect("Alpha_Category.aspx?q=" + value.ToString().Trim());
}
else
{
// str = "/market-reports/" + value.ToString().Trim() + "/";
str = "/Alpha_Category.aspx?q=" + value.ToString().Trim();
}
return str;
}
how do you call code behind button click event or a code behind method
from javascript.
I have an asp.net button, that when clicked calls a code behind function. The function does some evaluation, and then I want to call javascript from within this asp.net function.
View 2 RepliesI wish you are having a wonderful day Today I encounter a problem which I am unable to solver yet. have a e-mail subscription area and I am using accessdatasource for that. Also I am inserting the e-mail adress into database with AccessDataSource InsertCommand in aspx page not in codebehind. What I want is that;I want it to first check for the textbox-email value if it exists already or not ! Then if exists, I want to make "LabelOutPut.Text = "Already Exists !"" But if not exists, I want to do on button click that; "AccessDataSource1.Insert() and LabelOutPut.Text = "Subscribed !"
View 13 RepliesI am wondering what the most efficient method is for retreiving a single cell of data from my database. I have a price table in my DB that I just need to look up one price at a time. Currently I load a dataset and call ds.tables(0).rows(0).item(0) for the value. I just want to make sure this is the best way do this.
View 1 RepliesI have a .net 3.5 page that calls a short sql server procedure which compiles fine. When the code is called
from a webpage(.net) it runs the first time it is executed. However on the second time it throws an error saying "There is already an object named 'strPKHoldUp' in the database." StrPKHold is a variable that I
declare in the code as seen below.... I have never had a problem before with declaring a variable and having it "save or cache" in the database so you can use it again. Any idea how to solve this? I tried
moving the DECLARE statement around a little bit but that didnt. I changed the variable name to something else and it works one time but fails after that...
[Code]....
I have created a stored procedure in Oracle. Now I want to call those procedure in VB.Net
Stored procedure:
[Code]....
How to call this sp in .net?
How to call a DLL from a stored procedure in SQL 2005?
View 3 RepliesI have a webservice I need to call via a link. The webservice returns a pdf document and takes a document Id as a input parameter.Under normal circumstances I could have the link call some code in the code behind which in turn calls the webservice.
However the difficult part about it is I can't add code to the code behind. The reason is it is for some CMS users who want to know what links to add to the page which will download the pdfs. I can only add the link to the aspx page.
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"
I have a InsertCommand function i am using to insert the dropdownlist in my updatepanel. When the Add button is clicked. It adds the record multiple times. Am not sure why it does this. Here is my code.
Dim Bank_number
As
DropDownList = UpdatePanel1.FindControl("ddlbank")Dim
NoteAccountNumber As
DropDownList = UpdatePanel1.FindControl("ddlAccount")'
UpdatePanel1.ChangeMode(FormViewMode.Insert)
lblsee.Visible =
"true"
'now collect selected information on the drop down
RelationshipTest.InsertParameters(
RelationshipTest.InsertParameters(
"bank_number").DefaultValue
= ddlBank.SelectedValue.ToString"noteaccountnumber").DefaultValue
= ddlAccount.SelectedValue.ToString'Insert into db
RelationshipTest.Insert()
Also, i was woundering if any of you might know the logic behind clearing inserted data from the dropdownlist once its inserted. I am trying to make sure data is not entered mulitiple times. Unique Indexing comes to mind but thats only on the backend.
Can I use one SQL command to call many sprocs ?
I would then use the returned data to create a dataset table like I did with one SPROC in this code :
[Code]....
[Code]....
i have created a function to call username to pass user id as pararameter,
how to call userdefined function in asp.net
here is my function in sql
CREATE FUNCTION getusername
( @userid bigint )
RETURNS table
AS
RETURN (
SELECT login_id
FROM mst_useraccount
WHERE user_key =@userid
)
go
I know the following sproc is vulnerable to SQL injection:
[Code]....
I would like to write a call to this sproc that uses SQL injection to execute the additional command:
[Code]....
That way, I can demonstrate the vulnerability of the sproc to SQL injection and test any revised implementations of the sproc using the same test call.
Problem is, SQL injection is harder than I thought! I just can't seem to do it.
Can anyone provide me with text for the sproc call to execute the additional command?
I want to call my business object class in which I have written my logic when any database status field change, what is the best way we can do, I want notification facility also.
I can do this window service. But there is any best way to acheive this like Notification and call my business object.
i have list view inside another list view like lv1-->lv2 now problem is inserting record in nested list view see error...
Inserting is not supported by data source 'SqlDataSource2' unless InsertCommand is specified.
another problem when i keep datasource2 in LV1 selected template but datasource2 is not binding lv2.. how can bind lv2...?