|
<blockquote class="FQ"><div class="FQA">myventsi wrote:</div>create a table </blockquote>
The first thing to do is to open a connection to the database.
Using that connection, you create your table. See http://www.w3schools.com/sql/sql_create_table.asp[^] for how to do that using SQL.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns
Help humanity, join the CodeProject grid computing team here
|
|
|
|
|
hi im doing a small project for friend.. i need to get the data out of xml so that i can verify the username and password
xml is like this
PLEASE HELP THE ERROR I GET IS EXPLAINED IN THE MIDDLE.. THANKS ALOTTTT
<clientlogind>
<client username="faizych">
Password="pass"
/>
<client username="taha89">
Password="pass78"
/>
and to get the value im doing
private void button1_Click(object sender, EventArgs e)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("path.xml");
System.Xml.XmlNodeList client;
XmlNode clientNode = xmldoc.DocumentElement;
client = clientNode.SelectNodes("Client");
string Usernamttext = txtUsername.Text;
string passwordtext = txtpassword.Text;
foreach (XmlNode DataNode in client)
{
string userid;
string password;
************************************************************************************************
******* ERROR HERE*** now when i run it it gives me an error when it gets to the line below that """object reference not set to an instance of an object"""
*************************************************************************************************
userid = DataNode.SelectSingleNode("Username").InnerText.Trim();
password = DataNode.SelectSingleNode("password").InnerText.Trim();
if (string.Compare(Usernamttext, userid) == 0)
{
if (string.Compare(passwordtext, password) == 0)
{
break;
UserProfile UserProfileForm = new UserProfile();
UserProfileForm.usernamevalue = userid;
UserProfileForm.Show();
this.Close();
}
else
{
MessageBox.Show("Invalid Username or password");
}
}
}
}
|
|
|
|
|
No pre tags, no formatting all equal to fail.
|
|
|
|
|
It's hard to tell without the code formatted properly. Because HTML uses <> and </>tags like XML, some of your code is also being swallowed!
A quick look at the source and it maybe that in the XML you're using username and in your code you're using Username
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
DaveyM69 wrote: in the XML you're using username and in your code you're using Username
Or in the XML he is using Password, but in the code he's using password.
This might have been useful if I'd replied to the OP, instead of you.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
this is right way
XmlNode xmlNode;
if ((xmlNode = DataNode.SelectSingleNode("Username")) != null)
userid = xmlNode.InnerText.Trim();
else
{
MessageBox.Show("User name didn't found", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hi,
I have been searching around for a single elimination algorithm / pseudo code for tournament brackets and I haven't found a single site on it. The best I found was Wikipedia explaining single elimination. I have been reading code project articles for a while now and I know there are many experience and very knowledgeable developers here. Since this is fairly simple to code I was hoping if somebody could help me out with the code/pseudo code or an algorithm for it. I would appreciate it a lot. Looking forward to your replies.
|
|
|
|
|
After hours of trying to get it to work I finally got it working. If there is anybody that needs help on this and stumble across this let me know and I can help you out...
|
|
|
|
|
Did you post information on Tournaments anywhere?? I'd be interested to see what you did on this.
Thanks..
ed
~"Watch your thoughts; they become your words. Watch your words they become your actions.
Watch your actions; they become your habits. Watch your habits; they become your character.
Watch your character; it becomes your destiny."
-Frank Outlaw.
|
|
|
|
|
Hi Guys,
How can I implement a separator in ComboBox, such that objects of two different classes can be easily distinguised. Does it require any coding or just simple designing tactics? Please Help.....
Your help will be appreciated.....
Rajdeep.NET!
modified on Thursday, April 2, 2009 3:42 PM
|
|
|
|
|
AFAIK you can't without quite a bit of work.
You'd need to set the DrawMode to one of the OwnerDrawn modes, and handle the DrawItem event yourself to detect whatever you use as a separator and draw what you require. Making it non selectable is going to be another challenge!
I know you're a beginner in C#, this may be a little adventurous IMO until you've got to grips fully with the fundementals.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Oh my! There seems to be huge task to be accomplished . I think I have to learn how to draw graphics on Windows Forms in order to achieve this. Anyways, thanx Davey. u r very helpful!
|
|
|
|
|
I am a little confused by this.. I get it to draw the lines on the panel, but when I try to save it to a file it is blank?
Here is my panels MouseMove:
private void panelSig_MouseMove(object sender, MouseEventArgs e)
{
if (shouldPaint)
{
Graphics graphic = panelSig.CreateGraphics();
Cursor.Clip = new Rectangle(this.PointToScreen(panelSig.Location), panelSig.Size);
graphic.DrawLine(pen, lastPoint.X, lastPoint.Y, e.X, e.Y);
graphic.Dispose();
lastPoint.X = e.X;
lastPoint.Y = e.Y;
panelSig.Invalidate(new Rectangle(0, 0, panelSig.Width, panelSig.Height));
Cursor.Clip = new Rectangle(0, 0, 0, 0);
}
}
Here is the MouseDown and MouseUp:
private void panelSig_MouseDown(object sender, MouseEventArgs e)
{
shouldPaint = true;
lastPoint.X = e.X;
lastPoint.Y = e.Y;
}
private void panelSig_MouseUp(object sender, MouseEventArgs e)
{
shouldPaint = false;
}
But when I try to save it to a file it doesnt work?? I'm confused... I realy want to save it in a SQL database, but I figured I should get it to save to a file first to see.. It saves.... just the panel, not the actual lines I drew.
Here is how I am saving it:
Bitmap TestBMP = new Bitmap(panelSig.Width, panelSig.Height);
FileStream fs = new FileStream(saveFile.FileName, FileMode.Create, FileAccess.Write);
panelSig.DrawToBitmap(TestBMP, new Rectangle(0, 0, panelSig.Width, panelSig.Height));
TestBMP.Save(fs, ImageFormat.Png);
fs.Close();
|
|
|
|
|
You will also find that if you drag your window off the side of the screen then drag it back on again you will have lost the lines you have drawn too.
This is because what you draw is not stored anywhere. It is simply drawn on the surface. If the panel is invalidated the OnPaint method is called and it is redrawn, losing what ever you drew on it.
If you need to store the information you need to draw to a bitmap, then draw the bitmap onto the panel. When you come to save the information to a file (or database) you have the bitmap already.
And, by the way, your panel will have to re-draw the bitmap in the OnPaint method.
|
|
|
|
|
Well what is being drew on the panel is a signature.
So I still need each line put... how exactly would I save that to a bitmap or just do it with the OnPaint method.
|
|
|
|
|
You draw on the bitmap instead of the panel. Once it is on the bitmap you draw the bitmap to the panel.
The OnPaint method is called with the panel is invalidated or otherwise needs to be repainted. This is why you need to draw the bitmap in the OnPaint.
And one thing I didn't explain before is that you probably want to create your own class derived from Panel so that you can override the OnPaint method (otherwise you will be creating an OnPaint method in the wrong place)
If you are using these functions I would also recommend Charles Petzold's book on programming Windows with .NET.
|
|
|
|
|
Well I have a bunch of books at home... I just always skipped over the graphics part of it lol. I will go back and read those now that I see where I would use them... I got it to work.. this is what I did:
private Bitmap bmp;
MouseMove:
private void panelSig_MouseMove(object sender, MouseEventArgs e)
{
if (shouldPaint)
{
Graphics graphic = Graphics.FromImage(bmp);
Cursor.Clip = new Rectangle(this.PointToScreen(panelSig.Location), panelSig.Size);
graphic.DrawLine(pen, lastPoint.X, lastPoint.Y, e.X, e.Y);
graphic.Dispose();
lastPoint.X = e.X;
lastPoint.Y = e.Y;
panelSig.Invalidate();
Cursor.Clip = new Rectangle(0, 0, 0, 0);
}
}
OnPaint (draw the BMP on the panel)
private void panelSig_Paint(object sender, PaintEventArgs e)
{
Graphics graphic = e.Graphics;
graphic.DrawImage(bmp, 0, 0, bmp.Width, bmp.Height);
}
private void panelSig_MouseDown(object sender, MouseEventArgs e)
{
shouldPaint = true;
lastPoint.X = e.X;
lastPoint.Y = e.Y;
}
private void panelSig_MouseUp(object sender, MouseEventArgs e)
{
shouldPaint = false;
}
Seems to work great so far...
|
|
|
|
|
I want to bind an in-memory data class to a DataGridView using the DataSource member. I have read several ways of doing this and have implemented and tried several but once I set the DataSource, I then lose the ability to sort.
I want to display my data class inside of a grid. I can use a List (List < MyDataClass >, for example) which works but I lose sorting. I can get sorting back, but I have to create my row like this
<br />
object[] row = {MyDataClass.FirstName, MyDataClass.LastName};<br />
which then removes the binding to the actual objects.
I've now been trying to use DataSets and DataTables, but I still lose my binding. And the columns are not automatically generated from the exposed properties, like when I use a List collection.
My next step is to create a class implementing the IBindingList interface. Will this be what I want? Any help or advice is greatly appreciated. Thanks.
Oh, another wrench in the idea is that I want to flatten out the object. So my object may contain other objects which I want to also display in the table as part of the same row. I was thinking there was a way to bind a specific grid column to an object's property, but I haven't been able to find that yet.
|
|
|
|
|
When you say you lose the sorting on your List do you mean the ability to sort of the order you want loaded?
I use a BindingSource as the DataSource for the DGV, but the data (from a SQL select) is loaded into the List in the order I want them displayed. So the sort is done before loasing the list. Any subsequent sorting is done by the user via the DGV.
List<clsProduct> lProducts = oProd.GetRecordList(-1);<br />
dgData.DataSource = lProducts;
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
By losing the sort, I mean I can no longer sort when clicking on the column. This is just the nature of using a List or array as your datasource as they don't know how to sort per column. Also, when I say this is in-memory data, what I really mean is this is not connected to a database.
I now have things working by deriving from IBindingList and implementing the sort routines as well as adding a Comparer, but it took me awhile. I tried How To Allow To Sort By Multiple Columns in Custom Data Binding which would not compile. It is based on an article from MSDN. So I fixed up the code to be like the MSDN article and, though it would compile, I still could not sort on my columns.
I ended up having to use a sample in the MSDN Library for an IBindingList interface. But even THAT example does not show how to sort. So I took the necessary bits I needed from Implementing a strongly typed collection with sort/filter/GetChanges features and finally got things working.
|
|
|
|
|
That sounds like an article to me. 
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
You are probably correct. I have now spent more time with things and have things working pretty well. I think I have the solution I was looking for.
|
|
|
|
|
Hi All
I have three forms in my application Form1 (main form), Form2 and Form3.
Is there any easy way to call method or event which is on Form1 from Form3.In my application there is a method in form1 which is showing records on ListView of Form1 from a file.
In Form3 I am adding two records in the file and after that form3 and form2(which is intermediatery form) both are closed and Form1 becomes the active form.Now I want to call a method or event so that two records are added to the ListView without calling Page load.
I can not declare that method/event as public due to security reason.
protected internal is okay.
Searching on the net confused me and i did not understood anything.
Please guide.
Thanks
Regards
The SK
|
|
|
|
|
Sandeep Kalra wrote: Is there any easy way to call method or event which is on Form1 from Form3
Yes. It is essentially the same as passing a value (a property is just syntactic sugar for a get and set method). Passing Values between Forms with C# and VB.NET examples[^]
Sandeep Kalra wrote: Page load.
Page? Is this a web application?
Sandeep Kalra wrote: I can not declare that method/event as public due to security reason.
protected internal is okay.
The accessor levels of methods has nothing to do with security. If you want security you might want to look into areas such as CAS (Code Access Security). If someone wants to to call your method then they can do so quite easily using reflection. So, making something private, protected or internal has zero security associated with it.
Sandeep Kalra wrote: Searching on the net confused me and i did not understood anything.
Then this may turn into a conversation.
|
|
|
|
|
1.Yes. It is essentially the same as passing a value (a property is just syntactic sugar for a get and set method). Passing Values between Forms with C# and VB.NET examples[^]
I have studied above topic but I do not have to pass values.
2. Page? Is this a web application?
Its a windows based application.
3.The accessor levels of methods has nothing to do with security. If you want security you might want to look into areas such as CAS (Code Access Security). If someone wants to to call your method then they can do so quite easily using reflection. So, making something private, protected or internal has zero security associated with it.
I did not knew about that.So Is this mean that I have to use CAS to improve security of my application.
Please guide
Thanks
Regards
THE SK
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
