|
Print your query somewhere and execute it directly in query analyzer. You can find out what is wrong with query.
|
|
|
|
|
Ok, first you are looping through the entire grid and updating every row even if it was not updated. Normally with a datagrid, you have an edit button which puts the row into edit mode. When the row is in edit mode you have a save and cancel button. Then with your save button you run the update for that single row.
Now several post will probably follow talking about sql injection attacts. You should use a parameterize query or a stored procedure to do this update.
Finally, my best guess to what your update problem is:
I would guess this isn't the crid you think it is:
editgrid.Rows[i].Cells[1].Value
Hope that helps.
Ben
|
|
|
|
|
why you have put double 'equal to' simbol in FOR loop?
|
|
|
|
|
Asalam-O-Alikum
plz any one tell me how to retriev multiple datakey values fom grid
BasharatAli
Internee
METESYS Lahore
Pakistan
|
|
|
|
|
I usually create template columns which have a label in them which is the key and then I mark the label as visible = false.
Hope that helps.
Ben
|
|
|
|
|
thx Ben
but i got this
GridView1.SelectedDataKey.Item(Index)
BasharatAli
Internee
METESYS Lahore
Pakistan
|
|
|
|
|
That will work too. I have had some problems with datakey in the gridview, so I have decided to avoid it. If you ever have to manually set parameters in your sqldatasource or objectdatasource for some reason the datakey goes away, which is very bad. So I have stopped using them, since I find it necessary to manually set the parameters in the objectdatasource.
Ben
|
|
|
|
|
thanks 
BasharatAli
Internee
METESYS Lahore
Pakistan
|
|
|
|
|
Hi all.
I have created one asp.net application that provides download facility from the server.Is there any way to count the no of downloads for a particular artifact or software.
Thankx in advance. 
satyaki mishra
|
|
|
|
|
How you are linking the download file ? Is it like http://domain/file.zip, if so I think you won't be able to count the value. What I suggest is don't give direct download file link, when user clicks download link redirect him to another page where download count will be updated and redirect to download file internally.
Download Link -> Inetrmediate Page which updates count -> Redirect to download file
You can get a rough idea on how many users downloaded. You won't get a correct count because there is no way to find out whether download finished completely.
|
|
|
|
|
You can either use the logfile of your webserver to determine the amount of downloads, or create an intermidiate page which counts the downloads like most popular download websites do..
|
|
|
|
|
hi all,
I've moved my WebApp from local server to remote and now I can't manage users because it tells me: "The Web Site Administration is only supported on localhostand disk based web sites."
Thanks
|
|
|
|
|
Hi to all
div.breakafter {page-break-after:always;} this not working
Sunil Tvl
|
|
|
|
|
I want to write a function in ASP .NET to validate the text box.. like in C# i want to know whether it is possible to write a function using the Key Press event or Key Down event...
I dont want to use javascript .....
If there is any option of doing so pls let me know....
Thanx in advance....
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
|
|
|
|
|
sajan ss wrote: I dont want to use javascript .....
Too bad. javascript is what runs on the client, so that's what you have to use.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
In addition:
It is however possible to set the AutoPostback property of the TextBox to true and wait on the TextChanged event. However this event fires only when the user leaves the TextBox.
However, not exactly what you asked for and the user experience is rather bad.
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
Yeah, I didn't suggest it for that reason. My experience on these forums is if you mention in passing something that you should never do, the OP will proceed to do it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi All,
SmartNavigation is obsolete in 2.0. MaintainScrollPositionOnPostBack is added. But there are some features which were more in SmartNavigation, absent in the present version.
One of the most useful feature was, not entering browser history items for post backs on same page. I tried lot of ways to implement the same using javascript, but i failed. I found that SmartNavigation uses FRAMES (IFRAME) for doing this.
Can this be done in 2.0 ? Is there direct property of page to enable this feature only ? SmartNavigation was for IE only, is there a more generic solution for the same ?
Any help will be greatly appreciated.
Thanks
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
|
Hello everybody
Maybe one of you can help me.
I have an ASP.NET page that contains :
- a TextBox
- a RequiredFieldValidator for this TextBox.
- an HtmlImage
I added an attribute 'onclick' to my HtmlImage. It executes a javascript fonction that fill the TextBox with a default text.
If I do the following :
- click on the TextBox
- remove the text in the TextBox
- click the image
Then the textBox looses the focus and calls the validator which detects that the text has been changed and is now empty. So the validator displays the validation message (a '*' char).
After that, the javascript function is called (event onclick) and set the TextBox text to the default text. But the validation message is always displayed on the web page whereas the TextBox has got a valid value.
I have tried to use focus() in my javascript function but it was unsuccessful.
Can I call the validation function in my own javascript function to force the RequiredFieldValidator to re-evaluate the text in the textbox ? Or have you got any other idea ?
Thank you for help.
jpeg
|
|
|
|
|
Call javscript function OnBlur Event of TextBox.
Best Regard
Pathan
---------------------------------------------------
|
|
|
|
|
Thank you for your reply Pathan but It does not seem to work properly
I tried the following jscript on my button :
<br />
var oTxt = eval(document.all[objText]);<br />
var sVal = "25/12/2007";<br />
oTxt.value = sVal;<br />
<br />
oTxt.blur();<br />
The js code does not hide the validation message that has been being shown until TextBox looses the focus.
jpeg
|
|
|
|
|
Hi all,
I have one webservice conating one method like this
using EmployeeInformation;
[WebMethod]
public Employee getEmployeeInfo()
{
Employee emp = new Employee();
return emp;
}
Where Employee is Name of the Class .
I have on dll name EmployeeInformation which contains definition of Employee Class in following manner.
namespace EmployeeInformation
{
public class Employee
{
private ArrayList E_firstName;
private ArrayList E_LastName;
public Employee()
{
SqlConnection cnEmp = new SqlConnection(ConfigurationManager.AppSettings["EmpConnectionString"].ToString());
cnEmp.Open();
SqlCommand cmdEmp = new SqlCommand();
cmdEmp.Connection = cnEmp;
cmdEmp.CommandType = CommandType.Text;
cmdEmp.CommandText = "select E.FirstName,E.LastName from Employee E";
DataTable dtEmp = new DataTable();
SqlDataAdapter daEmpInfo = new SqlDataAdapter("select E.FirstName,E.LastName from Employees E", cnEmp);
daEmpInfo.Fill(dtEmp);
E_firstName = new ArrayList();
E_LastName = new ArrayList();
foreach (DataRow Emp in dtEmp.Rows)
{
E_firstName.Add(Emp["FirstName"]);
E_LastName.Add(Emp["LastName"]);
}
cnEmp.Close();
}
public Object[] Firstnames
{
get { return E_firstName.ToArray(); }
}
public Object[] LastNames
{
get { return E_LastName.ToArray(); }
}
}
}
Which returns Firstname and lastname of Employee from northwind database.
Can anyone tell me how to access data from webservice in my project.
plz Reply soon.
thanks and regards
Vivek
|
|
|
|
|
Serialize the return values using
Serialize Keyword
Best Regards,
Chetan Patel
|
|
|
|
|
In Web Service I don't have permission make any change.
I have only referecne of Webservice and i want to access data from the object return by webservice.
so please tell me what can i do on clients PC?
plz Reply
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
