|
Hello All
Plz help me I am new to C#.net and i need to Merge the row to Dataset object
I am created code as bellow
string name = (GridView1.SelectedRow.Cells[1].Text);
int id1 = this.getDetails1(name);
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) DataRow dw //
OleDbConnection myconnection = new OleDbConnection();
myconnection = databaseconnection.getconnection();
string str = "select c_TaxShortName ,c_ItemTaxSchemeDetId from t_Item_Tax_SchemeDetail where (c_ItemTaxSchemeDetIdForFrom= " + id1 + ") and (c_SoftDelete = '1') ";
OleDbDataAdapter adpt = new OleDbDataAdapter(str, myconnection);
ds = new DataSet();
adpt.Fill(ds); // fill OleDbDataAdapter Object with selected record
ds.Merge(dw);
ddl_FieldDef. DataSource = ds;
ddl_FieldDef.DataTextField = "c_TaxShortName";
ddl_FieldDef.DataValueField = "c_ItemTaxSchemeDetId";
ddl_FieldDef.DataBind(); // bind data
myconnection.Close(); // Close connection
I need to add row in DataRow object like ;-> "PP","DP" "MRP"
|
|
|
|
|
You really can't merge a datarow and a dataset, they're a level of abstraction away from each other. If you're looking to add a row to a table within a dataset, you can use ds.Tables["tablename"].Rows.Add(DataRow), assuming they have the same schema.
|
|
|
|
|
hi all
please tell me the query
actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter
thanks
hello
hello
|
|
|
|
|
ghumman63 wrote: hi its very urgent
mmmmmmmmmm
What if no body answered?
Why is it always that some people have to say it is urgent?
Does that make the response faster?
I don't think so.
|
|
|
|
|
quiteSmart wrote: Does that make the response faster?
Your answer was quite fast 
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
|
quiteSmart wrote: Was it a time record??
I don't think so, but nevertheless pretty impressive 
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
|
if u knw the answer, then just say the answer, but pass your comments about their subject
coz they only know their bad position, at tht time thy cant search for an good subject , also it's silly
Know is Drop, Unknown is Ocean
|
|
|
|
|
I disagree, the 'community' CP only runs smoothly if a certain (n)etiquette is used.
People who don't want to use this (n)etiquette don't belong here.
A lot of people will flame someone for not 'following the rules' and with reason, this place wouldn't be so nice without.
If you don't believe me, feel free to ask in the lounge. (The C# forum is not intended for discussions like this.)
V.
I found a living worth working for, but haven't found work worth living for.
|
|
|
|
|
Exelioindia wrote: if u knw the answer, then just say the answer
Do you know the saying: "Give a man a fish and he will eat for a day ... teach a man to fish and he will eat for a lifetime". If a questioner shows that he has at least tried to solve a problem by himself, he will surely get a solution or hints pointing him in the right direction, if somebody has one. Nobody here will do the complete work for someone else.
Exelioindia wrote: at tht time thy cant search for an good subject
They should take the time (and its not much to find a more expressive subject), if they expect us to take the time doing their work.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
If you don't show that you at least tried to solve this on your own (include the query you come up with until now and which does not work), most probably nobody here will help you cause this forum is no place to let others completely do your work.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Please don't cross post.
---
Year happy = new Year(2007);
|
|
|
|
|
You'll find this[^] useful...
V.
I found a living worth working for, but haven't found work worth living for.
|
|
|
|
|
Urgent = rarely gets answered
Very Urgent = almost never gets answered
Cross posted Very Urgent = ignored by the regulars here.
|
|
|
|
|
SELECT username FROM cpPosters WHERE clue = 0
returned: ghumman63
--
Rules of thumb should not be taken for the whole hand.
|
|
|
|
|
what are the fields on the history record that you want to display?
- I want to know.
|
|
|
|
|
Wow - you got a lot of responses and very little help. That doesn't surprise me, you posted an message with a meaningless header ( EVERYONE thinks their question is 'urgent', what would the forum look like if they all said so ? ), you provide no info with which people can help you, and apparently you've cross posted this, instead of taking the time to post in the right place, with a question that shows you've tried to do some work yourself, and gives people the info they need to help you.
I suggest instead of feeling discouraged, you think it through and try again.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
It is important to give to your subject a meaning. It should sumarize your text.
DAO provided nice function like .movefirst and .movelast. Nowadays i see no other alternative than making the query into a DataReader and read it from top to bottom.
In addition, if your table has a sequencer to differenciate the key (main key built from a foreign key + sequencer), then you should use two queries with min and max to retrieve your records.
|
|
|
|
|
Dear friends
I have one datagrid which has data from one of the table as employee_master.
on click of any record on the grid I want to get the value of first cell that is employee code. but when I clicked first time it does not give me any value. on second time click it gives me the value. How can I get the value of the cells which I need in first click only.
Your quick response will be highly appreciated.
Thanks
Murtuza
|
|
|
|
|
Should you work with a dataGridView, try to treat other events like CellClick or CellMouseClick
SkyWalker
|
|
|
|
|
As an expansion to this, use a DataGridView and a BindingSource. It provides superior data management capabilities. Search the CP articles for a good one on data binding and the datagridview
|
|
|
|
|
Hi
Again I have one more problem in SSIS package. I have separate component it works well for sql to sql if i try to tranfer from oracle to oracle it gives error while converting unicode to non-unicode.
I am hanging to this problem for nearly 2 days. Help me please
kesavan
|
|
|
|
|
Try open your package and set the data type of your working field(s) to be DT_WSTR
SkyWalker
|
|
|
|
|
Hi
I am trying to create one ssis pacakage programmatically in c#. It is working for sql to sql. If i try to tranfer data from sql to oracle it is giving error while reinitializingmetadata. Getting error while creating destination connection. Could any body help me please...........
kesavan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
