ASP.NET

15-Oct-09 0:46

Try this Link It May Help..!
http://social.expression.microsoft.com/Forums/en-US/web/thread/728e3f44-1f03-4f70-b19a-cb3763aea426[^]

MyFirstArticlePublished: MenuControlSelectedItem
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Sending Mail

sharmilajv11-Oct-09 21:45

11-Oct-09 21:45

How to send mail to all the Registered users at the same time?

Abhijit Jana11-Oct-09 21:52

11-Oct-09 21:52

sharmilajv wrote:
How to send mail to all the Registered users at the same time?

Try This[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

dan!sh 11-Oct-09 21:56

11-Oct-09 21:56

Open your mail client, type the mail, type email addresses of intended users and click on send. Poke tongue | ;-P

Seriously, aren't there thousands of example on web?

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

sharmilajv11-Oct-09 21:59

11-Oct-09 21:59

im a fresher so i askd..

dan!sh 11-Oct-09 22:13

11-Oct-09 22:13

You missed the joke icon in my post.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Abhijit Jana11-Oct-09 22:47

11-Oct-09 22:47

sharmilajv wrote:
im a fresher so i askd..

You should read forum guidelines before asking any question. If you ask over here you will definitely get help from members but before that you should search on Google or this forum itself. The question you have asked is very common and there are thousands of example available on net. So you should try them first. if stuck just ask here. you will get many helps !

Good luck !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

sharmilajv11-Oct-09 23:03

Re: linkbutton query string

11-Oct-09 23:03

ok Thank You.

linkbutton query string

m@dhu11-Oct-09 21:00

m@dhu

11-Oct-09 21:00

following is link button with one value posted from one page to another.
how to post multiple values plz let me know....

<asp:LinkButton ID="LinkButton2" runat="server" PostBackUrl='<%# "~/Default.aspx?username="+Eval("username")%>' CommandName="edit" Text="<img src='images/edit.gif' style='border-color:white' alt='Edit'/>"></asp:LinkButton>

sashidhar11-Oct-09 21:52

11-Oct-09 21:52

madhukk wrote:
how to post multiple values plz let me know....

Use

"Default.aspx?Username=YourValue&Id=YourID"

Or Store the values in Array List and access it.

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

[Message Deleted]

bhavnvyas11-Oct-09 20:46

bhavnvyas

11-Oct-09 20:46

[Message Deleted]

Re: Hi all

Abhijit Jana11-Oct-09 21:03

getting ID of inserted record

11-Oct-09 21:03

bhavnvyas wrote:
how to send report mail from sql server 2008..
plz help me...

How does it related with ASP.NET ? Please ask this on General Database Forum !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

uglyeyes11-Oct-09 20:10

uglyeyes

11-Oct-09 20:10

Hi All,
In below code I am not getting inserted primaryKey AutoID in for dbRow("ImageId"))
could anyone please help or advise what I am doing wrong?

thanks

Private Function WriteToDB(ByVal strName As String, ByVal strType As String, ByRef Buffer As Byte()) As Integer
            Dim nFileID As Integer = 0

            ' Create connection
            Dim sqlConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("conString").ConnectionString)

            ' Create Adapter
            Dim sqlDataAdapter As New SqlDataAdapter
            Dim dataSet As New DataSet()
            Dim dbCB As New SqlCommandBuilder
            Dim sqlCommand As New SqlCommand
            Try

                  sqlConnection.Open()

                  sqlCommand = New SqlCommand("SELECT * FROM Image", sqlConnection)
                  sqlDataAdapter = New SqlDataAdapter(sqlCommand)
                  dbCB = New SqlCommandBuilder(sqlDataAdapter)
                  sqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
                  sqlDataAdapter.Fill(dataSet, "Image")

                  ' Get reference to our table
                  Dim dbTable As DataTable = dataSet.Tables("Image")
                  'dbTable.PrimaryKey = New DataColumn() {dbTable.Columns("ImageId")}

                  ' Create new row
                  Dim dbRow As DataRow = dbTable.NewRow()

                  ' Store data in the row
                  dbRow("ImageName") = strName
                  dbRow("ImageSize") = Buffer.Length
                  dbRow("ImageType") = strType
                  dbRow("ImageData") = Buffer

                  ' Add row back to table
                  dbTable.Rows.Add(dbRow)

                  ' Update data source
                  sqlDataAdapter.Update(dataSet, "Image")

                  ' Get newFileID
                  If Not dbRow.IsNull("ImageId") Then
                        nFileID = CInt(dbRow("ImageId"))
                  End If

                  ' Close connection
                  sqlConnection.Close()

                  ' Return FileID
                  Return nFileID
            Catch ex As Exception
                  Response.Write(ex.Message.ToString)
            End Try
      End Function

Dll method is not making a connection with the host server.

shrish garg11-Oct-09 20:05

shrish garg

11-Oct-09 20:05

Hi All,
I am working on a project in which i made a .net dll named DLLA. A method of this dll calls a method of another .net dll named DLLB. DLLB consists a method MakeConnection() which calls a method Get() of the IBM WebSphereMQ's "amqmdnet.dll" which is used to make the connection with the server host.
When I calls this method by running my code directly it works properly and make the connection but if i am publishing the project and made a virtual directory. After this if i call the same method it does not make the connection with the host and shows the error "CompCode: 2, Reason: 2058". If anybody have any Idea about the problem please let me know

Thanks in advance
Shrish

insert thousand records on single click

sjs4u11-Oct-09 19:37

sjs4u

11-Oct-09 19:37

Hi,

I have an application in which I am inserting 1000 records by using for loop. Is there any another way to Insert 1000 records i.e. any Bulk Insert method. Because my Page process become too slow when insertion take place.

Or Is there any other way for insertion.

Thanks
sjs

Re: insert thousand records on single click

dan!sh 11-Oct-09 19:48

Re: insert thousand records on single click [modified]

11-Oct-09 19:48

You can find plenty through google. OpenXML is one way of doing this. If the insert is taking time, you can do that on a separate thread.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

bhavnvyas11-Oct-09 21:49

bhavnvyas

11-Oct-09 21:49

USE [iLOS]
GO
[dbo].[sp_InsertData] Script Date: SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_InsertData]
(@xmlString VARCHAR(MAX))
AS
BEGIN
/* Initialize a handle for the XmlDocument */ 
DECLARE @xmlHandle INT 
/* 
Create a table variable to store the extract XmlData into Relational 
Database Format. Unlike temporary tables, Table variables are 
automatically removed from memory by SQL Server when the procedure 
has completed. So, there is no need to try and drop them at the 
end of the procedure. 
*/ 
DECLARE @stagingTable TABLE 
( 
[Name] VARCHAR(50), 
[Address] VARCHAR(50), 
[Phone] VARCHAR(50)
) 
/* 
Create the XmlDocument using the handle above and the Xml 
string as parameters. If your stored procedure has an varchar input 
parameter named @xmlString, it would look like this instead: 
EXEC sp_xml_preparedocument @xmlHandle output,@xmlString 
*/ 
EXEC sp_xml_preparedocument @xmlHandle output, @xmlString 
/* 
Use the OPENXML method to query the XmlDocument starting at 
/NewDataSet/SampleDataTable node.
*/ 
INSERT INTO @stagingTable 
SELECT [Name] ,
[Address],
[Phone] 
FROM OPENXML (@xmlHandle, '/NewDataSet/SampleDataTable',1) 
WITH ([Name] varchar(50) '@Name', 
[Address] varchar(50) '@Address', 
[Phone] varchar(50) '@Phone'
)

/*Insert the records into the table variable turning the XML structured 
data into relational data. We are now free to query the table variable 
just as if it were a regular table for use with data manipulation, cursors, etc... 
It could also be used for generated reports and counts in ways that might 
be simpler to code in SQL Server vs XSL.*/ 
INSERT INTO SampleData ([Name], 
[Address], 
[Phone]) 
(SELECT [Name] ,
[Address],
[Phone]
FROM @stagingTable)


/* Remove the document from memory */ 
EXEC sp_xml_removedocument @xmlHandle
END

hi first insert all records in som xml file and thn use above sp i think it might work in your case..

modified on Monday, October 12, 2009 4:38 AM

Re: insert thousand records on single click

sashidhar11-Oct-09 22:01

Get the moving mouse position

11-Oct-09 22:01

While You Are Replying Use Code Block So It will be more clear..!
Cool | :cool:

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

lbs.allies11-Oct-09 18:58

lbs.allies

11-Oct-09 18:58

I have two windows forms and I need to get the changing mouse position at the same time in the next form. I am using a function in the mouse move event ,so how should i properly do that..pls help me

Re: Get the moving mouse position

dan!sh 11-Oct-09 19:37

Re: Get the moving mouse position

11-Oct-09 19:37

Wrong forum.

You can have a public event handler for mouse move in your first form which you can handle in the second form to get the mouse positions.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Abhijit Jana11-Oct-09 19:37

In a literal control How i should embed a Html coding/Page?

11-Oct-09 19:37

lbs.allies wrote:
I have two windows forms

Then why are you asking this question in ASP.NET Forum ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET

sharmilajv11-Oct-09 18:23

Re: In a literal control How i should embed a Html coding/Page?

11-Oct-09 18:23

I have to send mail automatically,mail should have my design and contents change dynamically ?

sashidhar11-Oct-09 19:07

Re: In a literal control How i should embed a Html coding/Page?

11-Oct-09 19:07

sharmilajv wrote:
I have to send mail automatically,mail should have my design

Try to search in Google You Will find Toms of examples for seneding mail..!

sharmilajv wrote:
and contents change dynamically ?

Wat Abt This..!What are the contents You Want to change dynamically..!You want to chance it By Code or Web.config file Please be more clear..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

sharmilajv11-Oct-09 19:23