|
i m inserting in sql server express edition 2005 which i selected from add new item in visual studio 2005, i can view data in grid, but when i m trying to insert data it dont give me any error but it is not adding the data in table
SqlCommand admin_comm = new SqlCommand("insert into P_analysis values (@pid, @p_price, @p_date, @opd, @pdp, @rin, @rip, @ord, @p_name, @r_name)", admin_conn);
admin_comm.Parameters.Add("@pid", SqlDbType.Int);
admin_comm.Parameters["@pid"].Value = int.Parse(s1);
admin_comm.Parameters.Add("@p_price", SqlDbType.Int);
admin_comm.Parameters["@p_price"].Value = int.Parse(s2);
admin_comm.Parameters.Add("@p_date", SqlDbType.SmallDateTime);
admin_comm.Parameters["@p_date"].Value = s3 ;
admin_comm.Parameters.Add("@opd", SqlDbType.SmallDateTime);
admin_comm.Parameters["@opd"].Value = s4;
admin_comm.Parameters.Add("@pdp", SqlDbType.Int);
admin_comm.Parameters["@pdp"].Value = int.Parse(s5);
admin_comm.Parameters.Add("@rin", SqlDbType.VarChar);
admin_comm.Parameters["@rin"].Value = s6 ;
admin_comm.Parameters.Add("@rip", SqlDbType.Int);
admin_comm.Parameters["@rip"].Value = int.Parse(s7);
admin_comm.Parameters.Add("@ord", SqlDbType.SmallDateTime);
admin_comm.Parameters["@ord"].Value = s8;
admin_comm.Parameters.Add("@p_name", SqlDbType.VarChar);
admin_comm.Parameters["@p_name"].Value = s9;
admin_comm.Parameters.Add("@r_name", SqlDbType.VarChar);
admin_comm.Parameters["@r_name"].Value = s10;
admin_conn.Open();
admin_comm.ExecuteNonQuery();
admin_conn.Close();
asd
|
|
|
|
|
Wrap the whole thing in a try-except block and see what error you get, if you get any that is.
Your query isn't in the right format either.
Example: Table: RegistrationInformation Column: PlayerName
Query would be:
INSERT INTO RegistrationInformation (PlayerName) VALUES (@PlayerName)
NOTE: @PlayerName can be whatever you want it to be, this is how you reference it in SQLCommand.Parameters
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
I believe you can just specify values, but I agree it's not wise to do so.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Maybe, I am so used to doing it now it just looks weird without it. Now that I think of it I think you can as long as you understand that it will just start at the first column and goes as far as it can with the given information. And with that implementation I can see many issues
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Expert Coming wrote: And with that implementation I can see many issues
Oh, I agree 100%. Better to say what you want, instead of hoping it works itself out.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hhani wrote: int.Parse(s5);
NEVER do this. Use int.TryParse, so your code will never blow up.
I guess this means you can't use client tools to enter SQL direct to the DB and make sure the SQL works ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
It looks like you are just now starting a project... How could you possibly be at an emergency state yet? Your not even in production. We would love to help, but quite frankly, I, and probably most others could care less if you had an emergency or needed something urgently.
Now, give more information.
Is this a form, or web application?
What kind of database?
How about some sample code?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
m inserting in sql server express edition 2005 which i selected from add new item in visual studio 2005, i can view data in grid, but when i m trying to insert data it dont give me any error but it is not adding the data in table
SqlCommand admin_comm = new SqlCommand("insert into P_analysis values (@pid, @p_price, @p_date, @opd, @pdp, @rin, @rip, @ord, @p_name, @r_name)", admin_conn);
admin_comm.Parameters.Add("@pid", SqlDbType.Int);
admin_comm.Parameters["@pid"].Value = int.Parse(s1);
admin_comm.Parameters.Add("@p_price", SqlDbType.Int);
admin_comm.Parameters["@p_price"].Value = int.Parse(s2);
admin_comm.Parameters.Add("@p_date", SqlDbType.SmallDateTime);
admin_comm.Parameters["@p_date"].Value = s3 ;
admin_comm.Parameters.Add("@opd", SqlDbType.SmallDateTime);
admin_comm.Parameters["@opd"].Value = s4;
admin_comm.Parameters.Add("@pdp", SqlDbType.Int);
admin_comm.Parameters["@pdp"].Value = int.Parse(s5);
admin_comm.Parameters.Add("@rin", SqlDbType.VarChar);
admin_comm.Parameters["@rin"].Value = s6 ;
admin_comm.Parameters.Add("@rip", SqlDbType.Int);
admin_comm.Parameters["@rip"].Value = int.Parse(s7);
admin_comm.Parameters.Add("@ord", SqlDbType.SmallDateTime);
admin_comm.Parameters["@ord"].Value = s8;
admin_comm.Parameters.Add("@p_name", SqlDbType.VarChar);
admin_comm.Parameters["@p_name"].Value = s9;
admin_comm.Parameters.Add("@r_name", SqlDbType.VarChar);
admin_comm.Parameters["@r_name"].Value = s10;
admin_conn.Open();
admin_comm.ExecuteNonQuery();
admin_conn.Close();
plz plz tell thankss
asd
|
|
|
|
|
Check the properties of your database (Right click the name of your database in Solution Explorer) and set the property of "Copy to output" to "Copy if newer".
If that doesn't work, manually copy your database and paste it in the debug folder of your project.
Hope this helps
|
|
|
|
|
Thanx alot ...... i wanna send u thankks card...
it really helpdd me
Again Thanx.. can i hav ur email Address
asd
|
|
|
|
|
Hi,
How can I retrieve the table name from a dataset after filling it..
DataSet1.Tables[0].TableName will always return "Table"
I have a feeling that this's only retrieving the table names set from the code using the same bloody property not the original names in the database
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Muammar© wrote: I have a feeling that this's only retrieving the table names set from the code using the same bloody property not the original names in the database
You are correct, Sir! If you don't set this variable it will always return its default value. I suggest setting it in your data adapter when you initiate the table.
|
|
|
|
|
Im currently developing a webbrowser and need to know if anyone knows a way to detect all the RSS feeds a site has to offer without having to navigate to a specific XML page.
|
|
|
|
|
Check in the header of the page for any links to a file whose type="application/rss+xml". Check the header of this page for example and you'll see
|
|
|
|
|
Ok thanks. You can check the header in the webrowser control right?
|
|
|
|
|
Just found out that that black screen mode is actually a security mode to prevent other programs from hooking into uac when you enter passwords or something...
anyway to invoke this for other programs?
|
|
|
|
|
I have a dataGridView and as I am processing its rows - with a foreach (dataGridViewRow row in this.dg) I may be setting the visible property to false (based on some processing logic). It works for all rows execept the first row. All appropriate rows disappear from my grid except the first row. I first thought it had something to do with it being the current row, but I physically navigated off the first row and then pressed my process button and the first row still was displayed.
Here is the code that I am using to hide/display the row:
private void HideShowRow(DataGridViewRow row, bool visible)
{
CurrencyManager cm = (CurrencyManager)BindingContext[dgSTSimport.DataSource];
cm.SuspendBinding();
row.Visible = visible;
cm.ResumeBinding();
}
I stepped through my code and at the end of the loop, the visible property for the first row was false. As I was processing the second row and setting values for some of its cells, for some reason the visible property of the first row got set back to true (I kept the first row in my watch window). The only code that sets the visible property is the method above, and the debugger never stepped into that code while I was processing the second row, so I am at a loss as to why this is happening.
I put an intermediary fix in place to loop through all the rows in the datagrid a second time and reset the visible property based on the status of the row. That worked fine, but I do not want to have to loop through all the rows a second time if I do not have to.
Any ideas as to what I am missing?
|
|
|
|
|
Can anyone tell me how I can return an array of bitmaps?
I have declared Bitmap[] test = new Bitmap[30]
and tryed to fill it with test[length++]=b (length being initialized to 0, and b being the bitmap)
but the "test" array does not seem to hold the bitmaps, except the last one.
Can anyone point me if not, as to what I have to read to learn how. :S
|
|
|
|
|
AKXman wrote: have declared Bitmap[] test = new Bitmap[30]
and tryed to fill it with test[length++]=b
So, all your array elements ended up holding hte same bitmap ? This is not a value type, it's a class. Unless b is redefined every time, you will find they all point to the one bitmap, change one and you change them all, because there is only one, just 30 references to it
The Clone method of hte Bitmap class will work just fine for this, but you need to cast the result.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thank You.
I tried bunch of things to keep the bitmaps, and I just happened to stumble upon the .Clone() option.
I don't understand why that works, but I will keep searching for an answer, some tutorial or a book ...
Thank You again.
|
|
|
|
|
It works for the reason I stated. Without it, all your array elements are references to the same bitmap, only one exists in memory, and so when it changes, all the elements change.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
there are only a few ways to create an object, the most obvious is using the "new" keyword;
others are calling a method that says Create() or Clone(). Everything else does not create
new objects, at best it duplicates a reference to a pre-existing object.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Thank You both for Your answers.
I have managed to solve my problem inspite of all the unknowns I have encountered.
Mucho thanx to CodeProject and MSDN.
|
|
|
|
|
you're welcome.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Hi
Can any one provide me with help on how to serialize this collection of objects? I was trying to put some tags, but I am not really getting anywhere.
<br />
[XmlRoot ()]<br />
public class TableList<br />
{<br />
private ArrayList tableList;<br />
<br />
public TableList()<br />
{<br />
tableList = new ArrayList();<br />
}<br />
<br />
[XmlArray("tables")]<br />
public MyTableItem[] Tables<br />
{<br />
get<br />
{<br />
MyTableItem[] tables = new MyTableItem [tableList.Count];<br />
tableList.CopyTo(tables);<br />
return tables;<br />
} <br />
}<br />
<br />
public int AddTable(MyTableItem table)<br />
{<br />
return tableList.Add(table);<br />
}<br />
<br />
<br />
public class MyTableItem<br />
{<br />
TableInfo TableInfo = new TableInfo();<br />
<br />
[XmlElement("name")]<br />
public string TableName = string.Empty;<br />
[XmlElement("id")]<br />
public string OasisID = string.Empty;<br />
[XmlElement("Info")]<br />
public Object TableInformation = new Object();<br />
<br />
public MyTableItem ()<br />
{<br />
<br />
}<br />
<br />
public MyTableItem (string Name, string OasisID)<br />
{<br />
this.TableName = Name;<br />
this.OasisID = OasisID;<br />
TableInformation = TableInfo.GetTableInformation(Name);<br />
}<br />
}<br />
<br />
public class TableInfo<br />
{<br />
public TableInfo ()<br />
{<br />
<br />
}<br />
<br />
public Object GetTableInformation (string tableName)<br />
{<br />
if (tableName == "Table1")<br />
{<br />
Table1 tb1 = new Table1();<br />
return tb1;<br />
}<br />
<br />
if (tableName == "Table2")<br />
{<br />
Table2 tb2 = new Table2();<br />
return tb2;<br />
}<br />
return null; <br />
}<br />
}<br />
<br />
public class Table1<br />
{<br />
[XmlAttribute()]<br />
public string Prop = "Hello";<br />
<br />
public Table1()<br />
{<br />
<br />
}<br />
}<br />
<br />
public class Table2<br />
{<br />
[XmlAttribute()]<br />
public string WhatIsThis = "Test string";<br />
<br />
public Table2()<br />
{<br />
<br />
}<br />
}<br />
Thank you very much!
|
|
|
|