Asynchronous Operation in UdpClient in ASP.Net - ASP.NET Discussion Boards

First Prev Next

Re: How to publish the aspx files which are in local machines?

meeram39510-Mar-09 7:22

meeram395

10-Mar-09 7:22

Thanks. It worked well. I performed all the above steps and it is working fine now.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

how to save excel file in database?

anujbanka17848-Mar-09 21:06

anujbanka1784

8-Mar-09 21:06

i want full file in database not only file name how can we do it.

Re: how to save excel file in database?

Jack Li8-Mar-09 22:24

Jack Li

8-Mar-09 22:24

you want export excel file from database, example application in this web,you'll search keyword of database to excel. I do it also.

Web config connection?

Karthick_gc8-Mar-09 20:54

Karthick_gc

8-Mar-09 20:54

Hi,
I write connection coding in Web config file.

The code is

<connectionstrings>
<add name="conn" connectionstring="Data Source=techdbserver;Initial Catalog=project;<br mode=" hold=" /> user name=sa;password=sa;<br mode=" providername="System.Data.SqlClient">

When i called it in the web form as

con = new SqlConnection(ConfigurationManager.ConnectionString["conn"].ConnectionString);

the following error appears.

'System.Configuration.ConfigurationManager' does not contain a definition for 'ConnectionString'

Can any one tell whats the error?

Re: Web config connection?

Padmanabh Ganorkar8-Mar-09 21:01

Padmanabh Ganorkar

8-Mar-09 21:01

Hi,

You have not posted the code you wrote in Web.config file.
Secondly Please note and correct the syntax for accessing the connection string from web config in C#

con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);

Thanks
Padmanabh

Re: Web config connection?

Jack Li8-Mar-09 22:32

Jack Li

8-Mar-09 22:32

<br />
con = new SqlConnection(ConfigurationManager.ConnectionString["conn"].ConnectionString);<br />

This code contain two 'ConnectionString', So error appears does not contain a definition for 'ConnectionString'

it's right:

<br />
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);<br />

Re: Web config connection?

gregor109-Mar-09 3:58

gregor10

9-Mar-09 3:58

very easy.
Don't use the ConnectionStrings.
Use ConfigurationManager.AppConfig["myconn1"] Smile | :)

Asynchronous Operation in UdpClient in ASP.Net

M. J. Jaya Chitra8-Mar-09 20:14

M. J. Jaya Chitra

8-Mar-09 20:14

Dear All,

I have a web application from which I need to send an UDP datagram.

When I send the data through Synchronous mode it is working fine.

When I use asynchronous operation it is throwing the below error:

"A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied "

The code used is:
Asynchronous:

 senderOfMessage = new UdpClient();
 IPEndPoint remoteEndPoint = new IPEndPoint(IPAddress.Parse(serverIP), Convert.ToInt32(serverPort));

 byte[] message = ASCIIEncoding.ASCII.GetBytes("Test Message");

senderOfMessage.BeginSend(message, message.Length, new AsyncCallback(OnSend), remoteEndPoint);

Synchronous:

//senderOfMessage.Send(message, message.Length, remoteEndPoint);

Kindly help me to get rid of this issue.

Thanks a lot in advance.

Best Regards,
M. J. Jaya Chitra

Re: Asynchronous Operation in UdpClient in ASP.Net

N a v a n e e t h8-Mar-09 20:31

N a v a n e e t h

8-Mar-09 20:31

What are you trying to achieve by using UDP in a ASP.NET application?

Navaneeth

How to use google | Ask smart questions

Re: Asynchronous Operation in UdpClient in ASP.Net

M. J. Jaya Chitra8-Mar-09 20:39

M. J. Jaya Chitra

8-Mar-09 20:39

Dear Navaneeth,

I have to send a message to a windows service, the windows service in turn sends a message to another external application which is not developed in .Net.

For sending the message to external application it used the UDP, so the same UDP is used o receive the message from the web application too in the window service.

Best Regards,
M. J. Jaya Chitra

To read excel

Krishna Varadharajan8-Mar-09 20:06

Krishna Varadharajan

8-Mar-09 20:06

Hi,

I uploaded my excel file into a folder(server), now i want to read that file from the folder, than i have to insert that excel into a database with same filds,

I have done this but from local system i can able to read a file not from the uploaded folder.

So how to read a excel file from folder....
Below code is the one i have used from local system, the connections string

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:/valuefirst.xls';Extended Properties=Excel 8.0"; (its working)

How to take this excel sheet from server folder.

Pls help me,

thanx

krishna

Re: To read excel

Christian Graus8-Mar-09 20:35

Christian Graus

8-Mar-09 20:35

krishnavaradharajan wrote:
I have done this but from local system i can able to read a file not from the uploaded folder.

You can write a page that takes an id and feeds the excel file to the client from your DB.

Christian Graus

Driven to the arms of OSX by Vista.

Re: To read excel

Krishna Varadharajan8-Mar-09 20:44

Krishna Varadharajan

8-Mar-09 20:44

Thanks for ur reply.....

the connection string wht i given was this..
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='

c:/valuefirst.xls

';Extended Properties=Excel 8.0"; (its working)

Aboue connection string is for reading from localsystem, so if i want to read from server folder the link wht can i give in Data Source.

And i tryed by giving complete link like below..

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://justmypixels.com/escorts/sms/sms.xls; Extended Properties=Excel 8.0";

It was showing the error like "Invalid internet address."

Can u pls short this out....

Thanx

krishna

Re: To read excel

Jack Li8-Mar-09 22:54

Jack Li

8-Mar-09 22:54

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:/valuefirst.xls';Extended Properties=Excel 8.0"; (its working)

This file working from local system, but uploaded to server folder happened error,

1.Don't find file, Data Source path is error, you'll use server map path.
2.is it Uploaded file in folder?check this file.

exception in stored procedure

NRHSR8-Mar-09 19:47

NRHSR

8-Mar-09 19:47

Procedure or Function 'SubmitRecord1' expects parameter '@ID', which was not supplied.this is the error i am getting while insert into data base using stored procedure can any body help me plz...

Re: exception in stored procedure

N a v a n e e t h8-Mar-09 19:49

N a v a n e e t h

8-Mar-09 19:49

NRHSR wrote:
Procedure or Function 'SubmitRecord1' expects parameter '@ID', which was not supplied

How can an error message be more clear?

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: exception in stored procedure

monu nair8-Mar-09 19:50

monu nair

8-Mar-09 19:50

pass parameter '@ID' value to Procedure or Function 'SubmitRecord1'

Mahendra Bisht.

Re: exception in stored procedure

Christian Graus8-Mar-09 19:50

Christian Graus

8-Mar-09 19:50

I recommend a job at McDonalds. It seems that computing is too hard for you. The error means what it says.

Christian Graus

Driven to the arms of OSX by Vista.

Re: exception in stored procedure

_Maxxx_8-Mar-09 20:43

_Maxxx_

8-Mar-09 20:43

"What do you mean, 'I din't give you any fries?'

Nah - too complex.

___________________________________________
.\\axxx
(That's an 'M')

Re: exception in stored procedure

NRHSR8-Mar-09 22:55

NRHSR

8-Mar-09 22:55

Procedure or Function 'SubmitRecord1' expects parameter '@ID', which was not supplied. this is the exception i am getting when i run.and my code is

protected void Submit1_ServerClick(object sender, EventArgs e)
{
string constr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd = new SqlCommand("SubmitRecord1", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter sp1 = new SqlParameter("@ID",SqlDbType.NVarChar,10);
sp1.Value = TextBox1.Text;
SqlParameter sp2 = new SqlParameter("@Password",SqlDbType.NVarChar,50);
sp2.Value = TextBox2.Text;
SqlParameter sp3 = new SqlParameter("@ConfirmPassword",SqlDbType.NVarChar,50);
sp3.Value = TextBox3.Text;
SqlParameter sp4 = new SqlParameter("@EmailID",SqlDbType.NVarChar,200);
sp4.Value = TextBox4.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//cmd.ExecuteNonQuery();
}
my stored procedure is

CREATE PROCEDURE dbo.SubmitRecord1
(
@ID varchar(10),
@Password varchar(50),
@ConfirmPassword varchar(50),
@EmailID varchar(200)
)
AS
INSERT INTO login1(ID,Password,ConfirmPassword,EmailID)VALUES(@ID,@Password,@ConfirmPassword,@EmailID)
RETURN

i am passing parameter ... then also its throwing exception......
can any body help me ...

Re: exception in stored procedure

_Maxxx_8-Mar-09 23:57

_Maxxx_

8-Mar-09 23:57

You're not adding any of the parameters to the command object

something like

cmd.Parameters.Add(sp1);

(Look it up - I don't have an example in front of me - but that's the issue here - upir cmd object doesn't know about the parameters.

___________________________________________
.\\axxx
(That's an 'M')

Re: exception in stored procedure

NRHSR9-Mar-09 0:33

NRHSR

9-Mar-09 0:33

protected void Submit1_ServerClick(object sender, EventArgs e)
{
string constr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd = new SqlCommand("SubmitRecord1", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.NVarChar,10).Value = TextBox1.Text;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50).Value = TextBox2.Text;
cmd.Parameters.Add("@ConfirmPassword", SqlDbType.NVarChar, 50).Value = TextBox3.Text;
cmd.Parameters.Add("@EmailID", SqlDbType.NVarChar, 200).Value = TextBox4.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}

stored procedure
ALTER PROCEDURE dbo.SubmitRecord1
(
@ID varchar(10),
@Password varchar(50),
@ConfirmPassword varchar(50),
@EmailID varchar(200)
)
AS
INSERT INTO login1(ID,Password,ConfirmPassword,EmailID)VALUES(@ID,@Password,@ConfirmPassword,@EmailID)
RETURN

this worked fine.....
for reference u can see link

Thanks any ways

about gridview [modified]

prateekfgiet8-Mar-09 19:38

prateekfgiet

8-Mar-09 19:38

i m using asp.net with c# and in backend using sql server 2000.
i have a table1(material_incoming) and i m using gridview for showing data of table1,when i click edit button at gridview,present value save in table2(edit_tab)with remark "before edit" and after updation,updated value save in table2 with remark "after edit" and also update table1.

prateek srivastava
prateekfgiet@gmail.com

modified on Monday, March 9, 2009 3:20 AM

Re: about gridview

N a v a n e e t h8-Mar-09 19:47

N a v a n e e t h

8-Mar-09 19:47

I am sorry, but your question makes no sense. Try to rephrase it.

Navaneeth

How to use google | Ask smart questions

Re: about gridview

Christian Graus8-Mar-09 19:49

Christian Graus

8-Mar-09 19:49

Is this a question ? If it is, is it a 'I did some research and tried this but it doesn't work' question, or an 'I'm a dumbass, do my job for me' question ?

Christian Graus

Driven to the arms of OSX by Vista.

Last Visit: 31-Dec-99 18:00 Last Update: 2-May-24 2:19

Refresh

ᐊ Prev 1...2237 2238 2239 224022412242 2243 2244 2245 2246 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.