Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 14th, 2014, 06:13 AM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Question automatic alert message by detecting sql command

hii guys, please help me to solve my problem.
actually im doing inventory system where one of its function is to automatically detect the stock/product that has reach its limit by using alert message.
for this case, i have product table that consist pid, pname, vendorid, productamount, lead time and safetystockamount.
im doing it using c#.net (visual studio 2010). im using sql server for database.

in my page, i actually will show the product details by using gridview tool in visual studio by referring to product table in my database and when the user first come into the page, the alert message will come out. This alert message only will pop out if there is one or more product that reached its stock limit. If all the product amount are in more than safetyamount then this alert message will not coming up.

my sql command for this function is :
<code>
select case when (P_Amount <= SafetyStockamount)
then 'Limit stock has been reached'
end as Alert
from Product </code>

when i execute this statement in my sql server management studio then the result will show the list of product stock level condition. if the product amount is less than safetystockamount then it will show 'limit stock has been reached' while if the product amount is in good condition then it will be 'null'.

For the c# code i also tried to combine both alert message code and sql command but as i can see the program only execute the alert message code so everytime when i open the page then the alert message will pop up. It will happen everytime which means even though one of the product amount is still in good condition (> then safetystockamount), the pop up alert also will come out. @@

below is my c# code :
<code>if (Page.IsPostBack)
{
SqlConnection connection = new SqlConnection("Data Source=MELINA_YEO-VAIO; Initial Catalog=InventorySystem; Integrated Security=True");
connection.Open();
SqlCommand abc = new SqlCommand("Select case when (P_Amount <= SafetyStockamount) then 'Limit stock has been reached' end as Alert from Product");
Page.RegisterStartupScript("ScriptDescription", "<script type=\"text/javascript\"> alert('Limit stock has been reached');</script>");
} </code>


my javascript code:
<script type="text/javascript">
alert('Limit stock has been reached!');
</script>

please give me solution for this problem. thanks in advance :)
Reply With Quote
  #2 (permalink)  
Old May 14th, 2014, 06:22 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

You're never executing your SQL command or deal with the results. All you do is declare the command, but the SQL statement will never be fired against the database.

Take a look at this tutorial to see how to execute the command, and deal with its return value: http://www.csharp-station.com/Tutori...otNet/lesson03

Cheers.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #3 (permalink)  
Old May 14th, 2014, 07:55 AM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Imar View Post
Hi there,

You're never executing your SQL command or deal with the results. All you do is declare the command, but the SQL statement will never be fired against the database.

Take a look at this tutorial to see how to execute the command, and deal with its return value: http://www.csharp-station.com/Tutori...otNet/lesson03

Cheers.

Imar
imar, i tried this already, but still not working .
this is my code

<code> Page page = HttpContext.Current.Handler as Page;
if
(page != null)
{
string message = "Limit stock has been reached!";
ScriptManager.RegisterStartupScript(page, page.GetType(), "err_msg", "alert('" + message + "');", true);
}
}



class SqlCommandDemo
{
SqlConnection conn;

public SqlCommandDemo()
{
// Instantiate the connection
conn = new SqlConnection("Data Source=MELINA_YEO-VAIO; Initial Catalog=InventorySystem; Integrated Security=True");
}



protected void ReadData(object sender, EventArgs e)
{
SqlDataReader rdr = null;

try
{

conn.Open();


SqlCommand cmd = new SqlCommand("Select case when (P_Amount <= SafetyStockamount) then 'Limit stock has been reached' end as Alert from Product", conn);


rdr = cmd.ExecuteReader();


while (rdr.Read())
{
Console.WriteLine(rdr[0]);
}
}
finally
{

if (rdr != null)
{
rdr.Close();
}

if (conn != null)
{
conn.Close();
}
}
}
}
}</code>

but when i execute the page does not show up @@
do i do sth wrong again with this ?
Reply With Quote
  #4 (permalink)  
Old May 14th, 2014, 09:34 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

You need to do something with the results from the command. Currently, you loop over the data and output it to the console which isn't all that useful in a web application.

You need to add some if logic that alerts the message whenever some row in your data set matches your criteria. I think, but that's only a wild guess as I am still unsure what you're trying to accomplish) that you may need a WHERE clause for a product ID in your SQL statement. Then you can read your data and inside the while (dr.Read()) call check the return value and if it matches some condition then output your alert. E.g.:

Code:
while (rdr.Read())
                {
  if (rdr[0].ToString == "Whatever you're cheking"))
  {
     string message = "Limit stock has been reached!";
                 ScriptManager.RegisterStartupScript(page, page.GetType(), "err_msg", "alert('" + message + "');", true);
  }
                }
Hope this helps,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Prevent IE alert message ? Master123 Pro Java 2 September 1st, 2007 10:29 AM
Send an automatic email alert Based on Date/time lakshmi_annayappa ASP.NET 1.0 and 1.1 Basics 3 May 28th, 2007 12:07 AM
flashing alert message semooth Access 2 February 3rd, 2006 01:00 PM
Security Alert Message Maxood Beginning PHP 5 July 12th, 2004 02:09 PM
Alert Message ferfish Classic ASP Basics 1 May 16th, 2004 06:43 PM



All times are GMT -4. The time now is 03:54 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.