|
you can use math() function to convert e.g 1.5999999 to 1.6 using math.ceil or math.floor
|
|
|
|
|
|
Hi,
How to pass parameters to a Access database using oledb provider and enterprise library. We used below code to update category table which has two colums ID and CategoryName. The code runs successfully without any errors but the table row remains unchanged. What could be the problem
Database db = DatabaseFactory.CreateDatabase("MyDemoConnection");
DbCommand dbCommand = db.GetSqlStringCommand("Update Category SET CategoryName = @CategoryName WHERE ID = @ID");
db.AddInParameter(dbCommand, "@ID", DbType.Int32,(int) 1);
db.AddInParameter(dbCommand, "@CategoryName", DbType.String, "Just a Change");
int i = db.ExecuteNonQuery(dbCommand);
<connectionStrings>
<add name="MyDemoConnection"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\db1.mdb;User Id=admin;Password=;"
providerName="System.Data.OleDb"/>
</connectionStrings>
It would be great if any one can redirect me to the exact way
modified on Friday, August 21, 2009 7:21 AM
|
|
|
|
|
Here there is a simple solution.
Life is a stage and we are all actors!
|
|
|
|
|
Dear All, yet i have tried different methods to import data from excel to SQL SERVER Table.
i have used COM,OleDB.
what are the best way to export all excel format files ".xls,xlsx" to SQL 2k and 2k5?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Generally speaking, it is best to first save the excel file as a delimited text file, or xml file, in Excel itself.
If that is not an option, you could try to convert it in your application first, and only then try to import it into your database.
You can try to import directly from the Excel file, but the code will be sensitive to version changes of Excel (it will work for Excel 2003 but not for Excel 2007 for example)
Another option is ODBC.
My advice is free, and you may get what you paid for.
|
|
|
|
|
|
Well, if a network connection exists, you can use it. You can't just hijack another app to find it tho
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
To Senior Programmer...
Please Help Me...
I Have Task make application Digital Mark Reader...
Please Help Me...
I Don't Have Idea...
|
|
|
|
|
Well, if its course work talk to your tutor, if its a task at work talk to your manager, and if its a job you bid for and won tell your client you are told lies and you have no idea what you are doing.
Nobody is going to provide code for you.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
It's funny, your profile says your are from the USA.
Why I don't have a clue of what you are trying to achieve after reading your question?
Surely you master the English well enough to ask a meaningful question?
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
dear all,
i am about to begin a project in VOIP and it will be P2P based.Here i am just trying to implement VOIP using simple microphone and speakers.
Can anyone help me by giving sample source code.
thanks in advanced
|
|
|
|
|
If you'd like the source code to do VOIP, I recommend going over to the job site and hiring someone to write it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hey budy his question was a litle bit foolish ....... but I was also trying to do VOIP(first on Local
area ...... then in advance on the WAN ) ........ I have no idea about socket programming but I am reading more abt them and asking questions here .......... But you should have told me like that ........ It will b nice 4 him .... Thanks
|
|
|
|
|
Hey budy ......... try to google on the net ........ and you can also search the MSDN library
|
|
|
|
|
I have a repeater that I am dynamically generating controls for based on some DB data using a class inheriting ITemplate. I am currently generating a checkbox and a textbox for each row in the DB which is working fine. The problem is that I want the textbox to be invisible until the user clicks the checkbox corresponding to the adjacent textbox. I have wired up the click changed event, but I cannot access the textbox only the checkbox. Should I use a Delegate or some other method of enabling and disabling the visibility of the textbox.
|
|
|
|
|
I ended up using javascript to hide and unhide the textbox.
|
|
|
|
|
As a final year project I am interested in doing p2p voip.But I have no idea how to start the project.Plz provide me some sample tutorial or research pages rather than links.
Looking for your positive response.
|
|
|
|
|
Well, all you need for that, is code to compress voice and deliver it over the web. Search for audio compression, not voip.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i have a combobox from which i ll select the year and based on that i have to display the calendar with 12 months starting from jan of selected year to dec of selected year and on pressing the arrow key the next year calendar should be loaded.thanks for any sort of help.
Ajith.EV
|
|
|
|
|
Well, you're not talking about any control built in to the framework, so you need to write your own.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
is that possible if so can you plz help me to start with im not getting an idea to solve this problem
|
|
|
|
|
ajithnamboodiri wrote: is that possible
Of course.
ajithnamboodiri wrote: if so can you plz help me to start with
I don't know how to help you, given that the answer is to create a user control and then visually work out how to build it.
ajithnamboodiri wrote: im not getting an idea to solve this problem
Perhaps you need a book on Winforms development ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
One whay is to use custom datetime picker. I Think netAdvantage has it (Not free).
Or you coud simply try to paint another control like MonthCalendar, and maybe it will fell like pop up
|
|
|
|
|
i have made a form which at as splash in starting of my application...i dont know how to show it for few mins and then get disappear and show other forms???? plz help me.
thanks.
|
|
|
|