In following code I am binding two parameter by name. Program compile successfully but output isn't coming.
cmd = new OracleCommand("select * from books where book_id=:bid and title=:rat", conn);
OracleParameter op = new OracleParameter();
I have an anchor tag in gridview
<a href ='<%#"Edit_TidalData.aspx?Id="+DataBinder.Eval(Container.DataItem,"id") %>,'
where id is the datakeyname of the grid now i had a requirement to add another datakename as UserId. and i need to have DataBinder.Eval for UserId also.
How am going to use two values in this anchor tag using DataBinder.Eval?
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 RepliesI am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
Trying to modify an existing gridview in an aspx to access a db2 table on an iseries server. The iseries seems to have problems with the parameter specified in the query as @parameter giving a @parameter does not exist in table error. When specifying the gridview in VS the wizard did not recognize that the @parameter was a parm and prompt for the control etc. where it could be found. Of course there is no problem when accessing a mssql server table. Can someone help me with how to connect properly to the iseries and how to pass a parm on my query?
View 1 RepliesI am not able to find the projects related to working with excel sheets by using ClosedXML to refer. I have an excel book which contains two sheets.
In sheet 01: In column A: In B: In C:
Student name01 Student's phone number blabla
Student name02 Student's phone number blabla
Student name03 Student's phone number blabla
In sheet 02: In column A: In B: In C:
course name01 computerscience blabla
course name02 dhfsthshbstgs blabla
course name03 garsfghsefrgs blabla
now, I would like to see in two comboboxes (all the words/text presented in the column A) from two sheets, the student name and course name and then I want select any student name and course name of my choice. Afterwards, when I click on a button, my program should display the students phone number and the course name (from column B from both sheets) and related things present in the Column C D E.. of the selected things in combobox in a label or a in a textbox.
PS: I solved the following problem: I can select student name in one combobox and print the the corresponding data from the only one column B (but I worked only with one sheet). It is bit complicated for me to continue with two sheets.
I'm sending parameters to a stored procedure in MySQL to do an insert and I'm getting an error that I don't understand:
Parameter '?/*IN' not found in the collection.
I'm converting my application from using System.Data.OracleClient to Oracle.DataAccess.Client and I've noticed some weird behavior.
I am calling a stored procedure that sets an output parameter value. Under some circumstances, a null value gets assigned to this value and I need to detect it.
Here's how I'm declaring it using ODP.net:
cmd.Parameters.Add("p_status", OracleDbType.VarChar2, 200, DBNull.Value, ParameterDirection.Output)
The old Microsoft driver for Oracle would read the value as an empty string. However, ODP is returning a value {null} (per Visual Studio's debugger), which is not equivalent to null, DBNull.Value, nor an empty string. As a result, the code doesn't branch correctly now.
I have the following code to fill a dataset
Dim cn As New OdbcConnection(ConfigurationManager.ConnectionStrings("csSybaseGuille").ConnectionString)
I'm having problem on passing parameter on odbc because it's not working at all. I tried this using sql and I have no problem at all. All are working fine. Is there a different syntax on odbc? Here's my code:
[Code]....
Or using mysql connector/net to use mysql. I'm having problem installing it because the visual studio integration is not working, so I can't find it on the data source provider.
Isn't the Bind attribute, preferable the Exclude parameter, define any properties that will be excluded from any form update? If so, why does the ModelState is not valid when I do this?
[code]...
I have a problem whenever i run my code i get the following error ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.46-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ('b'), ('Manager'), ('c'), ('d'), ('e')' at line 1 my code works with connector/net but my host does not have it installed so i've had to change my code to odbc which they do have, i have found out the syntax is different and changed my code accordingly my code is as follows
[Code]....
I am goig to execute an oracle store procedure using C# through through ODP.NET. The store procedure executes succsfully but it does not return any value in the out parameter.
When I execute the same store procedure with the same input parameteres from within SQL*Plus. It does return values.
This is to be clearify here that in the oracle store procedure the data type for the out parameter is number and in the c# the variavle that will hold its value is Integer. I also tried using Long on the C# side but it is still not working. After the successfull execution of the store procedure the C# variable contains nulll value.
The problem I have is that I've got a simple ASP.NET page. On it, I have a dropdownlist that is calling values from a MySQL table.
When I select a value from the list, I want to create/update a GridView.
I've created the code, which works if I hard code the parameter, but I want to use the DataValueField from the drop down list.
Is this possible?
[Code]....
I have data in ParamList (from SQL reporting services database)which I want to display in a GridView. as ParameterName and VAlue. I am able to retrieve the parameters but can't figure out how to read them into ArrayList (or whatever method you coud suggest) and then bind to grid. Final grid should be like this-
ParameterName ParameterValue
Year 1011
Number1 0011
Number2 0101
Number3 0201
Here is the code I'm trying to figure out-
Dim intCount As Integer
Dim strparam As String
Dim strparam1 As String
Dim varResult As Object
Dim ParamList as string
ParamList = "Year=1011&Number1=0011&Number2=0101&Number3=0201"
varResult = Split(ParamList, "&")
Dim arrList As New ArrayList()
'loop through array and retrieve parms
For intCount = 0 To UBound(varResult)
varParam = Split(varResult(intCount), "=")
strparam1 = UCase(varParam(0))
strparam = varParam(1)
arrList = ???
Next
'and then display tsi data into a grid.
GridViewParams.DataSource = arrList
I'm developing an ASP.NET app with a MySQL backend, using the MySQL Connector Net 6.2.3. I have a DetailsView with an insert command that is throwing the error:MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?,?,?,?,?,?,?)' at line 1My code is:
[Code]....
If I hardcode values into the insert statement, it works fine. But when I put the ? placeholder in, it throws the error. Can anyone help me pinpoint the problem or offer a workaround solution?
I have two AccessDataSources each returning one row.
I want to use the data in each row to populate content on my page, so I figured I would use a [Code].... or [Code].....
However, I would not necessarily want the labels bound to a particular DataSource placed together.
For example, I might want labels from the following columns in order [Code]....
:
[Code]....
Note: No language preference (C#/VB).
I have to update multiple row and two column of each row.
I have try to Update with case statement but after I perform that statement it blank out every other column that doesn't fall into the criteria of the update statement.
My table structure is like this;
table1
col1
row1 11
row2 22
I want to update row1 and row2 of their col1 in one single sql , how do i do that?
In my web application, I have 2 totally different databases - one that's being used mostly by a CMS from which we'd like to get page information on non CMS pages on the same website, & one that contains totally different data. Is it possible to use Spring.NET's Open Session In View module with multiple session factories for both of those databases, so in this case I have 2 objects defined in spring.config of type Spring.Data.NHibernate.LocalSessionFactoryObject?
View 1 RepliesI have an application which connect to oracle db.
I have two database hitting functions.
One is adding Userdetails(Fn Name : AddUserDtls) and another one adding address details(Fn name : AddAddresDtls) based on UserName which will get added after execution of first method ie AddUserDtls.
Problem I am facing is :
I have a single transaction and in that I have all the methods.
After the execution of first method,with out commiting i will go to second method.
and if any error occurs in second method.
I will rollback everything including the changes made by first method also.
Here one issue is there.
Since I am not committing the changes made by first method,
While I am executing the second method I am getting error that 'No user Name exists'
I understood that if we commit the transaction before the second method starts ,it will solve the issue.
But then it creates another problem.If some problem araise in the second method,then I cannot rollback the changes made by first method since it aleready commited.
I want to update multiple column of a table using subquery ...My sample code is shown below
[Code]....
its throwing syntax error...I dont know where i commiting mistake.
if we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ?
Example:
[code].....
Is it better for a collection of ASP.NET web apps to share the same session database, or should each one have its own? If there is no significant difference, having a single database would be preferable due to easier maintenance. Background My team has an assortment of ASP.NET web apps, all written in either Monorail 1.1 or ASP.NET MVC 1.0. Each app currently uses a dedicated session state database. I'm working on adding a new site to that list, and am debating whether I should create another new session database, or just share an existing one with another app.
View 1 RepliesI am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
i want to know how to connect to multiple databases in sql from our asp.net code??
View 4 Replies