|
Your save function should have a return type, either bool or maybe int. You can assert that correct data passed to the save function will return true (in case of bool, or a 0 for int) and for bad data a return of false (or a specified error code for ints). You could always have a custom return type if you wanted.
|
|
|
|
|
Hello all,
I want to be have a dropdownlist and its item for example is:
10000-20000
20000-30000
30000-40000
I want when i click on one of them,a collection of item comes with the its price range.
how i can do this?
how i should design database for this aim?
please help me,
thank you,
Hoda
|
|
|
|
|
create some tables in your database
(SqlServer: )
Table brackets
Fields
ID (seed, int),
bracketMin (money),
bracketMax (money)
Table Products
Fields
ID (seed, int),
bracketID (int),
Description (nvarchar(50)),
Price (Money)
Queries:
for your dropdown:
SELECT ID, Convert(varchar, bracketMin) + '-' + Convert(varchar, bracketMax)
FROM Brackets
For your gridview to display the prices
SELECT ID, Description, Price
FROM Products
Where bracketID = dropdown.selectedvalue
|
|
|
|
|
good solution, but you dont need to store the bracketId in the products table - and this is a bad idea if you ever change the bracket min/max it might invalidate this value.
<br />
SELECT ID, Description, Price<br />
FROM Products<br />
INNER JOIN brackets ON product.price BETWEEN brackets.bracketMin AND bracket.bracketMax<br />
WHERE bracketID = {dropdown.selectedvalue}
|
|
|
|
|
Dear Friend,
thank you very much for you response.
|
|
|
|
|
hai,
here i am updating 100 records at the same time.
when the update fails, the record is to store in a log file (.txt).
how to implement.?
FOR EXAMPLE.............
try
{
for (i=1;i=5;i++)
{
int a=i;
sqlinsert="update tbl_name set loop_no=a where rollnumber=a";
cmd = new SqlCommand(sqlinsert, conn);
}
}
catch(SqlException ae)
{
strreturn += "<br>Message: " + ae.Message.ToString();
}
How to capture the failure records for the above UPDATE statement?
HELP ME!
i m using ASP.NET with C# (.net 2005, 2.0 framework)
modified on Wednesday, April 16, 2008 8:40 AM
|
|
|
|
|
Hi John Sundar,
In the try block yau have a statement
try
{
cmd.ExecuteNonQuery();
}
Catch(Exception ex)
{
// In the catch block write file streams to write the file and in the file write roll no which not updated.
}
|
|
|
|
|
could u provide me an example senthil? for my QUESTION?
|
|
|
|
|
After You enter
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
FileStream fs;
StreamWriter sw;
fs = new FileStream("practice.txt", FileMode.Open );
sw = new StreamWriter(fs);
// write a line to the file
//In this line you concatenate the data
string newLine = "Not so different from you and me";
sw.WriteLine(newLine);
// close the streams
sw.Close();
fs.Close();
}
|
|
|
|
|
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
FileStream fs;
StreamWriter sw;
fs = new FileStream("practice.txt", FileMode.Open );
sw = new StreamWriter(fs);
// write a line to the file
//In this line you concatenate the data
string newLine = "Not so different from you and me";
sw.WriteLine(newLine);
// close the streams
sw.Close();
fs.Close();
}
-----> i dont want to store a single line in the practice.txt. i need to store the record values which is failed (i.e.. 100,200) as mentioned in my example.......
How to achieve it?
thanks in advance
|
|
|
|
|
Whether you are entering the values in the textboxes(Roll No) for updating the records.
|
|
|
|
|
no senthil, i m taking those roll numbers from an excel file and processing.... i will pass the roll number one by one. when it failed, i want to store it........
how to achieve it?
|
|
|
|
|
How will you take from excel file can you send me the code?
|
|
|
|
|
hai,
here i am updating 100 records at the same time.
when the update fails, the record is to store in a log file (.txt).
how to implement.?
FOR EXAMPLE.............
try
{
for (i=1;i=5;i++)
{
int a=i;
sqlinsert="update tbl_name set loop_no=a where rollnumber=a";
cmd = new SqlCommand(sqlinsert, conn);
}
}
catch(SqlException ae)
{
strreturn += "<br>Message: " + ae.Message.ToString();
}
How to capture the failure records for the above UPDATE statement?
HELP ME!
i m using ASP.NET with C# (.net 2005, 2.0 framework)
|
|
|
|
|
Hi,
You can use this logic. I hope that this may help you
int b = 0;
string ew;
for (int i = 0; i <= 5; i++)
{
try
{
if(b==i)
ew=Session["Good"].ToString();
Response.Write("pass" + i);
}
catch
{
Response.Write("Failed" + i);
}
}
Cheers..!
Vijay s
|
|
|
|
|
for (i=1;i=5;i++)
{
int a=i;
sqlinsert="update tbl_name set loop_no=a where rollnumber=a";
cmd = new SqlCommand(sqlinsert, conn);
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
FileStream fs;
StreamWriter sw;
fs=new Filestream("logfile.txt",FileMode.open);
sw=new StreamWriter(fs);
string newline="Roll No:"+a+"was not updated";
sw.close();
fs.close();
}
}
I think you understand, if you have any doubt ask me.
|
|
|
|
|
once if its go for "CATCH" block, how it can proceed others?
i.e, if record 2 fails, will it proceed other records and complete the whole FOR loop????
i tried.. but getting error...
how to achieve it?
thanks in advance and understanding....
|
|
|
|
|
In my existing project I'm getting this pop up message...
This page contains both secure and nonsecure items. Do you want to display the nonsecure items asp .net c#
But its happening few pages only....whats the exact issue...can somebody tell me...is there any coding (asp .net c#) thru this I can solve it.....
Internet - tool - options----this method doesnt required....
Thnx in advance.
|
|
|
|
|
Mostly it has to do with links in a page. Your page is run in https on the webserver but your link says http. Or you load images in your page with an absolute http path in stead of a relative ~\... path.
|
|
|
|
|
Hi digi..
all images path is such as ../image/........so which one will be better....\
~/image..... or ../image/....
please suggest me asap...
thnx
|
|
|
|
|
/image I think would be better
|
|
|
|
|
thnx..
i have used ../ lets c output....just updating webserver..
|
|
|
|
|
I used ../image path for the images....didnt work....
any other suggestion plz.
thnx.
raj.
|
|
|
|
|
read http://www.4guysfromrolla.com/webtech/121799-1.shtmlthis article about Server.MapPath() functionality
|
|
|
|
|
dynamic raj wrote: any other suggestion plz.
This message is a generic message that means exactly what it says - you are on a secure page (https) but some element of the page is nonsecure (http). This can be anything that is loaded into the page, such as an image (as already suggested), a css file, a script include, an applet etc.
If you are having trouble tracking down the offender, try something like fiddler[^] and watch for any http requests when hitting your https page.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
