|
Can i select two or more records randomly from a table in a dataset if yes pls give me a suggestion
|
|
|
|
|
You can access the records in a DataTable by row index, therefore generate 2 random numbers lower than the number of rows in your DataTable and use those to access the records/rows.
|
|
|
|
|
how to generate random numbers
|
|
|
|
|
Take a look at the Random[^] class.
|
|
|
|
|
I'm tasked with helping a developer finish up a web page that collects information about an order and populates some SQL Server tables. ASPX with C#. I'm not a C# guy, but my main job here is to keep him on task, interface with the dept. that will need this, and validate the data design. At present, there are some issues with postbacks. He does a good bit of validation, mostly to ensure fields aren't blank, and posts back upon exit of a good many fields. One problem is retaining focus after postback. The user enters a value, presses tab, and a postback occurs. Instead of the focus moving to the next field, there seems to be no field with focus after the postback, which forces the user to click in the next field with the mouse. So instead of being able to tab to fields as expected, the user keeps having to use the mouse to get the focus to the appropriate field. This is not very desireable at all. Another issue is what fields cause a postback. An example would be a field that can be empty (zero), but if it's >0 another field needs to be populated. The postback occurs after the first field and an error message is displayed next to the second field saying it can't be empty, yet the user hasn't even had a chance to enter anything in that field. This is most likely a simple fix of where the validation originates from (the second field instead of the first), but the programmer seems to think this is hard to do or not doable. I may have to dig into C#, but some help here would be appreciated.
Thanks,
Russell
|
|
|
|
|
Why are you validating on the server when the user tabs out? I'd keep the "light" validation on the client side with JavaScript and save the postbacks for submitting the form. Then you can set the focus to the field that has errors, or move them on.
That validation you are mentioning should definitely be clientside. Is the developer rolling their own code, or using something supplied by the framework like a RequiredFieldValidator that can be set to dynamic and will run on the clientside without a postback?
If there is some compelling reason why you would roundtrip every time a user leaves a field (which seems to make sense only for a small internal app without many concurrent users, otherwise it won't scale well) then I'd look at using a callback instead of a postback for the validation. They are not complicated to wire in and infinitely improve the user experience while cutting down on the size of network traffic (have you used Fiddler or something similar to see how much data, like ViewState, gets thrown around when you postback?)
|
|
|
|
|
I have been thinking clientside validation is the way to go, also. I'm coming in late to this project and we have a deadline looming on 9/1, so that's a consideration when making changes. I only realized we had this problem yesterday, unfortunately. The page is for external users, but the volume will be low (about 1600 users entering one order each over the period of two - three months). As you can see, the amount of traffic is not really an issue, but serverside validation may not be the way to go due to these other issues. Thanks for your reply.
|
|
|
|
|
Checking for blank fields, etc should definetly be done on the client side.
Here is an example Javascript validation routine:
function valToFormulator() {
if ((document.getElementById('<%=tbxCustomerID.ClientID%>').value == "") ||
(document.getElementById('<%=tbxContactID.ClientID%>').value == "")) {
alert("You must select a contact before sending to the flavor chemist.");
return false;
}
else
return true;
}
On the ASP.NET button, I have the following attribute:
OnClientClick="return valToFormulator();"
If the validation routine returns a "false", then the PostBack does not occur and the validation routine displays the Popup alert box with the error message.
Have your programmer try it out on a simple field validation where a field cannot be blank. You will be much happier with the performance. 
|
|
|
|
|
Hello
My web page has download and upload page. I design the form with text boxes and combo boxes. I want to know what should I write in the code-behind for the button to collect the information from the text boxes and recieve the attached file.
Excuse me for bad english writing.
|
|
|
|
|
If all the controls are Runat=Server
you can directly access the objects in the server side. Like
fileupload.SaveAs("filelocation") //File Upload is asp:FileUpload control
YourTextbox.Text = "Hello"
Hope this helps.
|
|
|
|
|
hasani2007 wrote: I design the form with text boxes and combo boxes
What is the purpose of TextBox and Combo Box over here ?
Use only FileUpload Control To Upload File and Use an Button say Upload. OnClick on that button upload the file.
Use this samle code. Please Check the syntax.
If(FileUplaod1.HasFile)
{
FileUpload1.SaveAs(FilePath);
}
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
|
Hello,
I am having problem in running query for the following code:
Actually My database in in MS Access and I need to compare the date column (which is in Date format in the database) with the value of the Date textbox (which is a string). So maybe I need to convert the string to date format and then compare......should I convert to date format?
My date is stored in the database as dd-mmm-yy. For example it's stored as 31-Aug-09.
Please assist:
public void executePositiveListQuery_ANY(string selected_Date)
{
string sql;
if(selected_Date=="empty")
sql= "SELECT DISTINCT re_MLNO FROM ml_hiv_status WHERE (re_HIV1_Status=1 AND re_HIV2_Status=1)";
else
{
string selectedDate = (Convert.ToDateTime(selected_Date)).ToShortDateStr ing();
sql= "SELECT re_MLNO FROM ml_hiv_status WHERE ( re_SpecimenDate='" + selectedDate + "' AND re_HIV1_Status=1 AND re_HIV2_Status=1)";
resultsLabel.Text ="You Have selected"+ selectedDate;
}
try
{
OleDbConnection connection = new OleDbConnection(HIV.Database.DataConstants.CONNECT ION_STRING);
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommand command = new OleDbCommand(sql, connection);
DataSet ds = new DataSet();
adapter.SelectCommand = command;
int count = adapter.Fill(ds);
if (count > 0 && count <= 200)
{
DataView view = ds.Tables[0].DefaultView;
resultsDatagrid.DataSource = view;
resultsDatagrid.DataBind();
resultsDatagrid.Visible = true;
resultsLabel.Text = count.ToString() + " results found.";
resultsLabel.Visible = true;
exportLinkbutton.Visible = true;
}
else if (count> 200)
{
DataView view = ds.Tables[0].DefaultView;
resultsDatagrid.DataSource = view;
resultsDatagrid.DataBind();
resultsDatagrid.Visible = false;
resultsLabel.Text = "More than 200 results found. Please Click the Export to Excel Link to Download the Results.";
resultsLabel.Visible = true;
exportLinkbutton.Visible = true;
}
else
{
resultsLabel.Text = "No results found.";
resultsLabel.Visible = true;
exportLinkbutton.Visible = false;
resultsDatagrid.Visible = false;
}
connection.Close();
}
catch(Exception ex)
{
message.InnerHtml = "SQL: " + sql + "<p></p>" + ex.ToString(); here!!
}
|
|
|
|
|
The best thing to do would be to parameterise the query so the conversion work is done for you.
Failing that, converting the date format in your query string to either yyyy-mm-dd or dd mmm yyyy should do the trick.
|
|
|
|
|
How would I do that? Can you please help?
|
|
|
|
|
|
OledbParamenter @yourtime
|
|
|
|
|
I created a Web User Control that contains an HTML Input Box. On my web page I have added this Web User Control. In the page_load of the code behind of my web page how can I set a default value to the Input box?
|
|
|
|
|
Set the value property of the input box in user control.
Or do you want to set it at page load?
|
|
|
|
|
I want to set the value at page load.
|
|
|
|
|
Create a public set property in the user control and then use it from main page to set the value in textbox.
|
|
|
|
|
your html controller:
<intput: type=" Button" text="<%some" public%="">>
server page :
UserController.somepublic=yourValue;
|
|
|
|
|
input type="Button" text=<%some public%>
|
|
|
|
|
Hello Friends,
I'm creating custom paging. Everything is working fine but there is a problem actually
i'm displaying for four pages at a time i.e. 1,2,3,4 and a Next for moving on next pages.
But as i click on Next button it's bringing correct records and correct paging control.
But now if i click on any New page buttons that's n't working i have to press page button
two times to work on.
for example if i've to view Page No. 6 then i've to press Page No. 6 two times
http://autoneed.in/Rough/Paging.aspx[^]
|
|
|
|
|
Hi,
Would you mind pasting you code here?
That will help people where the issue is, this is some logical mistake I guess so.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
