|
|
Problem Solved Thank you very much, that article saved my day bigtime.
"All of us who served in one war or another know very well that all wars are the glory and the agony of the young."
Gerald Ford
|
|
|
|
|
You are welcome 
|
|
|
|
|
Hey all,
I want to update single columns on a table. I know how to do it in SQL itself but i want to update it from inside a c# code, where i have no experience at all, i mean working with databases from C#. So far i know how to read the data from an specific table. However this code:
try
{
SqlCon = new SqlConnection(ConnString);
SqlCmd = new SqlCommand();
SqlCmd.CommandText = "select votos_recibidos from party where Name_Party ='" + party + "'";
SqlCmd.Connection = SqlCon;
SqlCon.Open();
dataReader = SqlCmd.ExecuteReader();
//reading the current value of the column
int temp = dataReader.GetInt32(0);//this is where the exception occurs
temp = temp+1;//add 1 to the current value
SqlCmd.CommandText = "update Party set Votos_recibidos ="+temp+"where Name_Party ='"+party+"'";
dataReader = SqlCmd.ExecuteReader();
dataReader.Close();
SqlCon.Close();
}
catch (SqlException SqE)
{
System.Windows.Forms.MessageBox.Show(SqE.Message);
}
But this gives me the next exception:
"Invalid attempt to read when no data is present."
But that column takes not null and it has a value of 0 first but then i manually changed to 1, just in case.
Any tip of what i am doing wrong because i know the statement has no problem itself. Maybe i am just doing it wrong in c#.
thanks,
Luis E Tineo S
|
|
|
|
|
For updates, try doing SqlCmd.ExecuteNonQuery();
You don't have to do anything with data readers when you do that.
Hogan
|
|
|
|
|
Thanks,
Let me start researching to know how to use it...
Luis E Tineo S
|
|
|
|
|
kingletas wrote: SqlCmd.CommandText = "select votos_recibidos from party where Name_Party ='" + party + "'";
Take a look this line.. What is the value for the variable called "party"?? maybe. the party name that you are looking for doesn't exist in the database that's why it return row 0.. So, it causes the error when you are accessing like that .GetInt32(0)..
|
|
|
|
|
hey Michael thanks for replying,
Party is a string representing the name of a party.
the method look like this:
public bool UpdateParty(string party)
{
....
}
It would be the same as "Select votos_recibidos from party where name_party = 'Luis Party'".
however i wondering why is throwing that exception if the table contains data, could it be the way i am passing party to the Sql Command?
Luis E Tineo S
|
|
|
|
|
Try like that..
try {<br />
SqlCon = new SqlConnection(ConnString);<br />
SqlCon.Open();<br />
<br />
SqlDataAdapter da = new SqlDataAdapter();<br />
da.SelectCommand = new SqlCommand();<br />
<br />
da.SelectCommand.CommandText = "select votos_recibidos from party where Name_Party ='" + party + "'";<br />
da.SelectCommand.Connection = SqlCon;<br />
<br />
DataSet ds = new DataSet();<br />
<br />
da.Fill(ds);<br />
<br />
if (ds.Tables.Count > 0) {<br />
if (ds.Tables[0].Rows.Count > 0) {<br />
int temp = (int)ds.Tables[0].Rows[0][0];<br />
temp = temp + 1;
<br />
SqlCmd.CommandText = "update Party set Votos_recibidos =" + temp + "where Name_Party ='" + party + "'";<br />
dataReader = SqlCmd.ExecuteReader();<br />
<br />
dataReader.Close();<br />
SqlCon.Close();<br />
}<br />
else {<br />
System.Windows.Forms.MessageBox.Show(" [ " + party + " ] doesn't exist.");<br />
}<br />
}<br />
P.S: I typed this code just like that without compiling so it may contains small issues..
|
|
|
|
|
Michael thank you soooooo muchhhhh!!!!
As you said there were a few small issues but not with your code but me typing it correctly and using the right SqlCommand.
I think from this example i can really learn how to manipulate databases from c# thank you soooo much!!!
Luis E Tineo S
|
|
|
|
|
Hi,
I've come up with a solution of disabling .NET security to prevent from throwing weird exceptions when using HttpWebRequest class. All I need to do is to put this xml code :
<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
<system.net>
<settings>
<httpWebRequest useUnsafeHeaderParsing="true" />
</settings>
</system.net>
</configuration>
into config file of my Win app (application.exe.config file).
1. Is there a way to do this from inside the code programaticly?
2. Is there something similar for Ftp WebRequest (which is throwing weird errors too and I have a feeling that it is about security too... ?
thanx
zilo
-- modified at 11:32 Wednesday 7th November, 2007
|
|
|
|
|
|
You'r the man )
zilo
|
|
|
|
|
No, Google's the Man. Fight the Man!!!! 
|
|
|
|
|
I'm developing a WinForm using C# and VS2005. I was wonder if it is possible to open up a childForm1 in maximize window of MDIparent and launch childForm2 on top of childForm1, but still keep childForm1 as MAXIMIZE.
Here's a big picture.
childForm1 > childForm2 (childForm1 Maximize and childForm2 on top)
What I'm looking for is the code to keep childForm1 maximize and childForm2 launch on top.
Please please please please please......advice!!!!
Thank you!
|
|
|
|
|
I don't believe it is possible to have a 'non-maximised' child form over the top of a maximised child form.
Setting TopLevel to true throws an error so the only way I can see for you to do it is to resize the child form to the size of the Mdi area (not maximised)... This will allow you to have the other child form(s) over the top of it.
You may need to bring the other forms 'tofront' (.BringToFront) if the background form is clicked otherwise all front forms will be hidden.
Alternatively... you can put other controls (buttons, labels etc) directly onto a MdiParent form: so if you only want one 'maximised' form... don't actually make it a form, make it a panel (for example) and put all other controls into this. The panel will not be 'allowed' to come forward as it is part of the MdiForm background.
Hope this helps.
Matthew Butler
|
|
|
|
|
Thanks for your reply. I came up with another idea....but still need a little guidance.
Okay, so if my childForm1 is maximize then i launch Form1 by itself, not in MDIParent(frmParent) and if I want to launch childForm2 from Form1 but make it in MDIParent, Maximize and close childForm1. Is it possible?
frmChild2 Child2 = new frmChild2();
frmParent Parent = new frmParent();
Child2.MdiParent = frmParent.MdiParent;
Child2.WindowState = FormWindowState.Maximized;
Child2.Show();
foreach (Form childForm in frmParent.MdiParent.MdiChildren)
{
if (childForm != Child2) childForm.Close();
}
break;
But it didn't work.
|
|
|
|
|
I'm not 100% sure what you mean... can you be a bit more descriptive/specific?
Are you saying you want one MdiParent with child forms that can access each other? (Close each other etc)?
Matthew Butler
|
|
|
|
|
i have a problem with datagridview it's datasource is dataview
when i try to add new row in datagrid view it does not added
even i set allowusertoaddnew=true in dataview and datagridview
and this is my code
DV_Obligetory = DS_Subject.Tables["Subjects"].DefaultView;
DV_Obligetory.RowFilter = "Subject_Type='optional'";
DV_Obligetory.AllowDelete = true;
DV_Obligetory.AllowEdit = true;
DV_Obligetory.AllowNew = true;
BindingSource Binging=new BindingSource();
Binging.DataSource=DV_Obligetory;
Binging.AllowNew = true;
dg_obligatory.DataSource = Binging;
thnx 4 help
MD_NADA
|
|
|
|
|
This is not good. What makes you think your code is more deserving of help than any other poster here? You asked your question less than an hour ago, and now you're badgering people for help. This site is maintained by volunteers, who will get to your question when they have the time and inclination. If your question is really that urgent, then I suggest that you take it to somewhere where people get paid to answer your questions.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
i am so sorry , but i'm in need to know the answer importantly
this is the reason to ask again for the help
sorry for my way to ask
MD_NADA
|
|
|
|
|
Pete O'Hanlon wrote: You asked your question less than an hour ago
Just another impatient poster needing to have his posts ignored...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hello everyone,
Something I've wondered about for some time: If I add a file (Any file, say Settings.Xml - I don't want to use MyApplication.Settings.XXX here) to my project in Visual Studio and I want to open it, how do I do this?
The following looks just plain awful:
Using X As New FileStream(Application.StartupPath & "/../../Settings.Xml", ...)
Since the startup path is /bin/debug/ this would work. But the moment I deploy my application somewhere, my Settings.Xml and executable should be in the same directory.
I could ofcourse put the files in the /bin/debug/ directory right away but that's not really elegant either is it.
Any ideas?
Cheers,
Wouter
|
|
|
|
|
Select the file in the Solution Explorer. Switch to the properties window. In the Copy to Output Directory dropdown select Copy Always.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Yaye, that's it! Thanks Pete!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
