|
You should be able to get the information you required from Information_Schema.Columns
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
|
|
|
|
|
Erhm, yes this is possible, but I don't think you want to solve the problem this way. Have you tried converting the old db to the new db using DTS packages, it's a SQL Server thing and realy powerfull for converting data in such a manner..
|
|
|
|
|
|
Hi,
I need to create web pages in one application(ASP.NET--C#).
These pages are meant for some other developer who would be using those pages created by me in his application.
How should i give him my pages so that they work properly with his application and I don't want him to see my coding thing.
Can I give my pages in some Component form or Web Control etc and how would he be using these pages.
|
|
|
|
|
Hi everyone.
I have problem like this. I Get data from database to DataSet. The data of database was stored windows 1258. I want to get data as default format of English (Latin I or Windows 1252)
I change Locale of Dataset to "en-US" but it not apply when I fill data to Dataset. Could Anyone help me for this problem ?
How to change locale system in C# ? (Not locale of user in window). I using VS 2005 on windows 2000.
I'm look forward hearing from you. thanks for you help.
|
|
|
|
|
I m using window application, C#, I want resize my window (form) in such way that when i resize my form then control inside it should be resize also...
The controls include a flexgrid,picturebox,labels and a DateTimePicker
I dont want to code in Resize-Event.Resizing should be done only when releasing the control
plz help.. code...
My small attempt...
|
|
|
|
|
Erhm, you can really easy resize controls with your form using the contro's anchor and docking property. You don't need to handle any event...
|
|
|
|
|
how can i use both these................plz help me
I am using an older version
-- modified at 4:35 Monday 27th November, 2006
My small attempt...
|
|
|
|
|
|
You cannot use both, you can use either one, but thei're functionality is diffrent, you should choose one depending on your needs...
|
|
|
|
|
hi i want to send listview data in excel can i do this\
sdfsdfsdfs
|
|
|
|
|
|
Hi,
Can anybody give me some good tutorials links for ADO.NET with C# for beginners.
Thanking you.
|
|
|
|
|
http://www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp
check this link to know about the ado.net with c #
venu gopal
|
|
|
|
|
Thanks,
I already followed that. actually I need some more with practical examples.
regards
mWith
|
|
|
|
|
|
http://www.windowsforms.net/Default.aspx?tabindex=5&tabid=50
chec it out, I hope this is helpful
|
|
|
|
|
on second thought may be it wont
|
|
|
|
|
hi all,
i need some inputs on how to get data into a windows form textbox from an xml file..
for eg..i have a tree with a context menu attached to it. i also have a panel which display the properties of the node. when i click on node1 menuitem(called properties) the panel will appear showing the properties of the node. some of these properties have to be read from a xml file and they have to be displayed in the corresponding textbox. the xml file will have data for all the nodes.
Sonu
|
|
|
|
|
|
You can read XML directly into datasets like
Dataset.ReadXml(Path)
|
|
|
|
|
Hi,
I've been wondering about this for a long time, so I decided to post this question here to get some opinions.
Suppose I have a Data Access Layer (DAL) with a CustomerData object. This CustomerData object has a GetCustomers() method which returns a DataSet (or a CustomerDataSet typed data set.)
Assuming this method is entirely stateless (no member data accessed), which it really should be in a DAL, is it considered best practice to make this a static method or an instance method. I like the idea of a static method, so I can code:
DataSet myCustomers = CustomerData.GetCustomers();
instead of
CustomerData myCustomerData = new CustomerData();
DataSet myCustomers = CustomerData.GetCustomers();
Since there is never any instance data, I don't really see the use in using an instance of this class. However, I am sure their are other things to consider here, so I am looking forward to your feedback on this.
Roel
|
|
|
|
|
I don't think this is a good approach. Why not making your entire application static then?
If you instanciate objects, you can clean them up neatly if not required. Your database connection object needs to be static which I experienced lots of problems with (for example using threads). I think there are multiple reasons not to make such functions static, but make you instanciate the class they're in
Removing HTML code from a string or such functions are more qualified to be static
|
|
|
|
|
Database connection does not necessarily have to be static, it all depends how you write the code. I am using Enterprise Library now...
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetStoredProcCommand("GetAccount"))
{
etc...
|
|
|
|
|
The problem is simple, thing is i m ignorant about dataset
I have some record in dataset myDataSet
2) colums like this
id num
1 1034
2 2004
3 2001
how i m accessing the data by
foreach(DataRow myRow in myDataSet.Tables[0].Rows)
{
id=(string)myRow[0];
num=(string)myRow[1];
}
so her wat happens i check for some condition before reading a record if it fails i skip reading
Now later on again i want to start reading from where i did stop how can i do it ?
I want something like index
The dataset is global so i can access any time only thing
i keep track of like i read 2 record but later how can i access the 3 rd record
Sarguna
|
|
|
|