|
Hi all,
Can any one advice me on how to implement webservices in Copying one database tables in to the another one?The source and destination databases have the same table structures but different data.The also run within the same network on diffrent server.
Any ideas will be much appreciated.
Many thanks
|
|
|
|
|
Just pass the data in through a webservice method and copy it into the DB.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thank you Chris much appreciated.
I have identity columns that are Unique for each table will that not be a problem in kepping the relationships that exist between tables on the destanation database.
How can i copy keeping the identity keys in order between various tables.
Many thanks
|
|
|
|
|
It would run faster if you just make the webservice initiate the copy, and perform the actual data transfer within a stored procedure using linked servers.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
Sorry Chris ,IT sounds a great idea , Can you please elaborate that with an example?
Thanks so much.
|
|
|
|
|
Hello m8 i have done this as a part of my program last year in school... My Solution is to First convert all the data from the first database into XML then You can either transfer the XML file to the other Web Service, Parse the XML create the schema and insert the data in the other database. 
You have the option to also maybe encrypt the XML for security purposes. And what i think that is one of the advantages for this solutions is that XML is a standard that is read by many objects so this will make transfer easier. Hope this helps  reply if this help you and take care
|
|
|
|
|
Hello,
i wrote sample program for speech recognition with vista engine, some command in my dictionary,for example "start" is similar windows command.
i want to know how can i disable windows dictionary.
thanks
|
|
|
|
|
Hi,
I am implementing c#.net application. Where since form last week i am facing problem with photo effects. My requirement is, i am capturing photos using web cam then captured photos can be modified like they can change the effects like (photo shop Filter options) watercolor, oil painting, comic,Soft focus, Sketch and etc.
Now i need to apply those effects to the photos can any one please suggest me how i can solve this problem.
Regards,
Y.JeevanRao
|
|
|
|
|
This is a complex task, and requires a lot of work. I'd say, forget it. If you don't know how to start, your best bet is to buy a library, you're not going to be able to write this.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
There is a free .NET framework you can use for imaging and many other things called AForge.NET
Here's a link 
http://code.google.com/p/aforge/[^]
Here we rest... So why not make the best of it? 
|
|
|
|
|
hi
i want to know that how can i connect webcam to c# program specialy how to connect several webcams to it and please answer with full explanation because i am new in c#
thanks in advance
|
|
|
|
|
mehrdad333 wrote: because i am new in c#
thanks in advance
If you're new, how come you previously asked this:
at first excuse me because of my poor english i have written a program for sending an image or for video conference via internet with sockets and i am using tcp protocols my problem is that when i test program on my computer it works fine but when i test it over internet with between two pcs the reciver cant recieve image correctly minwhile i am using dial up
If you're really new, why are you working on such complex things ? Either way, why did you ask twice ? And how come you didn't just search the site or google in general for the many examples that exist ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
hi christian
at first abaut program that u think i asked twice:
i download a project that could connect to one webcam but i want to connect to several webcams i searched but i didnt find any example
and second abaut knowlegment:
i know c# as i created several programs but i write this down because im afraid of complex answers and i want them to answer me in a simple way .
|
|
|
|
|
hello
i am new in c# i would like to know that how can i connect to an ip camera and how to stream image or video from it please answer completely and consider that i dont know anything abaut ip camera and c#
thanks in advance
|
|
|
|
|
mehrdad333 wrote: please answer completely and consider that i dont know anything abaut ip camera and c#
If this is true, then this is a dumb task for you to attempt. Try learning some C# first before you worry about more complex tasks like this. Otherwise, you're doomed to failure, no matter what you do, you'll run against your lack of basic knowledge in trying to impliment it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i need to connect with ip camera and nvr can u give any project in c# to connect with camera. If u dont have idea about nvr lets leave, if u have ip camera project alone also send me. My mail id is r.lawrence@omeonsolutions.com
|
|
|
|
|
Hi,
I am trying to insert/update/delete a field from sql server table using dataadapter in c# windows application.
Here insert and update are happening,but 'delete' is not working
I will show my delete part :
public int UpdateAllUserDetails(DataSet dsUsers)
{
private SqlConnection connection;
private SqlCommand command;
private SqlDataAdapter dataAdapter;
connection = new SqlConnection(ConfigurationManager.AppSettings.Get("conString"));
connection.Open();
dataAdapter = new SqlDataAdapter(command);
dataAdapter.DeleteCommand = new SqlCommand("DELETE FROM UserDetails WHERE vUserName=@vUserName", connection);
dataAdapter.DeleteCommand.Parameters.Add("@vUserName", SqlDbType.VarChar, 50, "vUserName");
int ret = dataAdapter.Update(dsUsers);
return ret;
}
can somebody say what is missing here?
|
|
|
|
|
Try and run the same sql statement in your DBMS as it will tell you what if anything is wrong with your statement. My guess is that you may have some dependencies in your tables, that prevent you from deleting.
|
|
|
|
|
Thanks kstls,
But I have no dependencies for this because i am trying to delete some newly inserted userdetails data, which will create a new field in that single table only and not in any of the dependency tables.
Here by debugging the code i am getting the update command as :
"DELETE FROM UserDetails WHERE vUserName=@vUserName"
which when run directly in DBMS just replacing vUserName as 'testuser' which is the primarykey vUserName :
[ DELETE FROM UserDetails WHERE vUserName='testuser' ]
is deleting properly
But not working from code
modified on Tuesday, November 17, 2009 6:48 AM
|
|
|
|
|
Hello,
I am making one windows application in C#. I am using SQL Server as database.So, my question is I want to deploy the .exe file to the client with out installing sql server in clients system.
to do that what files I should supply to him with SetUp exe.?
If it is necessary to install SQL Server in client system how can i do? I want to install this exe in almost 100 systems.
As I am new to Windows Application, can anyone explain about it... or give some article links so I can understand the whole processfrom creating application to End User deployment.
Pinna
|
|
|
|
|
You should not need to deploy any SQL engine or code to your client systems. You should have one SQL Server to which the clients connect. They just need to have the relevant connection string.
If you are deploying this as a separate database for each user I would suggest something lighter such as SQL Server Express Edition. This for the secondary reason that the Express Edition is free whereas installing a full SQL edition on 100 machines will cost you upwards of £400,000 (gbp) that is $700,000 (usd). That is the approx going rate for an academic licence installation of SQL 2008 * 100 which is the cheapest licence available.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
If the computers all run their own local DB, then an Access DB may have been better from a deployment POV, or SQL Server Compact. As it stands, you may need to install SQL Server Express, configure a connection string and deploy your DB onto it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
hi
How to open external program from my C# program (Windows-mobile) ,
and give this external program the focus ?
thank's for any help
|
|
|
|
|
|
Not very helpful my friend.
This has been reposted a couple of times as no-one seems to know the answer. Google does throw up how to launch another application, but setting the focus is rather more difficult. I don't know how to do it on Windows Mobile, the api's are all different from Windows desktop or server, and I did a bit of checking around as well. Came up dry.
If you have some good search terms that find the answer to the activation problem maybe you could post them here. I am intrigued as to what you searched for if it is so easy to find.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
