Comments by Member 10192073 (Top 81 by date)

bool IsFileClose = CheckExcelOpen();
if (!IsFileClose)
{
Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wb = xl.Workbooks.Open(txtBrowse.Text);
wb.Close();
xl.Quit();
}

but its not closing my excel file. i want my file should be close, above check code is ok but i want close my proper excel file

in my desktop it is, by window application i am browsing excel but i want close automatically by code when i am browing

ok thanks for your support

can we join in linkedin or skype please? my skype manojkandpal192

Respected sir, I wanted to join in my Linkedin but its giving me error 404 page not found.
I would love to join in my skype manojkandpal192

thanks sir, its work fine for me

in app.config we need to add this, my window application it is

receipt is my local DB table name and there two more columns are InvoiceNo and ReceiptNo,
when I am fetching receipt from Quick books that time i need receipt number on payment by customer as well as how many invoices are adjusted through one receipt so those invoice number as well

I need like code as well two more things
Receipt.InvoiceNo = "";
Receipt.ReceiptNo = "";

two more fields i need urgently but i am not getting it in my code, i got tired to hit and try

sorry sir, but i hit and try but i could not fix it right now

ok sir, thanks but I could not fix my problem yet

ok sir, thanks but I could not fix my problem yet

sorry but, i have made a project in C# and made setup via wix but now I want to give Prerequisites like .net framework 4.6 install but its not going fine....so i need help pls

I have read it, but actually i want to debug it with break point.

[CustomAction]
public static ActionResult CA_DBCreate(Session session)
{
MessageBox.Show("Hello");
System.Diagnostics.Debugger.Launch();
i have mentioned a break point here but its not going, means break point is not hitting here so how i can debug it with break point then i want to go through the code with step by step( line by line)

i need help to write query for that

can you give me idea for my next quesion(next post) please

this is task given by my senior, now i need to design it.ok suppose you are right for Unique Constraint in Invoice "constraint uk_inv unique (InvoiceNo, InvoiceAmount)" does not makes sense.
but invoiceNo and invoicedate he wants in receipt table also as a references.will i need to design more than two tables for that

both are same sir,
in receipt it should be reference from invoice table.
that's why i am having difficulties

Actually, I have excel from tally and i want to upload in Local SQL using C# software, but client don't know which date uploaded or not,suppose he uploaded data from 6 july to 9 july but again he select 9 july data with 9 july to 12 july,so i need filter it in my C# code with SQL data.

first thing always check will take more time,
can you give me code to check column wise data in C#.
means read excel rows and column and then check?

thanks for reply, I am new on technology but my boss asked me what will you do?
case is in tally suppose 4 june 2016 had a receipt where amount should have been 10000 but client enter by mistake one more 0 and now only this particular records is updated today but there receiptno and receipt date same in tally.but it is already uploaded on same receiptNo.

how i can do it.

one more thing i want to ask there is a possibility that we can migrate data tally to SQL directly, or we need to export in excel then have to upload an excel in SQL server

only particular records want to upload there of back date........so then how we can achieve it?suppose a back date entry of march months client forget to enter in tally Invoice he enter today by manual but after exporting in excel it is stored in our local SQL but after local SQL how we enter it on cloud because already that march date data is uploaded there.

please give me just solution only for my next question, i am new on technology but my boss ask a question that http://www.codeproject.com/Questions/1111134/How-we-sync-data-into-our-cloud-server-by-using-Cs

please give me just solution only for my next question, i am new on technology but my boss ask a question that http://www.codeproject.com/Questions/1111134/How-we-sync-data-into-our-cloud-server-by-using-Cs

ya i have done it its just simple,i am a beginner on oracle so.
its
just

begin
add_newEmployee(pass the values)
end
thanks,but i need to learn parameter on that.ya i have book marked above link.
thanks again

ya its 64 bit

it shows only
PLAT="NT_AMD64

- <dep_list>
<dep name="oracle.network.aso" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.partitioning" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.sdo" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.lbac" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.numa" ver="10.1.0.1.0" plat="ALL_PLATFORMS">
<dep name="oracle.oraolap" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.ntmgmtobjs" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.dm" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.clrintg.ode_net_2" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.dv" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.rat" ver="11.2.0.1.0" plat="NT_AMD64">

in comps.xml

<dep_list>
<dep name="oracle.rdbms" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.dbjava.jdbc" ver="11.2.0.1.0" plat="NT_AMD64">

actually i want to tell you that first i had 32 bit version of window and then my 64 bit version of oracle was not installing in my computer then i format the system and reinstall 64 bit OS in my computer and then i installed oracle 64 bit in my computer.
it means my OS is 64 bit and my oracle is also 64 bit.so now why its showing the error

i found in above link is

A simple way to find this out in Windows is to run SQLPlus from your Oracle homes's bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you'll see a process on the Processes tab that looks like this:

sqlplus.exe *32
If it is 64-bit, the process will look like this:

sqlplus.exe

so in processes it looks as sqlplus.exe
it means its 64 version
now what should i do?

how we can check that my oracle is 32 bit or not?actually i have installed 64 bit oracle because my operating system was 32 bit then i had to install the window 64 bit and then i installed oracle 11 G 64 bit

like in SQL Server
Create Table tblTest
(
Field1 int not null primary key nonclustered,
Field2 varchar(30),
Field3 int null
)

i want to create a table in oracle that primary key column will be non-clustered.

its by trigger?we can not achieve this by check constraint?
please if you have exact solution via check constraint then please provide me.
i am learning constraint first then i will learn trigger.so that's why i need solution for check constraint

ok i am goint to put

ok give me solution for
check constraint on Date of birth..........
means (today-Date of birth)>= 18 years.

ok sir thanks,so it means either i have to go for 12C oracle version or by create sequences as you mentioned above.

oracle 11G and using SQL Developer

only this is a way to identity a column in oracle?
someone had given the solution like


http://www.codeproject.com/Questions/707816/How-Can-I-Set-Auto-Increment-Property-In-Oracle

but its not working for me.

your solution is right but i want another solution if possible.
like given here also

https://oracle-base.com/articles/12c/identity-columns-in-oracle-12cr1

i have improved sir,now give me solution please

give me solution of my second question please

ya actually i am using oracle but limit will be in my sql,
but your logic helped me its working fine.
in oracle it is
select sum(salary) from (select salary from employee order by salary desc)
where rownum<3;

we can do this by using temp table also like as

create table temp as select salary from(select salary from employee order by
salary desc)where rownum<=2;

select sum(salary) from temp;
drop table temp;

sir i am not able to use sql developer .it is asking me full path name when i am giving the path of java.exe and then click ok.again same window is open there.

i am new on oracle,i have successfully installed oracle 11g,but now i want to create database and tables via query but i am not seeing on the oracle when i was logging as a system.
i want to write query there?but text editor(window)i am not getting.
how we can write query there like as a SQL?

i had do that also,and after that i had uninstalled the VS2010 and again i have installed the VS2010 but my problem is still there

its not working, i have repair and reinstall the visual studio 2010 also.but still have problem

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Manoj Kandpal>devenv.exe
'devenv.exe' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Manoj Kandpal>devenv.exe /InstallVSTemplates
'devenv.exe' is not recognized as an internal or external command,
operable program or batch file.

its shows this

its not working,i had already do that

Not working

I wrote my code

Var result =from a in obj.tbl_registration.max(p=>int.parse (p.registration_id.substring (7,3))).tostring() select a

But error occur that could not translate expression

can you provide me screen shot for this?
actually i have installed driver of finger print sensor and web cam,but how to add these contorls and how to add dll for this.

there is need an application that enrolment of every employee and give finger print of every employee when he/she come and out.
means its a attendance application. i am new developer.
so i need help

thank you so much,

This Link is very helpful also

http://www.msdotnet.co.in/2012/06/how-to-create-setup-fileexe-file-from.html

my complete code is

if (frmEmployeeEnroll.ActiveForm.UseWaitCursor == true)
return;

if (this.btnvalidate.Text == "Validate")
{
string strEmployeeID = txtEmpID.Text;
fetchEmpDetails(strEmployeeID, frmlogin.string_CmpCD);
//Added below 3 lines on 02.01.2012
bool_PhotoCaptured = false;
bool_TemplatesCaptured = false;
bool_Authorised = false;
btnEnrollFp.Enabled = true;

}
else
{

initializeForm();


}

and error is coming in this line

if (frmEmployeeEnroll.ActiveForm.UseWaitCursor == true)

thanks i got it,,,,,and i resolve it but total tables and their data did not inserted right now,if i need your help then i will ask you.

thanks regards
mohan chandra

its better solution, thanks i will try that

thanks sir, i got your view,its not for user side okay sir it means we don't need to show that column in our datagridview.

but is it possible that a table can contain 2 primary key because Agent_Id is primary key in our database?

ya sir and whenever i am inserting another record then ID is assigning another Id not by deleted id,thats why my records did not look good

okay sir thanks now i will do that concept,,,but how to give uniquely id,please suggest me

can you provide me an example please,
i urgent need that concept please sir

but sir when ever i am deleting a record whose id 14 from our database,
but after deleting that record i want to maintain that Id 15 comes to 14 and so on but......it did not work sir

thanks sir it works, i was converting it tostring but did not try to get value(i).tostring();
thanks a lot sir

no sir in database there is data
means
there is my columns data where i am facing the problem

enroll_snd enroll_dt
447 10-FEB-12 11.02.16.000000 AM
449 10-FEB-12 11.02.39.000000 AM


and so on but ............whenever i using another method then it shows
like same as database table.that's why i have problem.
my sir wants that enroll_snd as "Enroll Serial No" and
enroll_dt as "Enroll Date"
so i think error in converting the type

but by using this code how we convert
the error show at line

dataGridView1.Rows[n].Cells[i].Value = dr.GetString(i);
so how i can there two columns fill completely by this but for third column it shows that error

but whenever i use in sql that time my procedure like

CREATE proc [dbo].[sp_studentreg]
@Id bigint,
@Registeration_No nvarchar(50),
@StudentName nvarchar(50),
@Address nvarchar(50),
@ContactNo numeric(18, 0),
@DateOfBirth nvarchar(50),
@Qualification nvarchar(50),
@CourseEnrolledFor nvarchar(50),
@RegisterationFees bigint,
@DateTime datetime
as
begin
if(@Id=0)
begin
insert into tbl_StudentRegisteration(Registeration_No,StudentName,Address,ContactNo,DateOfBirth,Qualification,CourseEnrolledFor,RegisterationFees,DateTime)
values(@Registeration_No,@StudentName,@Address,@ContactNo,@DateOfBirth,@Qualification,@CourseEnrolledFor,@RegisterationFees,@DateTime)
end
else
begin
update tbl_StudentRegisteration set StudentName= @StudentName,
Address= @Address,
ContactNo= @ContactNo,
DateOfBirth= @DateOfBirth,
Qualification= @Qualification,
CourseEnrolledFor= @CourseEnrolledFor,
DateTime = @DateTime
where Id =@Id
end
end
but now in oracle different window open to create proc that's why i am facing the problem where first write a procedure name then click next and so on,...............
so please tell me what should i do for like as sql2008 procedure i can write

sir actually i need in C# not in VB.

see example 3 in this link i want like as example 3 in this link

i want like this i want like this in my project
example third
http://www.xnodesystems.com/Demo/Default.aspx#id=10[^]