Comments by Sarath kumar.N (Top 98 by date)

you can do it using jquery

Thanks for ur info.

No one using the database externally. 250+ applications using the same database at same time.

Consuming web service is the only concern here. Because webservice is platform,language, database independent. once you have successfully consumed webservice then you can easily interact with any database.

can u share your table details?

Pls accept the solution

Give 10 min. I will be with solution.Thanks!

without knowing the structure how can I write the code for you? You have to mention structure of 1st table. Then what do you want display in a second table. that will be easier to help you even others.

You are talking about current view of the webpage or entire page?

Any idea about height of the image?

Once you got the values from one table try create data table. After creating data table you can use use it anywhere.

Searching from where? where u want to display(label,Table, etc)?

Anyway in that i included both versions. Did u tried

https://onedrive.live.com/redir?resid=EB5A2B7F9D52B1C5!2487&authkey=!AFKpWtqB5tdK-Uk&ithint=folder%2c download this and install.

your system 32/64 bit?

This error is only because of the above I mentioned. I will share another link.I'm this will help u.

https://www.microsoft.com/en-in/download/details.aspx?id=23734 try to install this..

Did u restarted the system?

Please explain ur scenario that will help others. If u want insert multiple rows means u can use sqlbulkcopy. actually ur code is not giving any clue. why u r not using simple query instead of this query?

Did u tried below solution?

Did u googled ?

Actually you have written a query for inserting multiple records right?

http://stackoverflow.com/questions/3128204/how-detect-caller-id-from-phone-line

http://stackoverflow.com/questions/1200921/how-to-get-caller-id-in-c

Please refer the below links for some knowledge.

https://social.msdn.microsoft.com/Forums/vstudio/en-US/a47f41f1-a61b-4a41-9729-c0254b39a663/voip-caller-id-c?forum=csharpgeneral

Getting the Caller ID is based on how they getting call? what they are using?

What SQL query actually you have written?

Then you have to enter the caller Id manually. Then other thinks are very easy.

That's not possible unless they willing to give. I think that software is third party application, so we can't expect the caller ID from that site. Without the Caller Id how can u save and search the info on DB?

How will u get the caller ID from that software ?

Can you please give more info?

At least post some code.

What u mean by all forms ? Can u please explain ur situation a little bit clear?

Please visit the following link.http://stackoverflow.com/questions/6090913/make-an-installation-program-for-c-sharp-applications-and-include-net-framework

ask it in discussion please!

That's great!!!

What doesn't exist? what about the first link?

Before that u can install that template via visual studio gallery. https://visualstudiogallery.msdn.microsoft.com/003f3135-bbca-4eb2-951d-88820065a124

If u succeed please accept the solution.Thanks.

You are Welcome! Thanks doesn't matter u have to succeed that's the matter! I'm waiting for ur reply!

No problem it's very easy. Just wait few more sec I will give a links.

you want create a setup for a application right? Then I can help you!

If u want create installer u can use oneclick publish in visual studio

From the error message u have given. There is already a higher version running on the system.Please uninstall the version and try again.

Sending mail to various places ? Please give more detail. What type of application ? What is the purpose? What is the problem situation

Is it working Now ? If yes please accept the solution.

No problem just install Database access engine.

Did u tried? If yes, what error u are getting?

What are the steps u tried? Where u getting the error ? Please in detail

Which database u are using ?

Hi! Thanks for your reply! I have done a mistake in a file.Now I changed that. It's working fine!

You mentioned a script from Microsoft. I tried to run that. But that is not showing anything. Scripts automatically closing after open.

This application for an company. they own more than 1000 systems. If I got the results from power shell script how can I use that in my app? pls suggest

Yeah, I want know how many systems current online? If online who is the current user?

One winForm application running in windows server machine. That will collect the currently connected user with server. That application looks for change at every 2 mins.

Dear Mathew,
Thanks for your reply. Actually, I got some examples about getting the user name and email and other details from AD.
I just really want the login, logout and lock timings. Is there any way for getting those details.

Dear Arkadeep,
Thanks for your reply, I'm actually new this area. I'm very poor in network related things. Can u please answer little more details. ?

Check the below example. That may help you. If you have any doubt post a comment. I'm also suffered for the same issue while I'm doing my college project! All the best.

Yeah I tried that step. The sample values are
desc="Samsung Laptop"
CurrentLoaction="Bodhi"
NewLocation="ODC1"
MovedBy="Sarath,Kumar"
RequestedBy="Kamal"
ApprovedBy="Guna,Sekar"
DateOfMove={04-06-2015 PM 1:13:01}

This is winform application.

Yeah I changed the path value from ReportVendor.rdlc to ReportAssetList.rdlc, But report viewer showing blank. It showing Nothing.

I have one report viewer, but I have multiple reports. I need change the report as per the client input. For example client click for Assets detail. I need to bind the AssetDetail.rdlc report at runtime. I have written a code for that, but it's not working..

Hi, thanks for your response.I know how to bind the data with the report, but the problem is while binding the data it'll automatically generate one code in form load. In my case

this.assetsTableAdapter.Fill(this.dataSetAssetsG.Assets); this is the code. But I already binded the data with datagridview. So the same code generated that time itself. If I tried to bind the data with report. It's not working.

Hi, thanks for your response.I know how to bind the data with the report, but the problem is while binding the data it'll automatically generate one code in form load. In my case

this.assetsTableAdapter.Fill(this.dataSetAssetsG.Assets); this is the code. But I already binded the data with datagridview. So the same code generated that time itself. If I tried to bind the data with report. It's not working.

Sorry for my fault. Actually, the image is already in picturebox. I just need to convert that image into byte array. Thanks.

Could you rewrite my code?

Can u rewrite my code?

Thanks Chill60, I installed on my second system copied that Microsoft.ReportingServices.targets. Now it's working fine.

Actually, I have another system, but that doesn't have any files that related to visual studio.

Which file or folder I need to copy from the other system?

I already installed and restarted the visual studio. The problem still exists.

Error 1 The "Microsoft.Reporting.RdlCompile" task could not be loaded from the assembly Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a. Confirm that the <usingtask> declaration is correct, that the assembly and all its dependencies are available, and that the task contains a public class that implements Microsoft.Build.Framework.ITask. AMS

Yeah, I understood. What is the solution for that?

Yeah, I tried to change that from version 9 to 10. But that also showing another error.

Hi OriginalGriff,

While testing I'm inserting only the numeric value.

Hi OriginalGriff,

The line of error is "serialNo = Convert.ToInt32(textBoxSerialNo.Text);"

SerialNumber data type in Access DB is Number.

serialNo = Convert.ToInt32(textBoxSerialNo.Text);

Picture.

If i select any image from computer for saving it in DB. It throwing "An INSERT INTO query cannot contain a multi-valued field."

Data type for the picture in DB is Attachment.
If i select the image, the value comes imgArray = {byte[879361]}

Dear Maciej Los,

There is one picture box there. If i select any image from computer for saving it in DB. It throwing "An INSERT INTO query cannot contain a multi-valued field."

Data type for the picture in DB is Attachment.
If i select the image, the value comes imgArray = {byte[879361]}

Hi Rajeesh,
Picture column name data type in Access is Attachment.

Dear Maciej Los,
I used the same query insert the details in different form, but that's working fine. I don't know why it's throwing error.

Hi Rajeesh,
That also I checked every variable holding the correct value only. When it comes to the executing the query throws the exception.

I have checked using the break points. It's coming upto cmd.ExcuteNonQuery(); After that it automatically throws the exception. I can't find the exact error line.

I have checked using the break points. It's coming upto cmd.ExcuteNonQuery(); After that it automatically throws the exception.

Dear Rajeesh,
I have checked using the break points. It's coming upto cmd.ExcuteNonQuery(); After that it automatically throws the exception.

I restarted visual studio, it's working fine thanks.

Hi OriginalGriff,

Thanks for your help. I changed that, but it now throws another exception "Overflow".

Please help me with this.

Hi, thanks for your time.
Actually phNo, pCode are 'number' data type in database.

Try to save the session. It may help you.

same exception. finally i removed id but remaining FaultException was unhandled. Why it was?

I handled the exception using following code but the problem still remaining. help me pls.
try
{
id += 1;// Convert.ToInt32(textBoxId.Text);
pwd = Convert.ToString(textBoxPwd.Text);
name = Convert.ToString(textBoxName.Text);
age = Convert.ToInt32(textBoxAge.Text);

radioBtnMale.IsChecked = false;
if (radioBtnMale.IsChecked == true)
{
gender = "Male";
}
else
gender = "Female";
place = Convert.ToString(textBoxPlace.Text);
country = Convert.ToString(textBoxCountry.Text);
}
catch(FaultException FaultEx)
{
MessageBox.Show(FaultEx.Message);
}