Re: Serializable objects into Entity Framework - C# Discussion Boards

Re: Serializable objects into Entity Framework

19-Feb-15 12:55

If you're saying that you have some (entity) class definitions and want to know how to derive a database from them, then look at the Entity Framework "Code First" (versus the database / model first) approach, which can generate an SQL Server database from "code".

Message Removed

19-Feb-15 16:53

N_tro_P

19-Feb-15 16:53

Message Removed

Gerry Schmitz19-Feb-15 17:59

Re: Serializable objects into Entity Framework

19-Feb-15 17:59

Here's a link that may help:

https://msdn.microsoft.com/en-ca/data/jj679962.aspx

You may only need to some minimal refactoring to indicate parent and child relationship.

Message Removed

23-Feb-15 3:55

N_tro_P

23-Feb-15 3:55

Message Removed

Gerry Schmitz23-Feb-15 5:31

How to run a javascript function from a website on C# Program

23-Feb-15 5:31

I don't know what you mean when you say "... EF does not want the whole object but the ID only have the objects.".

EF will generate a primary key for a property that is or ends in "ID".

A relation is simply a statement such as:

public IList<Order> Orders { get; set; }

EF will create (entity model) relationships using the above "ID's" and "relation" statements.

I haven't used "xsd2Code" but when I paste "layered XML" in Visual Studio using Edit | Paste Special | Paste XML as classes, all the "layers" are converted to classes and a corresponding "relation" statement.

I've used the above to generate classes into which XML from 3rd-party web services was de-serialized; with no refactoring needed.

jairomarcel19-Feb-15 0:47

jairomarcel

19-Feb-15 0:47

Hi there. I'm having a problem to create a program to get information from a website. First thing that I did was to put the login information with a HtmlElement, first I get the element with GetElementById and then I set the attribute, for click on login I get the element by button name and then I invokeMember("click"). It works fine but the problem is after this, the buttons are all in this way:

<img src="_imagens/sistemas/fig_PROJETOS_large.gif" onclick="sistema('PROJETOS','Acompanhamento de Projetos')" alt="Acompanhamento de Projetos" border="0">

So it does not have an ID, it is just calling the javascript function sistema that has some arguments. My question is, how I can run this button from a c# program since I can't found it by ID and then do a InvokeMember to click in this button? I tried to use webBrowser.Document.InvokeScript and others way but nothing worked to me.

Thanks for now. Thumbs Up | :thumbsup:

manage network printers

Blue_Boy18-Feb-15 23:19

Blue_Boy

18-Feb-15 23:19

How can I manage printers on network, getting their status, ink level, if any printer have any problem then getting problem description,enable/disable printing on specific printer,etc.

All these I need to manage programmatically.

Regards

I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.

Re: manage network printers

Mycroft Holmes19-Feb-15 0:33

Mycroft Holmes

19-Feb-15 0:33

I would think that would be determined by the api the printer publishes.

Never underestimate the power of human stupidity
RAH

Re: manage network printers

Gerry Schmitz20-Feb-15 13:05

Re: manage network printers

20-Feb-15 13:05

Check out the System.Printing.PrintQueue and PrintSystemJobInfo classes.

The actual status information you get back for a given printer will depend on how well a given printer (driver) integrates with Windows.

(If a particular printer has "poor" Windows support, you will need to have access to the printer driver API; usually via a custom .NET dll supplied by the vendor, when available).

Mohammad Reza Valadkhani21-Feb-15 1:53

Mohammad Reza Valadkhani

21-Feb-15 1:53

if your printer is connected directly to the network and support SNMP you can talk to your network printer and get what you want from him! i recommend you check SNMP feature of your printer ( if they have it !)

textbox63 stays empty

masterofc18-Feb-15 23:08

masterofc

18-Feb-15 23:08

hii i was wundering. why my textbox keeps staying empty? i hope someone could tel me how ti fix it, my code stays below:

private void Form1_Load(object sender, EventArgs e)
{
    // TODO: This line of code loads data into the 'klantenbestandDataSet4.Logo' table. You can move, or remove it, as needed.
    this.logoTableAdapter.Fill(this.klantenbestandDataSet4.Logo);
    // TODO: This line of code loads data into the 'klantenbestandDataSet3.Producten' table. You can move, or remove it, as needed.
    this.productenTableAdapter.Fill(this.klantenbestandDataSet3.Producten);
    // TODO: This line of code loads data into the 'klantenbestandDataSet1.OrderWerkzaamheden' table. You can move, or remove it, as needed.
    //this.orderWerkzaamhedenTableAdapter.Fill(this.klantenbestandDataSet1.OrderWerkzaamheden);
    // TODO: This line of code loads data into the 'klantenbestandDataSet2.Werkzaamheden' table. You can move, or remove it, as needed.
    this.werkzaamhedenTableAdapter1.Fill(this.klantenbestandDataSet2.Werkzaamheden);
    // TODO: This line of code loads data into the 'klantenbestandDataSet1.Werkzaamheden' table. You can move, or remove it, as needed.
    //this.werkzaamhedenTableAdapter.Fill(this.klantenbestandDataSet1.Werkzaamheden);
    // TODO: This line of code loads data into the 'klantenbestandDataSet1.Klanten' table. You can move, or remove it, as needed.
    this.klantenTableAdapter.Fill(this.klantenbestandDataSet1.Klanten);
    //cn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\klantenbestand.mdb"; //goed
    cn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Master of Disaster\Documents\klantenbestand.mdb"; //goed
    cmd.Connection = cn;

    // hier worden de methodes aangeroepen  de gegevens laden onder instellingen.
    werkzaamhedenwijzigenonderinstellingen();
    productenwijzigenonderinstellingen();

    //hier worden de methode aangeroepen voor het laden van het pad van het gebruikte logo
    PlaatsenLogo();

    //Hier zet hij het plaatje neer als logo
    //textBox63.Text=@"C:\Users\Master of Disaster\Pictures\wendy\beeldschoon.png";
    pictureBox1.ImageLocation = textBox63.Text;
    //pictureBox1.ImageLocation = @"C:\Users\Master of Disaster\Pictures\wendy\beeldschoon.png"; //---> werkt

    // Hide the tab page
    tabControl1.TabPages.Remove(tabPage6);
}

private void PlaatsenLogo()
{
    // Hier wordt de connectie gemaakt.
    try
    {
        string q = "SELECT LogoPad from Logo WHERE PadId=1";
        //string q = "SELECT Kolomnaam " + Environment.NewLine + "INTO [ExcelTabbladNaam] IN '' [Excel 8.0;Database=" + Environment.CurrentDirectory  + "\\\\Klanten.xls]" + Environment.NewLine + "FROM Klanten"; //goed
        //string q = "SELECT Kolomnaam " + "\n" + "INTO [ExcelTabbladNaam] IN '' [Excel 8.0;Database="C:\Klanten.xls]"" + ""\n"" + "FROM BronTabelnaam";
        cmd.CommandText = q;
        cn.Open();
        dr = cmd.ExecuteReader();
        if (dr.HasRows)
        {
            DataTable dt = new DataTable();
            dt.Load(dr);
            dataGridView18.DataSource = dt;

        }
    }
    catch (Exception e)
    {
        cn.Close();
        MessageBox.Show(e.Message.ToString());
    }
    cn.Close();
}

private void dataGridView18_SelectionChanged(object sender, EventArgs e)
{
    if (dataGridView18.SelectedRows.Count > 0)
    {
        DataGridViewRow dr = dataGridView18.SelectedRows[0];
        textBox63.Text = dr.Cells[0].Value.ToString(); // pad

    }
}

HOWEVER pictureBox1.Location=textbox63.text gives an empty result because textbox63.Text is emply but when i run my application textbox63.text isn't empy so why is this not working ???

OriginalGriff18-Feb-15 23:16

18-Feb-15 23:16

dataGridView18
textBox63

Oh dear, oh dear, oh dear...
That implies that your one form as at least 18 data grids, and 63 text boxes. Tell me, would you like to sit down in front of that and use it every day? Why not? Because you can't find anything you are looking for? I certainly couldn't... Break it up, show a limited number of controls, and don't flood the user with info: it just confuses people.

Secondly, please stop using VS default names for controls. You may remember today what textBox47 contains, but will you in 3 months time when you have to maintain this? Use sensible names that describe the purpose of the control: it makes your code more self documenting, easier to read, and more reliable.

And third, what makes you think you have put a value in the textbox? The only code you show that refers to it will only do anything at all when the selection of the right datagridview changes. Did you use the debugger to check that the code was executed?

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

masterofc18-Feb-15 23:28

masterofc

18-Feb-15 23:28

the code is running because when i run the program with f5 textbox63 shows C:\Users\Master of Disaster\Pictures\wendy\beeldschoon.png. the point is i putted the location of an image into a database so that when i canged the picturebox and closed the application the settings are still saved when i re-open the application

OriginalGriff18-Feb-15 23:30

18-Feb-15 23:30

Then you need to show us any code that actually does that, because the code you show certainly doesn't!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Hep me to create signup windows app

masterofc19-Feb-15 0:28

masterofc

19-Feb-15 0:28

THNXX!! it works now !! the problem seems to be that the tabpage wasn't vissible.

Member 1141361218-Feb-15 22:49

Member 11413612

18-Feb-15 22:49

Hello,
I have html source code of a page from that source code i want to make signup windows application in c#

Source :

<!DOCTYPE html>
<html>
<head>
<title>MAD</title>
</head>
<body>
<form action='http://register.abc.com/register' method='post' id='cI' enctype='text/plain'>

<input name='s' value="" type='hidden'/>
<input name='did' value='MIDP' type='hidden'/>
<input name='pid' value='abc' type='hidden'/>
<input name='cid' value='abc' type='hidden'/>
<input name='l' value='en' type='hidden'/>

<p>
<b>USERNAME</b><br>
<input name='un' value=''/>
</p><p>
<b>PASSWORD</b><br>
<input name='pw' value='password'/>
</p><p>
<img id="CAPTCHA" src="" /> <input type="button" id="regen" value="REFRESH CAPTCHA" />
</p><p>
<b>CAPTCHA</b><br/>
<input name='c' >
<br/><br/>
<input name='send' value=' CREATE ' type='submit'>
</p>
</form>

<script type="text/javascript">
var dids = ["MIDP","ANDROID","WINDOWS","BlackBerry","SYMBIAN","MAC","WP","LINUX","IPHONE","WM"];
var curdid = 0;

function createCaptcha()
{
var chars ="0123456789ABCDEFGHIJKLMNOPQRSTUVWXTZ"
+ "abcdefghiklmnopqrstuvwxyz";
var str = "";
for (var i=0; i<10; i++)
{
str += chars[ Math.floor( Math.random() * chars.length ) ];
}
var form = document.getElementById("cI");
form.s.value = str;
document.getElementById("CAPTCHA").src =
'http://register.abc.com/init?w=120&h=40&f=png&s=' + str;

form.did.value = dids[curdid];
curdid = ( curdid + 1 ) % dids.length;
}

// generate initial CAPTCHA strings:
createCaptcha( );

document.getElementById("regen").onclick = createCaptcha;
</script>
</body>
</html>

I must do parse html in c# i think ?
I dont know actually how to start
Please help ... Smile | :)

Re: Hep me to create signup windows app

OriginalGriff18-Feb-15 23:09

Re: Hep me to create signup windows app

18-Feb-15 23:09

Member 11413612 wrote:
I must do parse html in c# i think ?

No, that would be a very odd way to do things.

Just because you have found a solution on the internet, doesn't mean it's the right solution: and HTML / Javascript code for a website (especially as poor as that is) does not translate well into a WinForms or WPF application. That's like assuming that the first car door you find when you walk into a car breakers will do to replace the front door of your house!

Stop, sit down, look at your task, and try to work out what to do for yourself instead of hunting for a "quick fix" for your homework on the internet. It really will be a lot easier!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Pete O'Hanlon18-Feb-15 23:27

Pete O'Hanlon

18-Feb-15 23:27

Are you writing a Windows Forms or a WPF application? What you are looking at writing is normally called a Login dialog, so you need to search for a Login dialog using the appropriate technology (e.g., google for wpf login dialog).

about dynamic form and controls, database fields created by user throw c sharp .net windows application

Muthuraj.M18-Feb-15 18:35

Muthuraj.M

18-Feb-15 18:35

Hi friends,
i need to know if any possibilities to get controls like drag and drop and form creation and fields must be created regarding the controls created by user.
and storing retrieving values from database is that possible if any other ideas about this project link reference pls guide me

Re: about dynamic form and controls, database fields created by user throw c sharp .net windows application

OriginalGriff18-Feb-15 21:44