Click here to Skip to main content
15,914,246 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: How i retrieving Images from database sql server to ASP.NET page plz? Pin
ma.amer6-Jun-09 3:31
ma.amer6-Jun-09 3:31 
QuestionReg:Google API Calendar Permission Pin
P.T.R.K5-Jun-09 22:05
P.T.R.K5-Jun-09 22:05 
Questionsearching for v.good web hosting service Pin
Mohammad A Gdeisat5-Jun-09 17:30
Mohammad A Gdeisat5-Jun-09 17:30 
AnswerRe: searching for v.good web hosting service Pin
Abhijit Jana5-Jun-09 18:23
professionalAbhijit Jana5-Jun-09 18:23 
AnswerRe: searching for v.good web hosting service Pin
Kapil Thakur5-Jun-09 21:49
Kapil Thakur5-Jun-09 21:49 
GeneralRe: searching for v.good web hosting service Pin
Mohammad A Gdeisat6-Jun-09 1:05
Mohammad A Gdeisat6-Jun-09 1:05 
GeneralRe: searching for v.good web hosting service Pin
Kapil Thakur6-Jun-09 1:15
Kapil Thakur6-Jun-09 1:15 
AnswerRe: searching for v.good web hosting service Pin
Aman Bhullar6-Jun-09 1:32
Aman Bhullar6-Jun-09 1:32 
QuestionWebControl isn't working at all. Please help me. I have tryed it for several days.. [modified] Pin
valmirpaixao5-Jun-09 4:58
valmirpaixao5-Jun-09 4:58 
AnswerRe: WebControl isn't working at all. Please help me. I have tryed it for several days.. Pin
Christian Graus5-Jun-09 23:38
protectorChristian Graus5-Jun-09 23:38 
QuestionASP session expire issue Pin
George_George4-Jun-09 22:16
George_George4-Jun-09 22:16 
AnswerRe: ASP session expire issue Pin
J4amieC5-Jun-09 0:21
J4amieC5-Jun-09 0:21 
GeneralRe: ASP session expire issue Pin
led mike5-Jun-09 9:03
led mike5-Jun-09 9:03 
GeneralRe: ASP session expire issue Pin
PrestonMB5-Jun-09 17:03
PrestonMB5-Jun-09 17:03 
QuestionCrystal report from typed dataset problem Pin
Tim@Headcount4-Jun-09 13:47
Tim@Headcount4-Jun-09 13:47 
AnswerRe: Crystal report from typed dataset problem Pin
David Mujica5-Jun-09 2:54
David Mujica5-Jun-09 2:54 
GeneralRe: Crystal report from typed dataset problem Pin
Tim@Headcount5-Jun-09 6:15
Tim@Headcount5-Jun-09 6:15 
OK, here is the pertinent code. I have examined the datatable in debug mode and it looks to be populating just fine so I don't think that is the problem. I've also tried assigning the table to a dataset and setting the datasource to the dataset with the same result.


/// <summary>
 /// retrieves a dataset for all the Chains selected
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void Button1_Click(object sender, EventArgs e)
 {
     HeadCount_Controller controller = new HeadCount_Controller();
     int Filter = System.Convert.ToInt32(RadioButtonList1.SelectedValue);
     string DateFrom = txb_DateFrom.Text;
     string DateTo = txb_DateTo.Text;
     int TrafficTol = System.Convert.ToInt32(tb_TrafficTol.Text);
     int TransTol = System.Convert.ToInt32(tb_TransTol.Text);
     List<Chain> ChainList = new List<Chain>();
     foreach (GridViewRow row in GridView1.Rows)
     {
         CheckBox cb = ((CheckBox)row.FindControl("cb_Select"));
         if (cb != null && cb.Checked)
         {
             Chain me = new Chain();
             me.Chain_Name = row.Cells[0].Text.ToString();
             ChainList.Add(me);
         }
     }

     HeadCountDataSet.DB_vs_App_CompareDataDataTable dt_CompareData = new HeadCountDataSet.DB_vs_App_CompareDataDataTable();
     dt_CompareData = controller.CompareData(ChainList, DateFrom, DateTo, Filter);
     ReportDocument MyReport = new ReportDocument();
     MyReport.Load(Server.MapPath("~/MyReport.rpt"));
     MyReport.SetDataSource(dt_CompareData);
     CrystalReportViewer1.ReportSource = MyReport;
     CrystalReportViewer1.RefreshReport();


 }


From the Controller;
/// <summary>
     /// retrieves a dataset of Serial Boxes, Store Names, Traffic/Transaction
     /// results from the App. and traffic/Transaction results from the DB for
     /// each ChainName in a list and combines the datasets into a single dataset.
     /// uses a stored procedure in the DB to Load the data
     /// to a table and compare the data with the Statistics table data.
     /// </summary>
     /// <param name="Chain_Name">The Chain Name as found in the Headcount.Chain table</param>
     /// <param name="DateFrom">a date string mm/dd/yyyy</param>
     /// <param name="DateTo">a date string mm/dd/yyyy</param>
     /// <param name="Filter">1 for sites where data matches, 2 for sites where data does not
     /// match, any other integer will return all site data</param>
     /// <returns></returns>
     public HeadCountDataSet.DB_vs_App_CompareDataDataTable CompareData(List<Chain> ChainList, string DateFrom, string DateTo, int Filter)
     {
         HeadCountDataSet.DB_vs_App_CompareDataDataTable dt_CompareResults = new HeadCountDataSet.DB_vs_App_CompareDataDataTable();
         foreach (Chain row in ChainList)
         {
             HeadCountDataSet.DB_vs_App_CompareDataDataTable dt_ChainData = new HeadCountDataSet.DB_vs_App_CompareDataDataTable();
             dt_ChainData = HeadcountDB.CompareData(row.Chain_Name, DateFrom, DateTo, Filter);
             foreach (HeadCountDataSet.DB_vs_App_CompareDataRow arow in dt_ChainData)
             {
                 dt_CompareResults.ImportRow(arow);
             }
         }
         return dt_CompareResults;
     }


Thanks for any assistance.
QuestionError code: ssl_error_rx_record_too_long when using SSL Pin
A k ch3-Jun-09 23:15
A k ch3-Jun-09 23:15 
AnswerRe: Error code: ssl_error_rx_record_too_long when using SSL Pin
Baku_ra15-Sep-10 9:28
Baku_ra15-Sep-10 9:28 
QuestionWhat are the best practice for Web UI Development?? Pin
Ponzano Paolo3-Jun-09 23:05
Ponzano Paolo3-Jun-09 23:05 
AnswerRe: What are the best practice for Web UI Development?? Pin
Paddy Boyd4-Jun-09 6:04
Paddy Boyd4-Jun-09 6:04 
QuestionRe: What are the best practice for Web UI Development?? Pin
led mike4-Jun-09 7:51
led mike4-Jun-09 7:51 
QuestionUpdate web site using dreamweaver Pin
Norman223-Jun-09 18:18
Norman223-Jun-09 18:18 
AnswerRe: Update web site using dreamweaver Pin
Marc Firth3-Jun-09 22:06
Marc Firth3-Jun-09 22:06 
QuestionPhoto Editing Plugin -- Any Ideas? Pin
Horrorshow803-Jun-09 9:13
Horrorshow803-Jun-09 9:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.