|
Hi,
I want to ask what is the best way to update the sql server database schema on the customers when they update the windows application.
I want when the customer update the application auto update the database schema automatically.
|
|
|
|
|
There may be tools for this but old school is to:
Create a method within you app update process that reads a script from somewhere (your update source or the database you wish to update.
Execute the script on the database from your client application.
We used to then close and reinitialise the connection.
Caveat you need to test the script 3 ways from hell to insure a clean update.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Just to add to what Mycroft said: Back the damn thing up first!
The last thing you want is to lose customer data, so either automatically back it up (See here: Backing up an SQL Database in C#[^]) or suggest that they do!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Can anyone please help me to Understand ASp.net MVC Web Api
it might be by examples or websites that i can go through
I am new on it
Thanks In Advance
Tp
|
|
|
|
|
|
I Connected My c# Code with google drive using google.apis.data assembly. But I am not able to get the newly created file from google drive. I am Doing Like this way.
var service = new DriveService(new BaseClientService.Initializer()
{
HttpClientInitializer = credential,
ApplicationName = "GDrive Connector",
});.
modified 22-Jan-15 1:03am.
|
|
|
|
|
problem solved
modified 24-Jan-15 18:30pm.
|
|
|
|
|
where you set @Name_Directo parameter value?
and also in your MappingDB2OO method you need "Id" column but I can't see in your query a column name with "Id"
|
|
|
|
|
@Name_Director is to get the value of the textbox.
But i think is impossible because a need construtor director.
I don't know if you are understanding my problem.
About mapping, is wrong ..but the problem isn't there.
|
|
|
|
|
using the following code you write.
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
using System.Data.SqlClient;
DataTable dataset = new DataTable();
dataset = Ds.DataTab("select M.*,P.Name,P.Id From Pay P Mem M where M.Id = " + Ds.TrueInt(Member.Text));
dataset = Ds.DataTab("select * from Pay where Member =" + Ds.TrueInt(Member.Text + ""));
dataset = Ds.DataTab(string.Format("select (Name+' ' + FName) as fullName from Mem where Id = '{0}'", Convert.ToInt32(Member.Text)));
NameFName.Text = dataset.Rows[0].Field<string>("fullName");
With this command you can use the SQL table at your disposal form (C #)
|
|
|
|
|
Hi,
I have C# WinForm application.
I want to export my existing registry key entries as .reg file and include in within my WinForm then make my WinForm to create the registry entries wherever I need without having to extract the .reg on the client PC.
Any suggestion please? How can I achieve this?
Technology News @ www.JassimRahma.com
|
|
|
|
|
Don't. If you need to create registry entries, use the registry functionality build into .NET already. This will require certain permissions for your application, but you would need the same permissions when attempting to apply the .reg file anyway.
|
|
|
|
|
my registry entries are in LocalMachine and Windows won't allow me to write there! I tried it before... It won't even prompt to enter the administrator password!
Technology News @ www.JassimRahma.com
|
|
|
|
|
And what do you think that a .reg file will give you?
|
|
|
|
|
so no solution?
Technology News @ www.JassimRahma.com
|
|
|
|
|
Other than putting a manifest in to request elevation to admin level for your app, no. If you could just inject .reg files, this would be a huge security hole.
The generally accepted guidance is not to use the registry. Rather, you should look to use config files.
|
|
|
|
|
IF I understood your question correctly, you can use Registry[^] class to read and write values in registry. It's up to your application where the values come from so if you decide that you read an existing file (.reg for example) then loop through it and put the values in proper places.
|
|
|
|
|
How very archaic, using the registry. As POH suggested use your own config file, you won't piss of your user by nagging him for permissions and you have complete control of the file.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
There is a solution, and it is close to your original idea.
You use the built-in functionality to read the values from the registry, write them into a .reg file (that's your code then).
For writing the data to the registry, you start a process with elevated priviledges (e.g. regedit with the filename as a parameter).
For starting a process with elevated rights from a normal .Net application, see e.g. http://chrison.net/UACElevationInManagedCodeStartingElevatedProcesses.aspx[^]
|
|
|
|
|
I wonder if someone could help. I need to code a program which simulates throwing a dice three time with random values from 1 to 6.
The output should contain the values of the dice and the probability for this combination to occur.
Am 100% new to C# so looking for some help to get started.
|
|
|
|
|
This sounds like a homework so the obvious question is, what have you tried so far?
Member 11392172 wrote: The output should contain the values of the dice
For example this[^] returns a lot of sources you can use as a starting point 
Member 11392172 wrote: probability for this combination to occur
Not sure what you mean with the combination. If you mean that 1 and 2 or 5 and 6 occur the probability would be the same. However, if you mean that what is the probability for a sum to occur (for example 9) then you have possibilities like 3&6, 4&5, 5&4, and 6&3. For example, have a look at this[^]
|
|
|
|
|
Hi and thanks for the reply. It's actually for my son but it's a long long time ago since I did any coding and not in C#
|
|
|
|
|
Well, the actual rolling of the dice involves a random number generator. What you want to do is to instantiate an instance of the Math.Random class, and use this as the base of your rolls. You want to do this away from the code that actually gets the numbers because you don't want to create a new instance each time. An example of this might be:
public sealed class Dice
{
private Random random = new Random();
public List<int> DiceRolls(int count)
{
List<int> rolls = new List<int>();
for (int i = 0; i < count; i++)
{
rolls.Add(random.Next(1,7));
}
return rolls;
}
}We do this because Random uses the system time to generate what's called a seed number. Now, if we had the instantiation of random inside the loop, chances are that you would be entering the same seed value at least some of the time.
|
|
|
|
|
Hello,
I'm working on an implementation of web-apis that return xml responses. I need to deserialize them into objects and objectlists.
I've already did it with one type of structure, but struggling on an other. When the needed xml data starts directly after the root tag then everything goes fine, but if there are some other tags in between or the structure gets more complex, then it doesn't deserialize and my list stays empty.
My question therefore is, how can i deserialize parts of xml that maybe come some tags later than the root and ignore the rest.
To give a better picture to what i want to achieve i have uploaded a small test application with testing xml files on my dropbox account for you to download: Link to test-application.
One of them works, the other one is the one that should also work.
Info: Testapp is written using: #Develop 5, C# 5 and .Net-Framework 4.5.2
Working XML:
<response>
<result first="Value 1" second="5" third="122"/>
<result first="Value 2" second="9" third="13"/>
<result first="Value 3" second="12" third="4"/>
</response>
Not working XML:
<response>
<method>something here</method>
<answer>
<result first="Value 1" second="5" third="122"/>
<result first="Value 2" second="9" third="13"/>
<result first="Value 3" second="12" third="4"/>
</answer>
</response>
The problem is, that i do not need the information <answer> and or <method> the only data that really matters is in the <result> tag. I would like to ignore the rest.
Thanks and regards
Antonio
|
|
|
|
|
When you have variable formats, I suspect that the best way is to implement your own parser, using the low-level functions in System.Xml:
1. When detecting a new tag, call a constructor for the class representing the tag, passing the XML stream to the constructor.
2. Using the low-level XML APIs, the constructor should read the entire tag, placing the XML stream's cursor at the end of the tag.
3. Repeat until all the stream has been read.
Note that a specific class constructor may do nothing but advance the cursor to the end of the tag (the equivalent of ignoring the data). However, to my knowledge there is no way of doing so without actually reading (and discarding) the data from the XML stream.
In your second example:
a. <response> - call the response constructor
a.1 <method> - call the method constructor (note that this may do nothing other than advance the cursor)
a.2 <answer> - call the answer constructor, passing the XML stream and a pointer to the response instance
a.2.1 <result> - call the result constructor, passing the XML stream and a pointer to the response instance
a.2.2 <result> - call the result constructor as above
a.2.3 <result> - call the result constructor as above
You will obviously have to define classes that match each tag. With a bit of thought, it should be possible to design classes that insert the desired data (and nothing else) into the response instance.
I have used this approach with success on multiple projects.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
