I have problem to check "if the file is success deleted".This is the algorithm, if sqldatasource deleted success then ---show message or other action---end if
View 5 Replies[Code]....
how can i call the event in another event.like Button Click event.
i have built an inserting interface in a GridView's Footer Template. Added Button for insert , auto generated the insertCommand in SqlDataSource. But then how to Bind the data of inserting interface to insert command of SqlDataSource ?In FooterTemplate. i have taken TextBox.GridView's RowCommand Event is handled in this way.
[Code]....
(all that i did , i took help from this web site's tutorial)
So,How to insert data?
How do i check if linq insert/update query was successfull or how many rows were added/updated?
View 1 RepliesI am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
i wrote the following code to perfrom the inline deletion of datagrid elements.
[Code]....
the row deleted event is not firing and the row deleting event is firing twice. why is is happening?
i am using dataset,i retrived the values from the database and i deleted from the data set .is it possible to get values back?
how can i get those values?
How can I retrieve information from delete rows. I delete some rows from table in dataset, then I use method GetChanges(DataRowState.Deleted) to get deleted rows. I try delete rows in original table on server side, but it finished with this errors. I try get value of columns from row, which was deleted
[Code]....
I am trying to delete a row of records in a gridview. The selectMethod works perfectly fine, but the DeleteMethod doesn't. When I delete a row, only 1 row of records should be deleted, but the whole gridview was deleted! (I have about 3 -5 rows of data). I am using ObjectDataSource.
Data Access Layer
[Code]....
Business Logic Layer
[Code]....
Presentation Layer
Design:
[Code]....
Presentation Layer
Code Behind:
[Code]....
Iam a newbie in Linq to Sql. I have some problems with my deleting items function. assemble the code together:I must have the following code accumulated.
[Code]....
i am using sqlserver 2008 express.
i have a problem here, unfortunately i deleted "Manually" some important tables from my database, now i need to retrieve those tables,
i didnot take a backup for those tables,
can i retrive those tables or roll back delete process?
Is it mandatory to pass the Success and Failure method names as parameters while calling server side methods using PageMethods in client script.
I referred to article [URL] ....
I have a check box in the grid.IF IsChecked has a value checkbox should be checked else not.Should i check the check box in the ItemDataBound event or will it get checked automatically.
<asp:DataGrid Runat="server" ID="gridProduct" AllowPaging="True">
<Columns>
<asp:TemplateColumn HeaderText="Employee Name">[code]....
I have a sql view of a table, I need to check whether it is empty, if it is empty, I need to hide a grid, other wise I need to show it.
Is there anything useful for me to check the sqldatasource?
As example:
SqlDataSource1.isitempty();
or such things.
Do I have to use dataset or such things?
I have the following datagrid
[Code]....
Notice that I have multiple ItemTemplates. On the first itemTemplate I have an ASP image control showing some image. I would like that when a user clicks on that image the row gets deleted. How can I do that without using the asp:buttoncolumn?Also the same applies for selecting a row, that instead of deleting the row the row gets selected
I created a simple login page and called webmethod from jquery. which return true if success and false if failed.
Now I am trying to redirect page after successful login.
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
I have asked similiar question before where I have two control on the page header says "username" and "gender". User can select both the control or either one and the page will execute searching based on the criteria supplied. So if username supplied
SELECT * FROM [this_table] WHERE username = @username
and if gender supplied
SELECT * FROM [this_table] WHERE gender = @gender
and if both supplied
SELECT * FROM [this_table] WHERE username = @username AND gender = @gender
I know this sounds not very complicated but in my case, I am having like more than 10 controls up there. It is something likeusername, gender, age, date of brith, title, father name, frst name, last name, blur blur blur and it's a lot then I started to lost. if i were to use if else caluse on code-behind and produce query, it would end up writing a lot of if-else and if i use stored procedure (with if-else) then my stored procedure would contains a lot of if-else statement. I am fairly new to this concept and if I'm on the wrong track, please correct me. Is there any better way to save my hair without actually going through each
if-else statement to build the query ?p.s. I'm using GridView and SqlDataSource command to display the result back on .aspx page.
I am trying to check whether a username exists in my database before inserting the new row & display a message to the user if it does.
On my SqlDataSource my InsertCommand looks like this:
InsertCommand="IF NOT EXISTS (SELECT * FROM Users WHERE UserName = @UserName) BEGIN INSERT [Users] ([UserName], [FirstName], [LastName], [City], [State], [Country], [CompanyName], [Active], [PasswordHash]) VALUES (@UserName, @FirstName, @LastName, @City,
@State, @Country, @CompanyName, @Active, @PasswordHash) END"
This works as expected: If the username is unique, the row is created.
If the username already exists, the row is not added.
The problem is, if the row already exists, the insert is rejected but the user is not notified.
So my question is, is there a way I can notify the user?
Maybe something like: InsertCommand = "If Not Exists (select....) Begin Insert...Else Notify User Somehow End This is a basic database, I'm not using the built-in membership provider nor will be.
How do I programmatically add ParameterCollection ?
[Code]....
i use below sqldatasource for search within a gridview and it is working fine.i just add this control and set gridview datasource id to sql datasource id .but i need the same in codebehind dynamically.i need like this becuase i need to search in three textbox but before i use one textbox. so could someone show me a example how i add a sqldatasourse in code behind and set filter parameter for search from a gridview.
[Code]....
Which one is better for me to store urls of my products images while i was trying to bind images with gridview. provide me some code snippet to bind images to gridview with XMLDataSource.
View 3 RepliesIf I have a SqlDataSource like this one, is it possible to add a DataRelation in the sqldatasource? Or do I need to create a DataSet and add the Relation in CodeBehind?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CString %>"
SelectCommand="SELECT * FROM table">
</asp:SqlDataSource>
I have a asp.net page that has several SqlDataSources defined that feed data into some graphs. The problem is that the graph product does not handle "no data" very well, and throws an error. I'd like this to handle the situation more gracefully-- so I need to check whether the SqlDataSource returned data or now before rendering the graph (and if not, just post a message saying "No Data" or something).
Is there an easy way to check if the data source returned data, and do this if/then without a bunch of code behind?
I have a gridview with a sqldatasource with SelectCommand as below:
[Code]....
but it's not workling.....