I have DropDownList and GridView on my page. GridView is popuated based on DropDownList SelectedValue.
DropDownList Populated as following
DropDownList looks like (after binding)
I have a text box that I am reading mulitple employee names into. If the user enters a name that does not belong to an employee I want to cancel the item_updating function. Here is my code:
Dim RECIPIENTS() As String
RECIPIENTS = RLIST.Split(";")
Dim NAME As String
[code]...
I have a serious problem since yest, i have a grid and i have to pass parameter to datasource of grid during run time...i tried this way in grids it worked.yest wen i try to create a new grid and pass parameter thru onselecting method of grid. i faced problem.
here's my code:
[Code]....
when i run this code im gettin error that SQLDATASOURCE1_selecting is not a member of asp.webform1.aspx..
I'm still building). After loggin in, users are presented with 3 radio buttons (they work), and 3 cascading drop downs (they work). Below that is an AJAX Accordion with 5 panes, each pane has a tabpanel with 4 tabs, 2 of the tabs have gridviews that change based on who is logged in and the radio buttons and dropdowns above
View 1 RepliesI am using a LINQ to SQL data source for a ListView and perform a validation check in the Listview ItemUpdating event:
[Code]....
This works great and keeps the user from updating the record with invalid data.However, when I hit cancel after this operation, it saves the text in the box rather than cancelling the operation. Here's my code for the update button:
[Code]....
Update Function:
[Code]....
I do not handle the cancel button event, as the cancel operation has worked fine... unless someone enters incorrect information and e.Cancel is set to true.What am I doing wrong? Is it the mixture of using the LINQ Datasource and doing my own updating?
i have function writeToDatabase(); that function use to store registration information to database. and then after store todatabase success..another page will appear and need user to confirm all data that has been filled...then with the confirmation..all data will send to HOST. what about if send data to database success..and send data to host FAIL(any reason due to send to host fail) ... i just think about to cancel anything that function writeToDatabase() did..
View 1 RepliesWhen the webpage is in Edit mode, I need to warn the user "Do you want to continue, You may lose you changes" with Ok cancel buttons.I want only one ConfrimButtonExtender control, and I can use some kind of delegation. If any of the Navigation links are clicked, I want to call a javascript method which will trigger the click event of the main Orginal extender button. The code works fine. When I click the any of the navigation links, the Extender controls are fired and Confirm popup is shown. But the Issue is Cancel button is not working. If I click the Cancel button, the page still navigates to other pages
View 2 RepliesI try to clearn asp.net form on cancel button click using String.Empty but it does not seem to be working. Here's my aspx code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AddEmployee.aspx.cs" Inherits="AddEmployee" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
[code]....
I mean, what is the faster way to get as fast as I can more than one table with stored procedure? Is there any study what is faster and why? There is a big problem getting more than one table at once with Entities, so the only way is DataSet. But I was told DataSet work very slow. Is that true?
View 2 RepliesAm trying to get a working enity model with foreign keys working but have run into a problem. I have imported 3 tables with content and some data.Lets call these tables geo_countries, geo_counties, geo_municipalities and the FK are:1. geo_county have a column country_id wich corresponds to country_id in geo_country 2. geo_municipality have a column county_id wich correspond to the county_id in geo_county.The problem i have is when i try to get correspondig child items with the following code i run into trouble:
[Code]....
The problem above is that 'test' generates results but not 'test2', wich never return anything. Am i not supposed to be able to do it like i do in 'test2'? I earlier tried to add a child object by replacing ToList() with Add() and that worked. But i cant seem to get anything out of it.
im explaining this base on a test page that i have hosted as i was trying to track down my problem, i have a hosted page which i have hosted on the internet on a hosting service provider. the page has a normal gridview that is linked to a SqlDataSource. and theSqlDataSource has sql statements for selecting data, updating and deleting. They all work fine locally and even if i host them locally through IIS. but on the hosting service they down work. only the select work, which means i can view my data on the gridview but i cant manipulate it, delete and updating dont wanna work, they dont do anything. and the worse part is that im not even getting an error from them, on the grid i have enabled the autogenerate edit button and the delete, how can i make the update and delete work, or what is it that makes them not to work. the code for my test page is below
[Code]....
I have the following code:
[Code]....
but when I run it inserts '@test' (no quotes) into the database. What am I doing wrong? It's probably really simple but I've been looking at it for ages! :(
i.I have a problem with a sql query?there is 2 table.Student and file.Student uploads a file into database.Student FileStuID FileIDName FileNameSurname FileSize StuIDi wannt to show student's information and his uploaded files.For example:
View 13 RepliesIn codebehind I've succesfully connected to a TableAdapter, sent a parameter value, and am looping through the results of the selected record.Some of the values in the returned row, however, are nulls.Why won't this work?
[Code]....
I get The value for column 'AutoAGENTID' in table 'Permits' is DBNull.
I have made a simple stored proc which include Transaction through which I have to delete records from two tables EmpDetail and EmpDept . EmployeeId is PK in EmpDetail and FK in EmpDept. Procedure has been executed but on doing exec DelEmployee @EmployeeID='e07' showing 0 rows affected..
[Code]....
Dim dt as datatable = test.select()
dt.DefaultView.Sort = "col1 ASC"
for each dr in dt.rows
response.write(dr.item("col1"))
next
I had found out the sorting command is "dt.DefaultView.Sort", but why is it not working. Can someone shed a light.
dataTable with dataReader not working
[Code]....
I am trying to update record in GridView. But ObjectDataSource is creating original_{0} and new vlaue object (exactly the same).ObjectDataSource.UpdateMethod is as follows
[Code]....
The paremeters ("original_ProductBO" and "productBO") in the above function are supposed to have different values since I am editing record in GridView and then updating it.I have the checked the query by hard coding parameter values and it works. In the ObjectDataSource_Updating(..) event, I cheked the parameters ("original_ProductBO" and "productBO") , I am getting the same values. Can anyone tell why tow parameters have the same values when I am editing record in GridView Code for the ObjectDataSourec and GridView is attached below
[Code]....
[Code]....
I was trying to delete records from database and sometimes on production, the SubmitChanges() goes through and updates the associated entities yet the data does not gets deleted in the database.This is happening only in production and I could not replicate the same on stage or on my local machine. Now the table in which I am performing the delete transaction does have primary keys.
My code reads like
[Transactional(TransactionalTypes.TransactionScope)]
I am not sure if I am in the right spot here because this really doesn't have to do any datacontrol but hopefully somone can give me a hand with this.
Basically I have a bunch of TextBox controls on a page that are displaying the data I want but when I try to run an UPDATE query on the record I get nothing. The record values don't update and I don't appear to get any exceptions.....I am actually kinda really baffled on this one, here is what I have for the update code: [Code]....
Btw, if there is an easier way to do this with a control I am up for suggestions as I am just going off of some of my old VB6 ways
I have a strange problem...I am programatically adding an SQL SELECT query to my SqlDataSource that my GridView is bound to. If I use the follwing statement it works fine:
[Code]....
But if I use the following one, the gridview fails to load. The only way that this is different is it uses RTRIM and CAST on one of the fields:
[Code]....
I don't understand why this can be. If I try the statement exactly how it is in the query builder and run it it returns the rows no problem.
given below is the simple update string am using to update my database...
string q = "update register set fname='" + TextBox1.Text +
"',lname='" + TextBox2.Text +
"',gender='" + gender +
"',edu='" + TextBox3.Text +
"' where username='"+check +"'";
cmd.ExecuteNonQuery();
SqlCommand cmd =
new
SqlCommand(q, cn);
but it is not working...database is not getting updated...why?
this has to be a simple thing but I am missing it
here's what i have
the null condition and query works
the not null condition does not
I have tried:
ImageID=@id error myust declare @id
ImageID=id invalid column id
ImageID=?id incorrect syntax at ?
all errors occur at SqlDataReader Dr = Cmd.ExecuteReader();
int id = Convert.ToInt32(Request.QueryString["id"]);
string SQLquery ="";
if (id == null)
{
SQLquery = "Select Top 1 ImageData,ImageType from WebBGImages ORDER BY NEWID()";
}
else
{
SQLquery = "Select ImageData,ImageType from WebBGImages where ImageID=@id";
}
SqlCommand Cmd = new SqlCommand(SQLquery, connection);
SqlDataReader Dr = Cmd.ExecuteReader();
I'm using the CommandTimeout command on a SqlDataSource in a web page to allow running queries that will take longer than 30 seconds.However, when I run the web page, it doesn't work at all. I get a timeout error.Here is my code:
[Code]....
[Code]....
And the error I'm getting after 30 seconds: Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Im trying to do the batchinsert (bulk) in sqldataadapter using dataset.but somehow its not inserting (even no error as well), i dunno where i went wrong.my coding..
Dim _cmd As New SqlCommand