Click here to Skip to main content
Page 1 of 6
Page Size: 10 · 25 · 50


Tag filtered by:  ADO [x]
Article 8 May 2013   license: Ms-PL
This is an alternative for "A set of ADO classes - version 2.20"
Technical Blog 2 May 2013   license: CPOL
[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →
Question 23 Apr 2013   license: CPOL
I am developing an application in Visual Basic 2010 that is accessing a database using ADOThe problem I have is that the reference to ADO seems to disappear when I clean the build.The error message I get is:'ADODB' is not declared. It may be inaccessible due to its protection...
Article 5 Apr 2013   license: CPOL
This article shows how Java application can retrieve user's data from the Active Directory
Answer 30 Mar 2013   license: CPOL
Difficult (if not impossible) to tell from that information.So, fix it yourself! The first thing to do is to find out exactly what string you are using: so change your code slightly: string sip = serverIP.Text; string strCon = "network library = dbmssocn ; Data...
Question 30 Mar 2013   license: CPOL
hi ,i use this connection string string sip = serverIP.Text; SqlConnection connection = new SqlConnection("network library = dbmssocn ; Data Source=" + sip + " ;Initial Catalog= Parking_Database ;Integrated Security=True"); connection.Open();but when run...
Article 25 Mar 2013   license: CPOL
This article will guide the developers on how you can connect to excel files using ADO.NET and modify the sheets
Question 19 Mar 2013   license: CPOL
Now that W7 SP1 is going to be foisted upon a waiting world[^], does anyone know if the ADO breaking compatibility problem[^] has been fixed?
Question 15 Mar 2013   license: CPOL
I've come across an error that I cannot figure out why it is being generated.I am using ADO in an MS Access database to push a record to a SQL server using a stored proceedure.What is confusing me is that I am using cmd.parameters.refresh to populate the ADO command object so therefore, in...
Answer 15 Mar 2013   license: CPOL
I found the problem. When I was executing the command, I had left in a bit of code that was trying to assign the stored proc's return (integer) to a recordset. That is why the procedure executed correctly and Access was still throwing an error.
Answer 15 Mar 2013   license: CPOL
For the first look, you didn't add parameters: @Form_ID int, @State_ID int, @Form_Date nvarchar(50), @Filing_Type_ID int, @Revision tinyint, @State_Specific tinyint, @Filing_Date nvarchar(50) = null, @Filing_Status_ID int = null, @Approval_Date nvarchar(50) = nullSee this:...
Question 10 Mar 2013   license: CPOL
I need to show some values which i got from Database in my grid as below,Name ScoreMaths ScorePhysicsA 1 5B 2 6C 3 7D 4 8So i added new...
Answer 12 Feb 2013   license: CPOL
It does not work like this here.Here is what is expected of enquirers:1. TRY first what you want to do! You may find that it's not that hard.2. Formulate what was done by you that looks like an issue/not working. Try them and tell if you face issues.Members will be more than happy...
Answer 4 Feb 2013   license: CPOL
I know the useful component that simplify chat conversation operation in asp.net. just google "MangoChat". It's free and u can use it in every asp.net pages. Also it has very useful guideline document that u can use it for helpjust try it one time! u will love it ;)
Answer 4 Feb 2013   license: CPOL
If You Wirte Chat Engin Then You Is Very Relax!!!i Write Chat Engin.Whith Application Class Is Very Simple!!!Try it guy .;)Failure Is Not An Option Good Luck
Answer 23 Jan 2013   license: CPOL
Have you ever tried using Google? If not then try it...Google has invested millions of work hours and billions of dollars in creating google , so that developers like us can find answers to simple programming questions like this within a few seconds.... Not sure?? Check here[^] is the proof...
Question 23 Jan 2013   license: CPOL
Hi friendsI Have a asp.net website . i need to add an online chat in my website so that the visitors can chat with me 24hrs .if i am online i should get the notification bla bla. is there any simple ways . like widget .if then how to do it in my website please help me...
Article 15 Jan 2013   license: CPOL
Some guidelines for developing better MS Access solutions.
Answer 20 Dec 2012   license: CPOL
string labelTextData = string.Empty;int count = GridView1.Rows.Count;List id = new List();foreach (GridViewRow item in GridView1.Rows){ labelTextData += item.Cells[1].Text + ","; labelTextData += (method to get Id from Database);}label.Text = labelTextData;is that what...
Question 17 Dec 2012   license: CPOL
hi friendsHow to View my Generic List to a label in a webpage when a button is fired from another page .. or else in gridview string itemName; int count = GridView1.Rows.Count; List id = new List(); foreach (GridViewRow item in...
Answer 17 Dec 2012   license: CPOL
In your c# i'm not sure how to code it,but its not difficult.So if i provide it in VB maybe you will understand hopefully?YOUR CODE C#for each (GridViewRow item in GridView1.Rows) { itemName = item.Cells[1].Text; id.Add(method to get id from database); }In VB...
Answer 17 Dec 2012   license: CPOL
int count = grvTest.Rows.Count; foreach (GridViewRow row in grvTest.Rows) { string text = row.Cells[0].Text; }so that you can get the cell value of 1st column of your grid view
Question 17 Dec 2012   license: CPOL
hi friendsi have to get the total number of rows in gridview with all values or text inside first column .. how to do it please provide me a code string itemName; List ids = new List(); foreach (GridViewRow item in GridView1.Rows) { itemName =...
Answer 11 Dec 2012   license: CPOL
since you use the con.BeginTransaction() before the beginning of statement the real insert will not complete until you make call to sqlTranc.Commit();so its obvious that the creditID which you are trying to update is not available in the table and it failed to update.move the Commit...
Answer 10 Dec 2012   license: CPOL
in the end i was able to solve this problem.All was caused by ADO and its behavior when it encoded binary data from Local system language codepage to unicode.in this example it was on French system from codepage 1252 to unicode and on Czech from codepage 1250 to unicode.So I needed...
Question 30 Nov 2012   license: CPOL
Good day all,I encountered were strange problem during my work.When I call stored procedure from JScript (Jscript code is compiled by 3rd party desktop application that uses windows script 5.6) and give it data through parameters it ends up that data stored in database are different based...
Question 28 Nov 2012   license: CPOL
i can't get 2 queryjust working string queryand query dont internal bool saveNewPayment(Guid ID, Guid creditID, decimal paymentAmount, DateTime dateTime) { bool flag = true; using (SqlConnection con = new SqlConnection(constring)) ...
Answer 27 Nov 2012   license: CPOL
Hi iron,For exampple it is possible to do with C++/Qt....Sometimes, it's necessary to execute some queries to database in asynchronous way (multi-thread), for example to avoid to freeze a GUI if a query is too long to execute.To make easier to work with asynchronous queries, QxOrm library...
Question 27 Nov 2012   license: CPOL
Hello,I need to execute sql queries in asynchronous manner.Any examples ?Thanks in advice.Irek.
Question 26 Nov 2012   license: CPOL
Hi,I have seen how to set the properties of a column using ADOX, eg, CascadeKey.DeleteRule = ADOX.RuleEnum.adRICascadeWhat I need now is how to read the same property values of a key column, ie, the opposite code. I was thinking something like this would work but to my...
Answer 7 Nov 2012   license: CPOL
Finally,I find that the functions used while using VC++ to operate Access DataBase with ADO are the same in ASP.And all the elementary mathmatics functions can be used.(For example:power()->"^";ln()->"log()")Thanks!!!
Catalog 1 Nov 2012   license: Commercial
The Google Spreadsheet Data Provider for ADO.NET gives developers the power to easily connect .NET applications with real-time data from spreadsheets stored in Google Docs. The Google Spreadsheet Data Provider makes these Google Spreadsheets look like SQL tables in your apps.
Article 10 Oct 2012   license: CPOL
The fifth incarnation of a dynamic and self-adaptive ORM library with full support for POCO objects, that doesn’t require any mapping or configuration files, and with support for natural SQL-like syntax in plain C#
Catalog 21 Aug 2012   license: Commercial
Host UNLIMITED Websites! Get 2 Months Free with No Setup or Hidden Fees
Answer 17 Aug 2012   license: CPOL
With Windows Vista, MDAC has been replaced by DAC 6.0. Installation of old MDAC versions is not possible. However, most software using MDAC should work with DAC without problems when running on Windows Vista or Windows 7.I suggest to check first that your application is running on Windows...
Answer 17 Aug 2012   license: CPOL
You have already asked this question here[^]. Please do not repost the same question multiple times.And, as someone already pointed out, there is no such thing as Windows 2012, so you need to clarify your question.
Question 17 Aug 2012   license: CPOL
we have one application that does not work in windows 2012. The application uses MDAC and I checked the OS and the MDAC version is shown 6.0. Is there a way to downgrade to 2.8?Or can you think other reasons to prevent application run on the windows 2012?
Technical Blog 16 Jul 2012   license: CPOL
Configuring and using Entity Framework 4.1 for my Open Source project.
Answer 10 Jul 2012   license: CPOL
I got solved myself actually I just did silly mistake.There is a one unicode setting has to be enable in Visual Studio.Here is the solution:Check the following setting in Visual Studio:Tools->Options->DebugCheck Display unicode strings checkbox.Thanks...
Question 10 Jul 2012   license: CPOL
Hi Guys,I am facing a weird problem to put the database query in CString Format withUnicode defined.I am giving a simple example of my problem.CString str1;int value = 123; str1.Format(_T("select * from Table Where Max > %d"), value);Getting output only 1st character of...
Answer 9 Jul 2012   license: CPOL
What about format function?It would be something like thisSELECT * from Customer WHERE RegDateTime >= FORMAT('02/05/2012', "dd/mm/yyyy")....
Answer 8 Jul 2012   license: CPOL
You should use the english date format 'mm/dd/yyyy' and enclose the date specifications by hash characters. With ranges, use the BETWEEN operator and include the times:SELECT * from Customer WHERE RegDateTime BETWEEN #02/15/2012 00:00:00# AND #02/25/2012 23:59:59#If you want to limit...
Answer 8 Jul 2012   license: CPOL
I think you can change the format according to ISO standard. and for control DateTime_SetFormat macro is used for c/c++. try it out see if you can set your format
Question 8 Jul 2012   license: CPOL
Hello,I got a problem to execute a date validation query for MS access database under ADO VC++ programming (VC6.0).I am using the below mentioned query for date validation but it's giving mismatch date format error message because date format in MS Access Database is "DD-MM-YYYY...
Answer 30 Jun 2012   license: CPOL
Is it even compiling?For instance, this line: SqlCommand cmd = new SqlCommand;
Answer 30 Jun 2012   license: CPOL
We can't tell for the same reason you can't: Your code hides the error.Change the catch block:catch (Exception ex) { Message("Block 3: Error\nThe Reported fault is:\n" + ex.Message, this); }That way, if the error message does not give you enough information, you can put a break...
Question 30 Jun 2012   license: CPOL
it is not inserting the data where i am doing the mistak... , its showing catch error message string Patient_name = NameTxtBx.Text, Export_TO = ToTxtBx0.Text, repType = RadioButtonList2.SelectedValue ; int PatNoVal; ...

Page 1 of 6
1 2 3 4 5 6


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid