i have a doubt about how to display a grid view in ASP.NET from SQL server 2012 according to the instruction given by drop down list from multiple tables. For example say, I have created 2 tables Members and Item where Member.Mid=Item.Mid set as primary and foreign key. okay, now my question is how should write or set code for to display according to the value selected from dropdown list in one gridview.
Once again, I want display in one gridview from multiple tables according to the value from dropdownlist...
Use a stored procedure which gives you the results back.
To merge the results from multiple tables in a SQL query, you need to use joins[^].
There are furthermore different types of joins:
I have an application/Web application on VS2010 , I need to fetch data from Oracle database without having client installed on my VS2010 machine. I have done this in J2EE through connectivity jars available freely. Can anyone please help me how to do this without oracle client. Is there any DLL available which i can add as a reference...
Add a reference to System.Data.OracleClient.dll which is part of the .Net Framework. Then you can use the System.Data.OracleClient namespace in your project. Note: You'll get a lot of warnings that that is obsolete, but you said you don't want to install the client...
You can use the Microsoft DLL, but it's been discontinued and no longer supported, or use the Oracle DLL, which is pretty fast in operation. I used the Oracle DLL's, and it took me a couple of days to figure out the whole thing.
I think there was a installation program I had to run on the web server that installed some stuff to connect to the Oracle Server.
ODAC1120320Xcopy_32bit - This program
a sample connection string, and reader programming. All types, integer, string ended up being just GetValue.
Dim conStr As String = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SQL1.domain.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))); User Id=RC_PUBLIC_USER; Password=SECURE;"
Dim con As New OracleConnection(conStr)
Dim cmd As New OracleCommand(cmdQuery, con)
cmd.CommandType = Data.CommandType.Text
Dim oReader As OracleDataReader = cmd.ExecuteReader
pI(rC).p_ID = oReader.GetValue(0) 'PN_ID
pI(rC).c_ID = oReader.GetValue(1) 'C_ID
pI(rC).c_Name = oReader.GetValue(2) 'C_Name
Anyways, I really like the Oracle Platform 11.g, hard to understand at first, because they don't use tables, Technically they say there are no such thing as tables. It's really fast, wow
Others told me to use I think ADO, or some other universal way to connect, your choice.
This IS the best way. Oracle uses local and server settings in a funny way, and the Oracle library uses all that stuff correctly. We use this method a lot - millions of calls per day - and it works great!
SSPI - Security Support Provider Interface - Security Support Provider Interface (SSPI) is an API used by Microsoft Windows systems to perform a variety of security-related operations such as authentication.