Gridview does not display , with or without data 2) how do

Question

Hi all ,

 

could anyone kindly help me with these issues 

 

1) At runtime my gridview  or datalist or formview does not display on the webpage , despite being connected to data via a sqldatasource to an  sqldatabase , all other controls display on the webpage i.e textboxes, labels , what is wrong , ive checked my code and tried , without connection to a datasource  but still get same ! , just displays a blank page

 

2) i am passing an int  variable from one aspx page to be inserted   into a table in the destination page using c# and asp.net ,

 

please how do i go about it  [e-mail]

 

 Regards

 

Chinedu Nwankwo

 

 

Answer 1

can any body solve this SQL code running total, it is not working  MS ACCESS Database?

 

ID-OrderID-OrderDate-Amount-Running_Total

1-1-11/11/2016-120-120
2-2-11/11/2016-40-160
3-3-11/11/2016-30-190

4-4-11/11/2016-80-270

 

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<%@ page import="java.util.Calendar" %>
<%
//java Code 25/11/2016

try
{
String date = (new java.util.Date()).toString();
String OrderDate=request.getParameter("OrderDate");


int OrderID = Integer.parseInt(request.getParameter("OrderID"));
int Amount = Integer.parseInt(request.getParameter("Amount"));
int Running_Total=Integer.parseInt(request.getParameter("Running_Total"));

String sql_debit="select OrderID,OrderDate,Amount,(select sum(Amount) from CustomerOrders where OrderID <= OrderID)'Running_Total' from CustomerOrders";
String s="jdbc:odbc:Database2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(s);
Statement pstmt=conn.createStatement();
Calendar calendar = Calendar.getInstance();
java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime());

ResultSet result = pstmt.executeQuery(sql_debit);
//int count = 0;
while (result.next())
{
//result.getInt("Running_Total");
Running_Total = result.getInt(1);
//result.getInt(1);
String output = "User #%d: %s ";
System.out.println(String.format(output, Running_Total));
}
conn.close();
}
catch(Exception ex)
{
System.err.println(ex.getMessage());
}
%>

</body>
</html> 

Answer 2

Use regex those are best for validation for phonenumbers,pincode and so on

http://stackoverflow.com/questions/28716539/how-to-validate-pin-code-mobile-number-and-email-in-javascript

For saving and rerieving images

http://stackoverflow.com/questions/21452418/source-code-to-store-image-into-mysql-database-and-retrieve-it-and-display-in-js