Quomon.com questions related to: .net

I need to pass USER defined type (Type table based on a record Type) to Oracle API using .Net

purnacm — Sun, 16 May 2010 07:24:49 GMT

Hi,

I have a requirement where I need to pass values to a Oracle user defined type TABLE from .NET.

Here is what I have ....

Oracle type
--type describes adress object
TYPE t_address IS RECORD(
  addressline1 company.address_line_1%TYPE,
  addressline2 company.address_line_2%TYPE,
  addressline3 company.address_line_3%TYPE,
  addressline4 company.address_line_4%TYPE,
  postalcode company.postcode%TYPE,
  countrycode company.country_code%TYPE);
--table of adresses
TYPE t_addresses IS TABLE OF t_address;

Here is the signature of Oracle API (Part of Oracle Package)

PROCEDURE create_distributor(
i_broadcaster_ref_usage IN broadcaster_reference.reference_usage%TYPE DEFAULT g_broadcaster_ref_usage,
i_company_key IN broadcaster_reference.broadcaster_reference%TYPE,
i_name IN company.company_name%TYPE,
i_addresses IN t_addresses, -- This is where i pass the Oracle Type
i_contact_first_name IN contact.contact_first_name%TYPE,
i_contact_last_name IN contact.contact_last_name%TYPE,
i_company_type in company.company_type%type default 'D',
i_station_id in station.station_id%type default 0,
o_company_key out company.company_id%type,
o_response_cursor OUT SYS_REFCURSOR) IS

In .Net I tried it this way

Int32 companykey = 0;
t_response.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
t_address.CollectionType = OracleCollectionType.PLSQLAssociativeArray;

string spName = "ACQUISITIONS_API.CREATE_DISTRIBUTOR";
DbCommand cmd;

OracleParameter addresses = new OracleParameter();
addresses.OracleDbType = OracleDbType.Varchar2;
// set the collection type for each parameter
addresses.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
addresses.Value = new string[6] { dist.address.addressLine1,
dist.address.addressLine2,
dist.address.addressLine3,
dist.address.addressLine4,
dist.address.postalCode,
dist.address.countryCode
};
// set the size for each array
addresses.Size = 6;

try
{
//t_address = dist.address;
cmd = database.GetStoredProcCommand(spName);
cmd.Parameters["I_BROADCASTER_REF_USAGE"].Value = "PDS";
cmd.Parameters["I_COMPANY_KEY"].Value = dist.companyKey;
cmd.Parameters["I_NAME"].Value = dist.name;
//cmd.Parameters.add(addresses);
cmd.Parameters["I_ADDRESSES"].Value = addresses;
cmd.Parameters["I_CONTACT_FIRST_NAME"].Value = dist.contactFirstName;
cmd.Parameters["I_CONTACT_LAST_NAME"].Value = dist.contactLastName;
cmd.Parameters["I_COMPANY_TYPE"].Value = "D";
cmd.Parameters["I_STATION_ID"].Value = "0";

database.LoadDataSet(cmd, resultDataSet, new string[] { "Result" });

if ((cmd.Parameters["O_RESPONSE_CURSOR"].Value != null))
{
return resultDataSet.GetXml().ToString();
}
}
catch (OracleException ex)
{
throw RaiseException("web.pilatmedia.com", "ProgramAPI", ex.Message, ex.Number.ToString(), "SampleWithCustomException()", FaultCode.Server);
}

I'm getting following error

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: OracleParameter.Value is invalid
at Oracle.DataAccess.Client.OracleParameter.ResetCtx(Int32 arraySize)
at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn, IntPtr errCtx, Int32 arraySize)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Pilat.Data.Oracle.PilatDatabase.DoLoadDataSetCore(DbCommand command, DataSet dataSet, String[] tableNames)
at Pilat.Data.Oracle.PilatDatabase.DoLoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Pilat.Data.Oracle.PilatDatabase.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at DiscoveryWebService.Service2.createDistributor(Distributor dist)
--- End of inner exception stack trace ---

Can you please help me with this?
I'm not sure whether this is the correct way of mapping Oracle user defined types.

Thanks,

ISO 8583 Parser

techguy0727 — Thu, 06 May 2010 05:13:48 GMT

Hi,

I'm building an application to parse ISO 8583 messages (version 1993), do you have available tool that can help me to deliver my project in fastest option? I'm using C# in .Net Framework 2.0.

Regards,
techguy

what will do init event i .net

habeebcse07 — Thu, 04 Mar 2010 08:41:12 GMT

what will do init event in .net

Anybody has experience with Facebook connect?

SwingKing — Sun, 01 Nov 2009 15:05:39 GMT

I'm just wondering how easy it is to integrate with an asp.net website and how you manage the users that come from Facebook, since they don't give you neither password or real email.

how can i get my application to start up automatically when windows starts?

dustPuppy — Tue, 19 May 2009 14:10:15 GMT

I'm developing a .net application that needs to start up when windows is started.
How can I accomplish that?

I need to integrate a virus scanner into my .net application. How do I do that?

theDude — Tue, 19 May 2009 10:44:52 GMT

Hi,

I need to let people upload files to my asp.net website and afterwards scan them with an antivirus scanner. I was wondering if I need some special license for that or most antivirus products come with a command line tool that I could call through the website?
If you have any concrete experience, I would also love to hear about it.

Thanks in advance.

setting read/write permissions for a windows user programatically in c# .net?

dustPuppy — Wed, 18 Mar 2009 10:01:15 GMT

Hi guys,

I need to give a specific windows user writing permissions to a particular folder.
I'm developing in C#.net.
How do I go about that?

thanks in advance...

How do I copy everything within a folder to another folder using c#.net?

dave — Tue, 17 Mar 2009 08:12:59 GMT

I need to copy all files, folders etc. within a specific folder to another folder.
How do I accomplish this with C# in .net?
I was trying to use the Directory class, but can't see any method for this purpose.

I'm using .net 2.0

Hope you can help...

how do i create windows taskbar notifications in .net?

Anpanman — Wed, 11 Mar 2009 12:22:59 GMT

Hi,

I need to create a windows application that can popup these small notifications on the lower right of the desktop where the icons are. As far as I can see they're called taskbar notifications, but I don't know how to show a notification there in .net with C#.

Can you help me out?

how to export gridview data's into Excel?

priyaravi2008 — Tue, 10 Mar 2009 01:30:50 GMT

i want to export gridview data's into excel using asp.net with c#

i want to insert bulk of records into table?thank you

priyaravi2008 — Fri, 06 Mar 2009 23:02:34 GMT

I want to insert 10 records based on some condition

sending an email in .net: the specified string is not in the form required for a subject?

dustPuppy — Wed, 04 Mar 2009 11:38:17 GMT

I'm getting this error when trying to send out an email with .net 2.0:

the specified string is not in the form required for a subject

Do you know what could be wrong?

intermittent web.config error: Could not create Windows user token from the credentials specified

Anpanman — Mon, 12 Jan 2009 07:39:43 GMT

Once in a while I get this error on my asp.net site:
Could not create Windows user token from the credentials specified in the config file

Do you have any idea what it could be?

How do Save info from datagridview and textbox in sql 2000 databse

decklonarankk — Sat, 06 Dec 2008 11:08:42 GMT

My form has one(1) datagridview and 7 textboxes and i need to save info. from the datagridview as well as textboxes into the database. Pls help

how do i open a file dialog in .net (a windows application)?

dustPuppy — Tue, 18 Nov 2008 05:46:32 GMT

Hi,
I need to open a file dialog in a windows application for the user to choose a path to export a file to.
How do I do that? The FileDialog class is abstract...

Thanks,
dust

How do I get the local server ip adress in asp.net?

dustPuppy — Thu, 06 Nov 2008 04:47:47 GMT

I need to know the ip address of the server the application is running on. How do I get that in asp.net (c#)?

What is a good source for a profanity filter that takes all possibilities into account?

mary2 — Fri, 31 Oct 2008 05:13:02 GMT

I am looking for a script (preferably .Net) that will take all possible profanity instances into account that I can drop into my website.

Dynamically I created ASP.NET user control using ASP.NET Ajax and Web Service

kalpana — Wed, 15 Oct 2008 10:07:23 GMT

Dynamically I created ASP.NET user control using ASP.NET Ajax and Web Service

but I got an error on onclick of the asp button

Error:

The state information is invalid for this page and might be corrupted.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The state information is invalid for this page and might be corrupted.

Please Reply if u found solution for this

Using web part in web server is not possible

vijayakumar — Tue, 14 Oct 2008 06:42:22 GMT

i am new to .net i am trying implementing webparts it is working in local server but i can not able to publish the website while using webparts

regular expressions tester for .net - c#?

dustPuppy — Fri, 03 Oct 2008 04:53:08 GMT

Hey guys,

I'm looking for some program or online page to be able to test my regular expressions easily since they're so complicated to create and debug.
Do you know of any tool or website that has this?

thanks,
dustPuppy

i have forgotten my yahoo security answer.. anyways to reset password? pls let me know its urgent!!

naveedbb073084 — Thu, 25 Sep 2008 06:22:19 GMT

its my old email... now it seems i have got an imp mail there... n i have forgotten the password... when i tried to reset password, i could give my birthdate n zip but i dont remember my security answer... is there anyways to get my mails from there or to reset password???

add a wireless print/copy machine to my laptop

amberjane56 — Tue, 23 Sep 2008 15:59:17 GMT

I am trying to get my personal laptop to print to a copy/ printer machine here at my work. I have no idea how to get it even started. I have seen it done before where people send things to a certain printer not even connected to their computer. Could someone please help me out??

how to call function in .aspx.cs from ascx.cs

ajapprog — Thu, 04 Sep 2008 07:53:22 GMT

i have function in .ascx.cs i want to use this function in page.aspx
thank u

my moniter is blasting when connect to pc

ali03214372750 — Thu, 21 Aug 2008 01:52:34 GMT

actually here in our area there is very load shading for that purpose this problem is create

how to read the contents of filepath passed at run time

dineshkumarmani — Mon, 11 Aug 2008 22:57:40 GMT

i want to read the resume contents of the corresponding filepath that is uploaded at runtime? say

slow asp.net site, render method takes forever

dustPuppy — Sat, 09 Aug 2008 12:38:04 GMT

I have a strange problem with a website I'm developing in asp.net (C#).
Basically when uploaded to the server, the render method suddenly takes 15 sec. to execute, but not on all the pages. I'm not overloading the method, so it's pure standard asp.net rendering and i've never experienced something like this before.
Do you have any idea about what it could be?

windows service and file format exception.

mythilimythili — Mon, 04 Aug 2008 13:10:26 GMT

I have a windows service that reads the files in directory on one server and loads them into another. So I' m using these lines of code to accomplish this. The problem is that I' m getting the format of the path specified is not the correct format. I' m not able to correct this all help would greatly be accomplished.
thanks
amulu
protected void CopyImage()
{

// DAImage da = new DAImage();
string stylenum = "";
int itemid = 0;
stylenum = "200899-01";
string filenum = "";
string newfilename = Guid.NewGuid().ToString () ;
int index = 0;
try
{

string[] files = System.IO.Directory.GetFiles(("\\\\Ccsrv2\\publicfiles\\All\\MARKETING\\Pr
oduct Images\\Style Images\\August 2008 Market\\Test"));
//(@"C:\\Documents and Settings\\mduddebanda\\My Documents\\My Pictures\\DeleteFolder");

foreach (string file in files)
{
index = file.IndexOf(".");
filenum = file.Remove(index, 3);
index = file.Length;
filenum = file.Replace("\\", "");
index = filenum.Length;

filenum = filenum.Substring(index - 13, 9);

//filenum=file.Remove(index);
//Response.Write(filenum);
DataTable dtitem = DAImage.GetItembyStylenum(filenum);
foreach (DataRow dr in dtitem.Rows)
{
stylenum = (dr[0].ToString());
itemid = Convert.ToInt16(dr[1].ToString());
}

if (filenum == stylenum) // get the stylenum in the required format from the file here
{
//Get the image id for the image to be inserted into the table.
DataTable dt = DAImage.GetImageId();
string result = "";
foreach (DataRow dr in dt.Rows)
{
result = dr[0].ToString();
}

// System.IO.Directory.CreateDirectory(@"C:\\Documents and Settings\\mduddebanda\\My Documents\\My Pictures\\DeleteFolder\\tbl" + itemid);
//System.IO.File.Copy(file, @"\\Pdserver.tsiag.com\d$\Library\tbl" + itemid + "\" + filenum + ".jpg");

System.IO.Directory.CreateDirectory(@"\\Pdserver\\d:$\\devlibrary\\tblItem
" + itemid);
// System.IO.File.Copy(file, @"C:\\Documents and Settings\\mduddebanda\\My Documents\\My Pictures\\DeleteFolder\\tbl" + itemid + "\\" + newfilename + ".jpg");
// System.IO.File.Copy(file, "\\\\Pdserver\\d$\\devlibrary\\tblItem" + itemid + "\\" + newfilename.ToString() + ".jpg");
System.IO.File.Copy(file, @"\\Pdserver.tsiag.com\\d:$\\Library\\tbl" + itemid + "\\" + filenum + ".jpg");
DAImage.InsertImage("\\tblItem" + itemid + "\\" + newfilename.ToString() + ".jpg", itemid);
System.IO.File.Delete(file);
}
//select * from tblImage where imageid= (select max(imageid) from tblImage )
//Insert into the tblImage for that imageid and for that category.
//then delete this file from The j:/ directory.

}
}
catch (Exception ex)
{
throw ex;
}
}

setup creation

samesandy — Fri, 04 Jul 2008 03:30:46 GMT

hi dear can u explain me that can i make setup of web application as i can do in windows application in .net

I get a COMException: The "SendUsing" configuration value is invalid when i try to send out email

dave — Fri, 27 Jun 2008 09:16:21 GMT

I'm developing in asp.net and i'm trying to send out an email.
Do you know that this message means?

how do i set my asp.net site to show a maintenance page, while it's offline?

dave — Thu, 26 Jun 2008 13:57:23 GMT

is there any way to do this though the web.config file?

hi I am pankaj Singh

pankajchampion82 — Sun, 25 May 2008 03:59:17 GMT

Hi
Mam I want to learn c#.net and web programming for u . I want a Help regarding programming

      Yours's
      Pankaj Kumar Singh

what is the main difference between asp&asp.net?

suryahills — Sat, 03 May 2008 05:58:32 GMT

what is the main difference between asp&asp.net?

RETRIEVE THE PROPERTIES OF OBJECTS IN MSSQL 2005

georgemathew2 — Tue, 19 Feb 2008 13:01:01 GMT

I WANT TO GET THE PROPERTIES OF ALL THE SQL OBJECTS LIKE Backup Devices,Rule,Full Text Catalog,Full Text Services,Language ETC..
HOW CAN I RETRIEVE IT USING SMO OR BY THE QUERY

about socket communication in Windows service

pvenkatesh2k4 — Thu, 14 Feb 2008 03:20:31 GMT

hi i am new to .Net development. i need to develop an service which need to listen for incoming socket connection. i implemented this process in onstart event .. but it hangs for particular time whan the service starts and says "service could not be started". please help how to make service to listen on the port please help.

about creating a service using C#

pvenkatesh2k4 — Tue, 29 Jan 2008 03:28:19 GMT

hai,
i am new to .Net programming. Now i need to build an service which is to listen the receiving messages of SMS Gateway and perforam actions based on the incoming message. Lets say SMS Gateway software is running in some Port. How to do that.. Please give reference to that.
thank you

about creating a service using C#

pvenkatesh2k4 — Tue, 29 Jan 2008 03:13:14 GMT

hai to all
i am new to .Net . i need to develop an service which is to listen the SMS Gateway software which is running in a specific port/IP Address. How to do that? Please help me. Is there any reference(link) to learn it? if so,Please specify it

Remove cookies

ravishiva1 — Mon, 21 Jan 2008 23:03:14 GMT

my need is whenever i redirect to some page from hame page,i want delete home page cookies from client.... what can i do?

I want help to run a movie which needs a divocodec file,please help.How do i play the movie ?

premash1906 — Fri, 11 Jan 2008 07:22:45 GMT

I have recently downloaded a movie called 27 dresses which requires a divocodec file..i tried downloading dwconverter from wildmann productions but not working fine..i have downloaded divocodec though..please suggest as to how should i approach sovling this problem...its urgent.

no puedo oir musica

sandraisabeles — Wed, 02 Jan 2008 21:12:20 GMT

como le puedo hacer para escuchar musica en linea

Please Help! My windows service has permissions problems running a macro in an Excel spreadsheet.

bakershack — Tue, 27 Nov 2007 12:48:14 GMT

I have a macro in an Excel spreadsheet that connects to an OPC server to retrieve data. I works just fine when I run it manually, or when I run it programmatically from a standard windows program. But when I try to do it from a service (running the same code as the standard windows program), it fails.

If I run the service from the Local System account, it opens the spreadsheet but completely loses track of the Excel object and cannot close it. If I then check "Allow service to interact with Desktop", it opens the spreadsheet and runs the macro, but the macro then doesn't have permission to access the OPC server. If I run the service from the Administrator account, the service does nothing - no event log entries or anything. Can someone PLEASE help me quickly with this?

Custom paging control for asp.net 2?

dustPuppy — Thu, 02 Aug 2007 12:51:58 GMT

I'm looking for a custom paging control for asp.net to use with a gridview. I understand the idea of how to create custom paging, but I was hoping to find an open source version that I only had to adapt instead of starting from scratch.
Do you guys know of any?

how to verify that an internet connection exists from a windows .net application?

dustPuppy — Fri, 27 Jul 2007 10:56:52 GMT

I need to verify in the user is connected to the internet.
What is the best, i.e. quickest way to do this?

Can I create a masterpage template in asp.net for usercontrols as well?

dustPuppy — Thu, 19 Jul 2007 04:11:09 GMT

I need to make a general template for a range of usercontrols that I use on a site that I'm developing.
I know that with the masterpage i can create the template for the whole site, but can it be used on a usercontrol level as well? or how do I make a template for usercontrols?

how to create a windows service program?

theDude — Fri, 13 Jul 2007 10:20:00 GMT

I need to create a program that can be installed as a windows service, not as a normal desktop program.
I'm using .net and C#.
How do I do that?

Are there any tools to convert HTML to Flash

iti114 — Tue, 10 Jul 2007 14:20:14 GMT

Looking for tool to convert HTML to Flash (dynamically via API)

From a windows .net application is it possible to detect if the application is already running?

theDude — Tue, 03 Jul 2007 13:06:24 GMT

I am developing a windows .net program (in c#) and I was wondering if it is possible to detect on startup if the program is already running, so that the user is not allowed to run two instances of it at once?
How is that done?

How do I create a text file with UTF7 encoding in c# .net?

dustPuppy — Wed, 20 Jun 2007 03:36:37 GMT

I need to create a text (.txt) file with UTF7 encoding (I think the default is UTF8).
I'm developing with c# .net.
How do I do that?

javascript work with Firefox?

karbagamoorthy — Wed, 20 Jun 2007 01:56:28 GMT

Any idea how to make that javascript work with Firefox?

Cheers,DK Moorthy

how to give custom gradient effect background to datagridview header in windows .net2.0?

webmavin — Thu, 14 Jun 2007 13:41:48 GMT

how to give custom gradient effect background to datagridview header in windows .net2.0?

How to Identify the browser using java script (for IE/Safari/Firefox)

neerusaini — Thu, 14 Jun 2007 06:33:22 GMT

How to Identify the browser using java script (for IE/Safari/Firefox)