Click here to Skip to main content
Page 1 of 1
Page Size: 10 · 25 · 50


Author filtered by: Nayan Ambaliya [x]
Question 13 May 2013   license: CPOL
Dear all experts here... Current Scenario:Environment - Crystal Reports 9 - MS Access VBAI have some rpt (Crystal report) files sitting in the local directory.I have an Access VBA application.When I click a button named "Process" in the VBA application, the application runs those...
Answer 12 May 2013   license: CPOL
Ranjith, It could be even simpler.Considering you have a label named: lblTotalRecords or something like that,look at the code below:protected void BtnSearch_Click(object sender, ImageClickEventArgs e) {con.Open();SqlCommand cmd = new SqlCommand("Select...
Answer 12 May 2013   license: CPOL
Hey Ranjith, Label solution will be very simple.Format your page as below: (CSS does count on your look and feel)In your code behind:protected void SearchRecords(){ //code for connecting to the database and getting the results into DataTable //Assuming your...
Forum Message 12 May 2013  
Thank you very much. I just needed a clarification for not under-estimating my decision over my superior. Thank you very much.
Answer 12 May 2013   license: CPOL
Hi, I would suggest to show a label just above the data grid displaying the number of records searched. Popups can be used while validating the input for search or submit forms.But if at all you want to display a popup if there are no records, you can use AjaxControlToolkit.Download...
Forum Message 12 May 2013  
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example: User
Forum Message 8 May 2013  
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example:
Answer 7 May 2013   license: CPOL
Hi, Please review the following:I have developed a report using New Report in Visual Studio 2008 (rdlc format) and Visual Studio Data Sources.this.reportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;this.reportViewer.LocalReport.ReportPath =...
Question 7 May 2013   license: CPOL
Dear all, I require your opinion on what approach is good and/or practical for the following scenario.There is a web application which queries data from SQL server.For example: Users report to a manager1. The process by clicking a button is finding who reports to me (manager)2....
Viewing PDF in winforms by Nayan Ambaliya
Question 2 May 2013   license: CPOL
Dear all, I am building a windows forms application where people can view PDF (preview). I am successfully able to locate a file on the local computer and preview this in the PDF viewer control.What I want to do is:My file is located on an internet location which you can point to...
Answer 1 May 2013   license: CPOL
Hi, --Convert any date input to the stored procedure to datetime--Example:declare @tempStartDate datetimedeclare @tempEndDate datetimeselect @tempStartDate = convert(datetime, @InputStartDate)select @tempEndDate = convert(datetime, @InputEndDate)--write the query to...
Answer 1 May 2013   license: CPOL
Hi Rupal, Create a database with following tablesTable1: dbo.QuestionsQuestionID int (PK)QuestionText nvarchar(max)CorrectAnswerID int (FK)Table2: dbo.AnswersAnswerID int (PK)AnswerText nvarchar(max) QuestionID int (FK)Table3: dbo.AnswerOptionTypeOptionID...
Winforms navigation options by Nayan Ambaliya
Question 1 May 2013   license: CPOL
Dear all, Good morning..!!I am currently developing a windows forms business application.I am aware about the traditional Menu Bar as navigation option for this application. I want to know if people develop this windows forms navigation in any other way. I am reluctant to use the...
Answer 30 Apr 2013   license: CPOL
Thanks everyone for the solutions...This has certainly opened up my direction..Thanks again..Cheers,Nayan
Question 30 Apr 2013   license: CPOL
Dear all, I have puzzled myself over data communications from winforms to the SQL server database. Here is the scenario:I am developing a windows application which I will be publishing via ClickOnce technology.Therefore, the client resides on user PC and the data will be...
SQL Query Issue by Nayan Ambaliya
Forum Message 22 May 2012  
Dear all, I have this sort of weird question in terms of sql data and query. Consider the dataset below. I have this results in to a table variable (SQL 2008) EmailAddre
Answer 18 Jan 2012   license: CPOL
You should not be using SQL server to do this. SQL server is designed mainly for data operations and not data manipulations. The functionality is provided only to be used in instances where there is no external resources that could be used to do data manipulations or is much harder to do it...
Answer 18 Jan 2012   license: CPOL
The simplest way of achieving this;using System.Data.SqlClient;using System.DataPage_Load(){ SQLConnection con = new SQLConnection(); SQLCommand cmd; SQLDataAdapter adap = new SQLDataAdapter(); DataTable ds = new DataTable(); con.connectionstring = "";...
Answer 18 Jan 2012   license: CPOL
Ideally, I would go for the above solution but in some instances you would want a redundant data set. In this scenario, What is the difference between dates within different products in tbl_future ? For example, consider the below data rows in tbl_future:1000 Product1 2011-01-01...
Answer 18 Jan 2012   license: CPOL
I am supposing;1. You are loading leave types in a leave management system.2. The leave types are stored in a look up table in the database3. For example, when your ApplyForLeave.aspx file or any other file loads up in the browser, you would like to populate the leave types.For this...
Answer 19 Oct 2011   license: CPOL
Product search By Title and By Manufacture is different from Product search by Categories; because I assume that you would have a list of categories which will be populated from the database (of course not to mention that each category would have an ID associated with it) and Title and...
Answer 19 Oct 2011   license: CPOL
I would not be able to figure out the issue with the code given in your description but surely would tell you how to do it.Please follow the following steps:1. Load categories (from category table) in to the categories combo box I assume that you have a category ID in the table ...
Answer 19 Oct 2011   license: CPOL
It seems that you are not handling the change event properly. From your description of the problem above, please try to make sure the following points.1. All the four combo boxes have different names in context of their Identity and Event Handlers (Selected Index Changed)2. Make sure...
Model Pop Up Extender In Ajax by Nayan Ambaliya
Answer 3 May 2011   license: CPOL
Please be a little bit more descriptive about your questionAnyways, I am assuming the below scenarios1. You click a button on the .aspx page but the modal popup is now shown2. You have a button inside the panel which is shown when modal popup is active and that button when clicked does...
Answer 3 May 2011   license: CPOL
There are many ways you can do this. But it has some restrictions on the data. You can use the following manner provided the below conditions.Conditions:The data needs to have a chronological ID field within it.The process would be;1. The first time you call the database, return...
Answer 3 May 2011   license: CPOL
You will need to update your back links if you have a track of them. I would recommend to submit a new sitemap to Google where it will then crawl to and update the old pages.You can also wait for some time to let google automatically update the links. But you would still be carefull in...
Answer 3 May 2011   license: CPOL
You will need a dummy button control to achieve this behaviour. Steps would be:1. Have your normal cancel button on the page2. Have a invisible dummy cancel button with the CSS Style as display:none (strictly not Visible="false")3. Have your popup panel on the page4. Have your modal...
Answer 3 May 2011   license: CPOL
You can achieve it in a following manner:UPDATE     L2SET        L2.AreaID = S2.AreaID,            L2.Category = L3.CategoryFROM Line2 L2INNER JOIN Sheet2 S2 ON L2.gateID = S2.gateIDINNER JOIN Line3 L3 ON L3.gateID = S2.gateIDPlease let me...
Answer 3 May 2011   license: CPOL
From what I understand from the question: you want the application to remember the authentication required page. If a user visits that page without authentication, the application redirects to the login page and after login, it redirects automatically to the area where the user is coming from....
Answer 3 May 2011   license: CPOL
I would recommend the following solution if your system is a complex one using many stored procedures and using it many times. 1. Use an object class which stores the stored procedure names of your database This will help you in future of not having any spelling mistakes in calling the...
C#

Page 1 of 1


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 15 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid