Hi All, I am developing one website. In That I want to call a popup window on dropdown_selectedIndexChaged. If I put That DropDown in an Anchor tag The Window Opens As Soon As I Click On DropDown Which I Dont Want. I Want that Popup Should Open After Selecting The Value Of That DropDown. So Please Help Me To Solve My Problem. And is there any way to write Anchor Tag in code behind and Call It On dropdown_selectedIndexChaged To Open A Popup. My Anchor tag Is Like This :

           <a id="AA1" runat="server" class="thickbox" title="" href="InventoryQty.aspx?action=add&TB\_iframe=true&height=420&width=700">
                    <asp:DropDownList ID="InsertDDLItem1" runat="server"
                                        AppendDataBoundItems="true"
                                        DataTextField="ItemName" 
                                        DataValueField="ItemID"
                                        AutoPostBack="true"
                                        OnSelectedIndexChanged="InsertDDLItem1\_SelectedIndexChanged" Width="280px">
                        <asp:ListItem Selected="True" Value="0">Select ITem Type</asp:ListItem>
                    </asp:DropDownList>
                    </a>

Please Help Me To Solve My Problem. Thanks & Regards Sanket Patil :) :)

.

Hi All, I am developing a web application. In that I have a web page that imports the data from EXCEL SHEET To Database. While doing this I have set some validation over the EXCEL Data. If the data is incorrect i need to write it in a new excel file which is created at run time. I have written the code to create new excel file with some data. But While Creating The Excel File I am Getting an error which i am unable to solve. So, Please Help me to solve my problem. I am using VS 2008 with c#. The Error is : Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. • To make more memory available, close workbooks or programs you no longer need. • To free disk space, delete files you no longer need from the disk you are saving to. The Code I have Written is :

Excel.Application WRExcel = null;
Excel.Workbooks WRwbs = null;

        Excel.\_Workbook WRwb = null;
        Excel.Sheets WRss = null;

        Excel.\_Worksheet WRws = null;
        object objOpt = System.Reflection.Missing.Value;

        if (System.IO.File.Exists("C:\\\\Excel1.xls"))
        {
            //Delete The Existing Excel Sheet
            System.IO.File.Delete("C:\\\\Excel1.xls");
        }
        //create Excel spreadsheet

        WRExcel = new Excel.Application();

        WRwb = WRExcel.Workbooks.Add(objOpt); // **My Error Occurs Here**

        WRss = (Excel.Sheets)WRwb.Worksheets;

        WRws = (Excel.\_Worksheet)(WRss.get\_Item(1));

        //create Excel column headings

        WRws.Cells\[1, 1\] = "Part Number.";

        WRws.Cells\[1, 2\] = "Kit Part.";

        WRws.Cells\[1, 3\] = "Description";

        WRws.Cells\[1, 4\] = "Reason For Reject";


        WRws.Cells\[2, 1\] = RowNo.Trim();

        WRws.Cells\[2, 2\] = ColumnNo.Trim();

        WRws.Cells\[2, 3\] = ErrorMsg.Trim();

        WRws.Cells\[2, 4\] = Filename;
        
        //save workbook

        WRwb.SaveAs("C:\\\\Excel1.xls", objOpt, objOpt, objOpt, objOpt, Opt,                 Excel.XlSaveAsAccessMode.xlNoChange, objOpt, objOpt, objOpt, objOpt, objOpt);

        //close workbook

        WRwbs.Close();

Please Help me to Solve My Problem. Thanks & Regards Sanket Patil

.

Hi to all, Please Help me to solve my problem. I have developed one web application.In that One Scan button is provided to scan Document through scanner. It works fine when I run Application on my local machine. Now the Problem is I have uploaded my web Application on server. But When I am Pressing Scan Button, It is not responding. Why It is Happening I don't know. So Please Help Me To Solve My Problem Thanks & Regards Sanket

.

Hi To All, Please help me to solve my problem. I am developing a web application. In that I need To Scan Document Through Scanner. I am not getting how i should implement, What resources I should use to get the device. I also want to set the path through code and after scanning the image, It should be displayed on My webPage. Please Help Me. And I will be glad if you Reply with Sample Code. Thanks & Regards Sanket Patil

.

Hi Everybody, I have developed A Desktop Application in VS 2008. In This One Facility Is Provided To Scan The Document. Firstly It Was Working Fine , But Now A Days I Am Getting The Error a generic error occurred in gdi+ While Saving The File. I Have Set All The Permission To The File Where The Scanned Image Is Saved. I AM Unable To Resolve The Problem. Please Help Me To Solve My Problem. Thanks & Regards Sanket Patil :)

.

Hello To All, Please Help Me To Solve My Problem. I am developing an Window Application. I just want to know that, what code should I write so that when user press the Update Version Button On Form, the Software Should get updated with new version Online. My Appliccation is Online. Please Help Me. Thanks & regards Sanket Patil

.

Hello Alok Sharma Ji, Thanks Once Again For The Reply. What I Have Done In My Code Is Here.

ALLEXE = new PayrollSoft.Report.AllowanceExempt();

                tblinfo = new TableLogOnInfo();
                foreach (Table Atbl in ALLEXE.Database.Tables)
                {
                    tblinfo = Atbl.LogOnInfo;
                    tblinfo.ConnectionInfo.ServerName = objcon.GetServerName();
                    tblinfo.ConnectionInfo.DatabaseName = objcon.GetDatabaseName();
                    tblinfo.ConnectionInfo.UserID = objcon.GetUserId();
                    tblinfo.ConnectionInfo.Password = objcon.GetPassword();
                    if (objcon.GetTrustedConnection().ToUpper().Equals("YES"))
                        tblinfo.ConnectionInfo.IntegratedSecurity = true;
                    else
                        tblinfo.ConnectionInfo.IntegratedSecurity = false;
                    Atbl.ApplyLogOnInfo(tblinfo);
                }

                ALLEXE.RecordSelectionFormula = "{ALLOW\_EXEMPT.IA\_CM\_CODE}= " + Masters.MainMaster.CMPID + " AND {ALLOW\_EXEMPT.IA\_YEAR}=" + cmbYear.Text.Remove(4, 1) + " AND {ALLOW\_EXEMPT.IA\_DELETE}=false " + Query;
                StrCompanyName = objcon.GetColumn("Select CM\_COMP\_NAME from COMPANY\_SETTING WHERE CM\_COMP\_ID=" + Masters.MainMaster.CMPID + "");
                ALLEXE.SetParameterValue("companyname", StrCompanyName);
                crystalReportViewer2.ReportSource = ALLEXE;
                this.Show();

Hope This Is The Right Way to Provide Logon Information To Report. Thanks & Regards Pankaj Patil.

.

Hi Alok Sharmaji, Thanks For Your Reply. But Let me know what type of lil bit of code will help me. If you have please send me an sample code. Please help me. Thanks & Regards Sanket Patil.

.

Hi Everybody, Please help me to solve my problem. I am developing an window application in C#, in that I have designed some crystal report. All this crystal reports are running properly on my development machine. But When deployed at client machine, whenever the user views the report it ask for login name and password. I have given logon information through my code using TableLogInfo. But still While viewing the report, it asks for Login name and password. Please Provide Me The Better Solution You Have. Thanks & Regards Sanket Patil.

.

Hi Abhinav s, Thanks for your reply But I am Not Getting The Solution if its night shift. Thanks And Regards Sanket Patil

.

Hi Perter_in_2780, Thanks for Your Reply. But Still I am getting Incorrect Result. I have only Time. When I convert the Out Time in datetime Then Both the Time that is employees out time and shift out time has default date as todays date and if the Emd Time Of Employee is 12:00 AM and Shift Out Time ois 6:00 PM Then Iam Getting the Result is 17.00 in TimeSpan. Which I dont want. I want Result as 6:00. Iam unable to calculate time difference in case when time is from PM to AM. Thanks & Regards Sanket Patil

.

Hi To All, Please help me to solve my problem. I am A Window Application developer. I am Developing a Attendance Calculation Software. I have InTime And OutTime of Employee's. Every Thing is Working fine. The Only thing That I Cannot Calculate is OT i.e. OverTime of Employee. I am not getting The exact Result. I have shift time like 9:00 AM To 6:00 PM. I am Unable to calculate the OT if Employees Shift Ends On Next Day. For Example : If Shift End Time Is 6:00 PM And Employee Shift Ends At 12:00 AM Or After 12:00 AM Then It Gives Me Incorrect Answer. I am Unable to Resolve This Problem. Please Help Me. Thanks & Regards Sanket Patil.

.

Hi To All......! Please Help Me To Solve My Problem. I Have Developed A Payroll Software. Here I've Excel Sheet With Employee Information With Their Salary Structure. What I am Doing Is I have Designed One Form Where I Make User To Select Excel Sheet And Then Transfer The Data From Excel Sheet To My Data Base. It Is Working Fine Without An Error. The Only Problem I Have Is I am Unable To Show Progress Bar While Transferring Data. I Have Written All The Code In A Class File And On Button Click Of My Form I Have Call The Function Of That Class. Please Help Me........! Thanks & Regards Sanket Patil

.

Hi Abhinav, Thanks for the reply. But The Problem is My Report Works Properly on Windows7 and not on Windows XP. I ahve only one database attached to my machine and copy of this database is also attached to another machine. This means database is same data is also same only when i change OS windows7 to Windows XP Report Throws an exception. thanks and regards Sanket.Patil

.

Hi......... Please help me to solve my problem. I have developed one software in VS2008. It is being installed at client site. The problem I encounter is regarding crystal Report in that project. All my reports are working properly except one. This One is running properly on Windows7 but not on Windows XP. It gives an error as "Unhandled Exception Occured At Your System." at Runtime. While Debugging it on Windows XP it Shows Error as "Invalid Table Number." Thanks And Regards Sanket.Patil

.

Hello Everybody........! I've one problem. Please Help. I have developed my project in VS2008. Noe it is to the final stage of completion. My All Crystal Reports are running properly. The Only Problem I've is I need to run two crystal reports using single CrystalReportViewer. So Please Tell me is it possible? If yes, How? Thanks & Regards Pankaj Patil

.

Hi Richard, Thanks a lot for your help. The good news is i found the solution but not satisfied. Still the solution for now is best.Instead of getting result in "dd/MMM/yyyy" i am getting the result as "d/MM/yyyy". The Code I used for this is as Follows:- Previous Code :-

private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
cmbFinacialYear.DataSource = null;
cmbFinacialYear.DataSource = (from n in logUserDc.mas_COMPANies where n.CM_COMP_ID == Convert.ToInt32(cmbCompanyName.SelectedValue) orderby n.CM_CODE descending select new { Sdate = " From : " + n.CM_ST_DATE + " - To : " + n.CM_END_DATE, Code = n.CM_CODE });
cmbFinacialYear.DisplayMember = "Sdate";
cmbFinacialYear.ValueMember = "Code";
cmbFinacialYear.SelectedIndex = -1;
}
catch (Exception ex)
{
objcon.WriteLog("Login Master", "btnLogin_Click", ex);
}
}

And The Code I Made Changes is :-

private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
cmbFinacialYear.DataSource = null;
cmbFinacialYear.DataSource = (from n in logUserDc.mas_COMPANies where n.CM_COMP_ID == Convert.ToInt32(cmbCompanyName.SelectedValue) orderby n.CM_CODE descending select new { Sdate = " From : " + n.CM_ST_DATE.Day + "/" + n.CM_ST_DATE.Month + "/" + n.CM_ST_DATE.Year + " - To : " + n.CM_END_DATE.Day + "/" + n.CM_END_DATE.Month + "/" + n.CM_END_DATE.Year, Code = n.CM_CODE });
cmbFinacialYear.DisplayMember = "Sdate";
cmbFinacialYear.ValueMember = "Code";
cmbFinacialYear.SelectedIndex = -1;
}
catch (Exception ex)
{
objcon.WriteLog("Login Master", "btnLogin_Click", ex);
}
}

Hope You will be satisfy From this. Thanks For Help Thanks & Regards -- --- ---- Sanket. Patil

.

Hi J4amieC, Here is my code to review :-

private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
cmbFinacialYear.DataSource = null;
cmbFinacialYear.DataSource = (from n in logUserDc.mas_COMPANies where n.CM_COMP_ID == Convert.ToInt32(cmbCompanyName.SelectedValue) orderby n.CM_CODE descending select new { Sdate = " From : " + n.CM_ST_DATE + " - To : " + n.CM_END_DATE, Code = n.CM_CODE });
cmbFinacialYear.DisplayMember = "Sdate";
cmbFinacialYear.ValueMember = "Code";
cmbFinacialYear.SelectedIndex = -1;
}
catch (Exception ex)
{
objcon.WriteLog("Login Master", "btnLogin_Click", ex);
}
}

Hope you will find the better Solution From these. Thanks for the Help.... Thanks & Regards -- --- ---- Sanket Patil.

.

Hi Richard, Here is my Code to Review :-

private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
cmbFinacialYear.DataSource = null;
cmbFinacialYear.DataSource = (from n in logUserDc.mas_COMPANies where n.CM_COMP_ID == Convert.ToInt32(cmbCompanyName.SelectedValue) orderby n.CM_CODE descending select new { Sdate = " From : " + n.CM_ST_DATE + " - To : " + n.CM_END_DATE, Code = n.CM_CODE });
cmbFinacialYear.DisplayMember = "Sdate";
cmbFinacialYear.ValueMember = "Code";
cmbFinacialYear.SelectedIndex = -1;
}
catch (Exception ex)
{
objcon.WriteLog("Login Master", "btnLogin_Click", ex);
}
}

Hope You will get better Solution From These. Thanks For Help..... Thanks & Regard -- --- ---- Sanket Patil

.

Hi Richard, Thanks For Your Reply. But It doesn't work. It shows me the error as follows : " Could not translate expression 'Format("dd/MMM/yyyy", Convert(n.CM_END_DATE))' into SQL and could not treat it as a local expression." Please Reply me if you have any other option. Thanks once again for your reply. Thanks & Regards -- --- ---- Sanket Patil

.