I need to pass many records with number of fields(i.e 5rows and 5 columns) in either array or table form to oracle for processing. Is it possible to pass array/table from asp.net pages? If no, any solutions for this? I have been thinking of passing it as string concatenated with delimiter and split it. Seems like it is not appropriate as i have to pass 5 strings(5rows)
View 2 Replies
How to Pass array List of specfic Type To the Web Service?
View 1 RepliesMy web page contains a file upload control that is used to select excel file. What my code does; is to read the content of that file and store its content to DB. Right now, I save this file to server and read its content using OLEDB.I want to know is there any way i can read the content without saving it on the server?
View 2 RepliesI am selecting data from database and in while loop, i want it store all data in one variable. How to do that? The variable selectAnswer is string array type .
I used this code but this give error. Modify this code.
string selectAnswer[] = new string[];
while (rdr.Read())
{
selectAnswer[] = rdr[0].ToString();
}
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
View 5 RepliesOurs is a Asp.net web application. Database is Oracle. Its an Internet Application.
Database will be in one location and Web application in another. Data from Oracle to Web application will be passed over Internet.
We are using EnterpriseLibrary. And provider is System.Data.OracleClient.
We need a provider which encrypts the data while passing data over internet.
Do we need to go for some third party Providers or ODBC ?
I want to pass the Array ( object[]) or Structure data type value to the store procedure through
ibatis .net. I can do same by commandtext using SQLDBType.Structure. I am using Table value function in sql server 2008 and .Net 2010.
[URL]
im looking to insert an array of information into a database table
essentially what id like to do is something like this:
objCmd = New OleDb.OleDbCommand("INSERT INTO pluINFO VALUES *", objConn)
For j = 0 To 265
objCmd.Parameters.Add( info(j) )
Next
this code gives me a syntax error for the insert statement
is there anyway i can set the insert statement that would allow me to add each element of the array(looping through rather than hardcoding several hundred entries) into the table?
How can I add an array of string to data column of a an empty data table in asp.net?
View 1 RepliesIs there a way to pass an array or List<> from the aspx.cs to xaml.cs?
View 1 RepliesI want to send an array of integer to sql server Stroed Procedure as parameter from vb program. How i can do this.
Secondly how I declare an parameter array in stored procedure which accept the array of integer.
I am LINQ querrying against a datatable. However, I am unsuccessfull with catching null values. Here is my code that is giving me the following error.
[Code]....
I am checking to see if minperc is null. However to check that it still is trying to convert the value to double. Cant figure out a way around it. Here is the error: Cannot cast DBNull.Value to type 'System.Double'. Please use a nullable type.
I have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
i want to pass multidementional array as parameter, below the code i worked, is it right
class ASRateContract
{
public string[,] standardrate = new string[3,2];
public string[,] storagerate = new string[3,3];
public void setstandardrate( string [3,2]name )
{
standardrate = name;
}
public string setstoragerate()
{
return "";
}
public string getstandardrate()
{
return standardrate;
}
I have a user control that contains a reportviewer control.And I want to send an array of reportparameter to my user control.But I can't figure out how to do.I'm getting "Object reference not set to an instance of an object. ".My param_reportParam variable is null in usercontrol.My user control's parameter is like that ;
[Browsable(false)]
public ReportParameter[] param_reportParam [code]....
And a simple page that uses user control to show server reports is like that ;
ReportParameter[] parameters = new ReportParameter[4];//parameter number can be different
parameters[0] = new ReportParameter("imza", imzalayacaklar);
parameters[1] = new ReportParameter("Sayi_Son_Eki", "984");
parameters[2] = new ReportParameter("PersonelTip", "2");
parameters[3] = new ReportParameter("parafli", "1");
wuc_rapor_genel1.param_reportParam = parameters;//this is my usercontrol
on the controller, i am passing my string array to the view using ViewData.
[Code]....
on the view, i cated the viewdata to string array, and made a select list.
[Code]....
but if i run the website, i get this error :
[Code]....
I have a ListBox on my page, and I'd like to make an AJAX post containing all the selected items. Here's my code:
[code]...
I'd like to pass in the selected values either as an array, or a comma-delimited string. What's the best way to pass that data, and how can I do it?
Via the button1_ click event I retrieve all files in a directory (Example Follows)
[Code]....
I now need to check whether this filename exists as a field in a SQL Server table. For example, if the directory retrieves a file named ExampleFile.txt which does not exist in the (Table = TableFileStore;s Field = FileRetrievals) then I want to insert the filename.
How do I construct a stored procedure to pass the filename(s) into a stored procedure as a parameter? Do I need to also create an array of filenames and pass the array into my stored procedure? Does the stored procedure belong within the foreach loop?
I need to send an array of strings to a stored procedure and then use that array of strings to create a filter of the data returned.for example I need need to send the following array to the strored procedure:
[Code]....
and use that array to run the fillowing sql command:
[Code]....
How would I pass an Object or Array to a function using the ICallBackEventHandler (RaisCallbackEvent)? It allows for a string argument only, if you change it to another datatype it error out. Sample Below...
[Code]....
[Code]....
I want to extract data from table into a view. MEans i have datatime field with value '12/31/2010 12:00:00 PM' in a table .
I want to change the field format in view to Date like '12/31/2010'.
Iam using oracle 10g.
I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.
I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((
I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.
It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.
in debug mode, i noticed that it might be caused by OdbcParameter but not sure.
I have a query string which contains the value of more than one Array, I want to pass these values from Page 1 to Page 2 and then distribute the array values into new arrays on Page 2.
Here is what I have so far.
Page 1
[Code]....
[Code]....
Page 2
[Code]....
All that I get returned in EFFinal and IFFinal is System.String?
I have a user control that contains a reportviewer control.And I want to send an array of reportparameter to my user control.But I can't figure out how to do.I'm getting "Object reference not set to an instance of an object. ".My param_reportParam variable is null in usercontrol.My user control's parameter is like that ;
[Browsable(false)]public ReportParameter[] param_reportParam{ get { return _param_reportParam; } set { _param_reportParam = value; }}private ReportParameter[] _param_reportParam;
And a simple page that uses user control to show server reports is like that ;
ReportParameter[] parameters = new ReportParameter[4];//parameter number can be different parameters[0] = new ReportParameter("imza", imzalayacaklar); parameters[1] = new ReportParameter("Sayi_Son_Eki", "984"); parameters[2] = new ReportParameter("PersonelTip", "2"); parameters[3] = new ReportParameter("parafli", "1"); wuc_rapor_genel1.param_reportParam = parameters;//this is my usercontrol
I'm passing several variables thru the URL and want to use them in several SQL Queries that I want in my asp page. For example one of the (hypotetichal) is client_id and i want to use it in a query to gather other information.
View 1 Replies
