Re: error is \\The parameterized query '(@img_type nvarchar(4000),@img_stream nvarchar(4000))INSERT INTO' expects the parameter '@img_type', which was not supplied. - ASP.NET Discussion Boards

First Prev Next

ASP.Net Server control

Amit Patel198512-Jun-09 1:55

Amit Patel1985

12-Jun-09 1:55

Can any one help me
How to create server control at run time in ASP.Net 2.0

Re: ASP.Net Server control

saanj12-Jun-09 2:19

saanj

12-Jun-09 2:19

Checkout the article by Niladri Biswas:

http://www.c-sharpcorner.com/UploadFile/mail2nil123/dynamicControlByHttpModule04052009084839AM/dynamicControlByHttpModule.aspx[^]

There is no foolish question, there is no final answer...

Re: ASP.Net Server control

Abhijit Jana12-Jun-09 3:20

Abhijit Jana

12-Jun-09 3:20

Amit Patel1985 wrote:
How to create server control at run time in ASP.Net 2.0

Which control you want to create ? Create the object of that control class, set the properties and add them to the page. Smile | :)

Be careful when you creating control at runtime. You should take care of view state of the control and its depends in which event you are creating them. Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Generating word document and saving to a particular location in c#.net

YazhiniP12-Jun-09 1:04

YazhiniP

12-Jun-09 1:04

Hi,

I have to generate a word document dynamically in .Net.
I have to write the contents of the GridView to the Word document.
I am able to do all but,the problem is i have to save the file automatically to a particular folder than saving the File via the FileDialog box.
Can anyone please tell me that how to store the word file automatically to a particular location?
I have given the code below.

            string attachment = "attachment; filename=" + strFilePath;

            Response.ClearContent();

            Response.AddHeader("content-disposition", attachment);

            Response.ContentType = "application/ms-word";

            StringWriter sWriter = new StringWriter();

            HtmlTextWriter htwWriter = new HtmlTextWriter(sWriter);

            gvRCA.RenderControl(htwWriter);

            Response.Write(sWriter.ToString());

            Response.End();

Yazhini

Re: Generating word document and saving to a particular location in c#.net

Christian Graus12-Jun-09 1:15

Christian Graus

12-Jun-09 1:15

YazhiniP wrote:
the problem is i have to save the file automatically to a particular folder than saving the File via the FileDialog box.

You should never tell the client yes, unless you know enough about what you're doing, to know that it's possible. In this case, it's not possible. Imagine if it was, if every website could just put files into your file system without asking you first.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: Generating word document and saving to a particular location in c#.net

YazhiniP12-Jun-09 1:47

YazhiniP

12-Jun-09 1:47

ok...I dropped the idea of using Response object.I tried using FileStream and StreamWriter.but,how to pass the GridView object to the StreamWriter?

            FileStream fs = File.Create(path);
            fs.Close();
            StreamWriter sw = new StreamWriter(path);
            StringWriter sWriter = new StringWriter();
            HtmlTextWriter htwWriter = new HtmlTextWriter(sWriter);
            gvRCA.RenderControl(htwWriter);
            sw.Write(htwWriter);
            sw.Close();

The above code writes only System.Web.UI.HtmlTextWriter to the word file.
I am beginner in .Net and i dont know a lot.
Do u have any idea on how to do this?.
Thanks in advance... Smile | :)

Yazhini

error is \\The parameterized query '(@img_type nvarchar(4000),@img_stream nvarchar(4000))INSERT INTO' expects the parameter '@img_type', which was not supplied.

jigneshp2512-Jun-09 1:03

jigneshp25

12-Jun-09 1:03

Dim img As FileUpload = CType(imgUpload, FileUpload)
Dim imgByte As Byte() = Nothing
Dim imgtype As String = Nothing
If img.HasFile AndAlso Not img.PostedFile Is Nothing Then
'To create a PostedFile
Dim File As HttpPostedFile = imgUpload.PostedFile
'Create byte Array with file len
imgByte = New Byte(File.ContentLength - 1) {}
imgtype = New String(File.ContentType)
'force the control to load data in array
File.InputStream.Read(imgByte, 0, File.ContentLength)

End If
' Insert the employee name and image into db

c.Open()

Dim sql As String = "INSERT INTO tblImg (img_type, img_stream)VALUES (@img_type,@img_stream) "
Dim cmd As SqlCommand = New SqlCommand(sql, c)
cmd.Parameters.AddWithValue("@img_type", imgtype)
cmd.Parameters.AddWithValue("img_stream", imgByte)

Dim id As Integer = Convert.ToInt32(cmd.ExecuteScalar())
lblResult.Text = String.Format("Employee ID is {0}", id)

Re: error is \\The parameterized query '(@img_type nvarchar(4000),@img_stream nvarchar(4000))INSERT INTO' expects the parameter '@img_type', which was not supplied.

Christian Graus12-Jun-09 1:16

Christian Graus

12-Jun-09 1:16

jigneshp25 wrote:
cmd.Parameters.AddWithValue("@img_type", imgtype)
cmd.Parameters.AddWithValue("img_stream", imgByte)

What do you notice about the two parameters you're pasing in ? Yes, one has an @ and the other does not. Hence the problem.

It pays to read the error message and then assume that it's true.

Re: error is \\The parameterized query '(@img_type nvarchar(4000),@img_stream nvarchar(4000))INSERT INTO' expects the parameter '@img_type', which was not supplied.

Abhijit Jana12-Jun-09 1:20

Abhijit Jana

12-Jun-09 1:20

jigneshp25 wrote:
cmd.Parameters.AddWithValue("@img_type", imgtype)
cmd.Parameters.AddWithValue("img_stream", imgByte)

where is @ for the img_stream ? When your debugger showing the error , then click on the error, debugger redirect you to the correct line. Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Object reference not set to an instance of an object. (Use the New keyword to create object instance)

KhandelwalA12-Jun-09 0:56

KhandelwalA

12-Jun-09 0:56

Hello........I m decveloping an application in which i hav to create data table dynamically......i hav written the code the but getting the error....plz help me...code is below:-

Dim objDT As New System.Data.DataTable
Dim objDR As System.Data.DataRow

Private Sub Page_Load(ByVal s As Object, ByVal e As EventArgs)
If Not IsPostBack Then
makeCart()
End If
End Sub

Function makeCart()
objDT = New System.Data.DataTable("Cart")
objDT.Columns.Add("ID", GetType(Integer))
objDT.Columns("ID").AutoIncrement = True
objDT.Columns("ID").AutoIncrementSeed = 1
objDT.Columns.Add("Quantity", GetType(Integer))
objDT.Columns.Add("Product", GetType(String))
objDT.Columns.Add("Cost", GetType(Decimal))
Session("Cart") = objDT
End Function

Sub Delete_Item(ByVal s As Object, ByVal e As DataGridCommandEventArgs)
objDT = Session("Cart")
objDT.Rows(e.Item.ItemIndex).Delete()
Session("Cart") = objDT
dg.DataSource = objDT
dg.DataBind()
lblTotal.Text = "$" & GetItemTotal()
End Sub
Sub AddToCart(ByVal s As Object, ByVal e As EventArgs)
objDT = Session("Cart")
Dim Product = ddlProducts.SelectedItem.Text

objDR = objDT.NewRow(GETTING ERROR IN THIS LINE)
'Error is same which is written in Subject line
objDR("Quantity") = txtQuantity.Text
objDR("Product") = ddlProducts.SelectedItem.Text
objDR("Cost") = Decimal.Parse(ddlProducts.SelectedItem.Value)
objDT.Rows.Add(objDR)
Session("Cart") = objDT
dg.DataSource = objDT
dg.DataBind()

Dim blnMatch As Boolean = False
For Each Me.objDR In objDT.Rows
If objDR("Product") = Product Then
objDR("Quantity") += txtQuantity.Text
blnMatch = True
Exit For
End If
Next
If Not blnMatch Then
objDR = objDT.NewRow
objDR("Quantity") = Int32.Parse(txtQuantity.Text)
objDR("Product") = ddlProducts.SelectedItem.Text
objDR("Cost") = Decimal.Parse(ddlProducts.SelectedItem.Value)
objDT.Rows.Add(objDR)
End If
lblTotal.Text = "$" & GetItemTotal()

End Sub

Function GetItemTotal() As Decimal
Dim intCounter As Integer
Dim decRunningTotal As Decimal
For intCounter = 0 To objDT.Rows.Count - -1
objDR = objDT.Rows(intCounter)
decRunningTotal += (objDR("Cost") * objDR("Quantity"))
Next
Return decRunningTotal
End Function
</script>

Re: Object reference not set to an instance of an object. (Use the New keyword to create object instance)

Christian Graus12-Jun-09 1:17

Christian Graus

12-Jun-09 1:17

I suspect that objDT is null. Have you stepped through the code, to see if this is so ? How about writing code that checks for nulls and doesn't blow up ?

Re: Object reference not set to an instance of an object. (Use the New keyword to create object instance)

saanj12-Jun-09 1:25

saanj

12-Jun-09 1:25

Why don't use "Session("Cart")" variable which already stored the data table. objDT is returning null. Typecast the session variable into a datatable object.

There is no foolish question, there is no final answer...

Re: Object reference not set to an instance of an object. (Use the New keyword to create object instance)

Abhijit Jana12-Jun-09 1:40

Abhijit Jana

12-Jun-09 1:40

ankurdsharma wrote:
objDT = New System.Data.DataTable("Cart")

ankurdsharma wrote:
objDT = Session("Cart")

Did you check the Session variable for null ?
Where is the Type Cast ?

ankurdsharma wrote:
objDR = objDT.NewRow(GETTING ERROR IN THIS LINE)
'Error is same which is written in Subject line

So that the reason that you are getting error here.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

How to Add the BindingManager to the tool box in asp.net if we can

govindi unal11-Jun-09 23:26

govindi unal

11-Jun-09 23:26

How to Add the BindingManager to the tool box in asp.net

modified on Friday, June 12, 2009 7:21 AM

Most Visited

Ramkumar_S11-Jun-09 23:24

Ramkumar_S

11-Jun-09 23:24

Hi Everybody

I need to fetch most visited articles from my News module...Please give me some idea

Thanks in advance

Ramkumar

Re: Most Visited

Christian Graus11-Jun-09 23:45

Christian Graus

11-Jun-09 23:45

What have you tried ? What seems the obvious way to do that ? Do you store a counter for how often a page is visited ? If not, how do you expect to do this ? If so, it suddenly becomes trivial, right ?

Re: Most Visited

saanj12-Jun-09 0:20

saanj

12-Jun-09 0:20

How are you going to track that totally depends on your strategy and business requirement? But stating from the basic, you can probably create a column called "viewcount" on any of the table where you are storing all articles. In the page load and under if(!IsPostBack) just write down the code to update the "viewcount" flag by 1. Just a basic idea which may help you.

Regards
Saanj

There is no foolish question, there is no final answer...

Re: Most Visited

Colin Angus Mackay12-Jun-09 0:39

Colin Angus Mackay

12-Jun-09 0:39

You could always use something like Google Analytics - It takes a few minutes to set up as it just requires that you add some javascript to your page.

Alternatively, you probably want to create a database table and each time you have to render a news article INSERT a row in the database to say what article was rendered and any other information you want to store with that (e.g. a date/time, the UrlReferrer, etc. etc.)

To get the most visited articles all you need to do is count each time an article appears in the database.

Man who stand on hill with mouth open wait long time for roast duck to drop in

problem in alert

janani1311-Jun-09 21:39

janani13

11-Jun-09 21:39

Hi all,

I want to redirect the page after alert box is clicked . but the page redirects before the alert was called Wat to do..

Re: problem in alert

Aman Bhullar11-Jun-09 21:40

Aman Bhullar

11-Jun-09 21:40

can you paste the code that is redirecting the page and displaying alert

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: problem in alert

Blue_Boy11-Jun-09 21:54

Blue_Boy

11-Jun-09 21:54

You should use javascript,fire function name from your control.

function ShowAlert()
{
   alert('You will redirect in another page');
   window.open(' yoururladdress/pagename.aspx');
}

 onclick="ShowAlert()"

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: problem in alert

janani1311-Jun-09 22:01

janani13

11-Jun-09 22:01

This is wat i used but the page is redirected without waiting for alert box.

Re: problem in alert

Blue_Boy11-Jun-09 22:14

Blue_Boy

11-Jun-09 22:14

Which control you are using to redirect in another page?
If you are using button then use property

OnClientClick="ShowAlert(); return false;"

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: problem in alert

janani1311-Jun-09 23:05

janani13

11-Jun-09 23:05

I have validation one the control.Now validation is not working..

Re: problem in alert

Christian Graus11-Jun-09 23:45

Christian Graus

11-Jun-09 23:45

Your core problem is that you think we're mind readers. Your code is broken. We can't fix it without seeing it.

Last Visit: 31-Dec-99 18:00 Last Update: 6-May-24 15:20

Refresh

ᐊ Prev 1...1888 1889 1890 189118921893 1894 1895 1896 1897 Next ᐅ

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