Re: ViewState Probelm in GridView - ASP.NET Discussion Boards

comp_j30-Jul-09 10:15

30-Jul-09 10:15

Hello

Im must read records from Gridview and then insert them to database.
Here is the code that I wrote.

 <br />
for (int i = 0; i<counter; i++)  <br />
        {<br />
            string ID = GridView.Rows[i].Cells[0].Text;<br />
           objDataAdapter.SelectCommand.CommandText = "INSERT INTO MYTable " +<br />
            "(Name) VALUES(@Name)";<br />
            objDataAdapter.SelectCommand.Parameters.AddWithValue("@Name",Name);<br />
}<br />

There is an exception:

The variable name '@Name' has already been declared. Variable names must be unique within a query batch or stored procedure.

Please help me how can I handle this exception.

Re: Placeholder

Christian Graus30-Jul-09 10:49

Christian Graus

30-Jul-09 10:49

Does this happen the first time through, or the second ?

Why would you make the 'select command' do an insert ? Why not just run the SQL directly without using a data adapter ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Placeholder

comp_j30-Jul-09 11:16

comp_j

30-Jul-09 11:16

The problem solved with this: Wink | ;)

objDataAdapter1.SelectCommand.Parameters.Clear();

Re: Placeholder

Christian Graus30-Jul-09 11:35

Christian Graus

30-Jul-09 11:35

OK, that's what I suspected, because it's a member object, you're setting the parameter over and over, that's why I asked if it happens the first time.

I think those data adapter things are retarded, I never use them.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Placeholder

comp_j30-Jul-09 12:17

comp_j

30-Jul-09 12:17

Christian Graus wrote:
I think those data adapter things are retarded, I never use them.

What do you use instead of adapter?

Re: Placeholder

Christian Graus30-Jul-09 12:28

Christian Graus

30-Jul-09 12:28

I write a proper data layer, in a seperate dll, I NEVER put SQL in the presentation layer, and I'd fire anyone who worked for me who did.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

ViewState Probelm in GridView

Hemant_ec4830-Jul-09 9:37

Hemant_ec48

30-Jul-09 9:37

Hi ...

I have bind one gridview with 2 different Method.

Total 250 records are there.

In first Method I fetch all 250 record in dataset and bind in Gridview with EnablePaging = True. Mean while i am saving this dataset in view state.Here grid view show only 10 records per page.

So now when i see page source it display size of view state around 28 kb.

In second method I fetch page wise record from DB. Means for 1st page i am fetching 10 record. and storing this dataset(with only 10 records) in view state for sorting.

Now when i see page source it display the same size in view state.

Is there any other technic to reduce view state??

and why happen like this in first method it fetch 250 records and i am storing it in view state while in second method i fetch only 10 records and storing in view state still view state size remain same.

Re: ViewState Probelm in GridView

Christian Graus30-Jul-09 10:50

Christian Graus

30-Jul-09 10:50

Hard to say without seeing the code. What happens if you disable viewstate in the gridview, how much does it drop by then ? That will tell you how much of the viewstate is your data in the gridview

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: ViewState Probelm in GridView

Hemant_ec4830-Jul-09 11:32

Hemant_ec48

30-Jul-09 11:32

Hi christian,

i have already disable view state for some of the column in grid view.

After binding gridview i am reading one by one row and each and every row i am go thorugh cells one by one and disable this cells enableviewState property to false.

in this way if i am doing than it is reduce viewstate from 32kb to 27 kb.

but problem is that first method fetch 250 records and i am storing this records in viewstate for later paging & sorting

& in second method i am fetch first 10 records and storing this record in view state for later sorting only. when i click second number in paging than i am fetching record from 11 to 20 and storing this one to view state.

just my problem is to when i see view source of aspx page at that time in both the case it showing me viewstate size as 27 kb only.why it is not reduced...???? In first case i have store 250 rows while in second one i have stored 10 rows in view state..

Regards,
Hemant Patel.

Re: ViewState Probelm in GridView

Christian Graus30-Jul-09 11:36

Christian Graus

30-Jul-09 11:36

Asking me the same question again is not helpful. Did you disable viewstate for the entire grid ? If you did, then any viewstate you're seeing, is from other things on your page.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Dynamic link button controls

Ersan Ercek30-Jul-09 8:03

Ersan Ercek

30-Jul-09 8:03

Hello I am trying to create linkbutton controls that are supposed to fire method. I add them to pageload however I am told that I should add them before it. I google the lifecycle and I found 2 events Init and PreLoad, I tried them and they are really fired before page_load however this time the controls even do not appear. here is the code:

protected void Page_Preload()
{
for (int i = 1; i <= 2; i++)
{
LinkButton bottomLink = new LinkButton();
LiteralControl bottomLiteral = new LiteralControl(" ");
bottomLink.Text = i.ToString();
pnlBottom.Controls.Add(bottomLink);
pnlBottom.Controls.Add(bottomLiteral);
bottomLink.OnClientClick += new EventHandler(this.changeLink);

}
}

it is drawing me crazy please help.

Re: Dynamic link button controls

Abhijit Jana30-Jul-09 8:12

Abhijit Jana

30-Jul-09 8:12

Ersan Ercek wrote:
protected void Page_Preload()

Where is parameter Object and EventArgs ?

Try this. Its work for me Big Grin | :-D

protected void Page_Preload(object sender, EventArgs e)
    {
        for (int i = 1; i <= 2; i++)
        {
            LinkButton bottomLink = new LinkButton();
            LiteralControl bottomLiteral = new LiteralControl(" ");
            bottomLink.Text = i.ToString();
            pnlBottom.Controls.Add(bottomLink);
            pnlBottom.Controls.Add(bottomLiteral);
            bottomLink.Click += new EventHandler(bottomLink_Click);
         }
    }

I will suggest you to create all the control on Pre_Init()

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Dynamic link button controls

Ersan Ercek30-Jul-09 8:20

Ersan Ercek

30-Jul-09 8:20

Thanks for the reply but it is not working. Smile | :)

. That why I am getting crazy. Smile | :)

Do you think pnlBottom (panel) would be created before_preinit, since I added it on HTML page...

Thanks again.

Re: Dynamic link button controls

Abhijit Jana30-Jul-09 8:26

Abhijit Jana

30-Jul-09 8:26

Ersan Ercek wrote:
Do you think pnlBottom (panel) would be created before_preinit, since I added it on HTML page

you means, like this way ?

<asp:Panel ID="pnlBottom" runat="server">
 </asp:Panel>

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Dynamic link button controls

Ersan Ercek30-Jul-09 8:27

Ersan Ercek

30-Jul-09 8:27

Excatly... do you think this is the problem?

Re: Dynamic link button controls

Abhijit Jana30-Jul-09 9:01

Abhijit Jana

30-Jul-09 9:01

I did the same and I got two link in my page "1" and "2" .

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Dynamic link button controls

Ersan Ercek30-Jul-09 9:17

Ersan Ercek

30-Jul-09 9:17

does the link or the code you attached work?

Re: Dynamic link button controls

Ersan Ercek30-Jul-09 9:28

Ersan Ercek

30-Jul-09 9:28

okay I solve the problem for now Smile | :)

onclientclik ? what was that? Smile | :)

I changed it with click Smile | :)

Re: Dynamic link button controls

Abhijit Jana30-Jul-09 9:31

Abhijit Jana

30-Jul-09 9:31

Ersan Ercek wrote:
onclientclik ? what was that? Smile I changed it with click Smile

So, You didn't checked my code that I have replied on First time. D'Oh! | :doh:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: Dynamic link button controls

Ersan Ercek30-Jul-09 9:32

Ersan Ercek

30-Jul-09 9:32

no i did not...

SelectedIndexChanged Event for Dropdownlist AJAX

Ridge Howison30-Jul-09 7:06

Ridge Howison

30-Jul-09 7:06

Hello,

Thank you for reading. Here is my situation. I have an UpdatePanel and within in I have 2 dropdownlists.   I want to show the second ddlist only when a specific value is chosen in dropdownlist1. I used Javascript/label etc on the selectedIndexChanged event but still does not work. The event gets fired and I stepped thru the code with no problems but it does not render on screen. Code snippet below. All help is wonderfully,gratefully and thankfully appreciated.

Front End

<asp:UpdatePanel ID="updPanel1" runat="server">
            <ContentTemplate>
         <asp:DropDownList ID="ddlTest1" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlTest1_IndexChanged">
            <asp:ListItem Value="" Text="Select one"></asp:ListItem>
            <asp:ListItem Value="Matt" Text="Matt"></asp:ListItem>
            <asp:ListItem Value="Robin" Text="Robin"></asp:ListItem>
            </asp:DropDownList>
            <asp:DropDownList ID="ddlTest2" runat="server" style="visibility:hidden;display:none;">
            <asp:ListItem Text="Select One" Value=""></asp:ListItem>
            <asp:ListItem Text="Tom" Value="Tom"></asp:ListItem>
            <asp:ListItem Text="John" Value="John"></asp:ListItem>

      </asp:DropDownList>
</ContentTemplate>
            </asp:UpdatePanel>

And the Codebehind is as follows:

Protected Sub ddlTest1_IndexChanged(ByVal sender As Object, ByVal e As EventArgs)
            If ddlTest1.SelectedValue = "Robin" Then

                  Dim script As String = "<script type='text/javascript'>var elem=document.getElementById('" & Me.ddlTest2.ClientID & "');elem.style.visibility='visible';elem.style.display='block';</script>

Page.ClientScript.RegisterClientScriptBlock(Me.GetType(), "newKeyVal", script, True)

            Else
                  Dim script As String = "<script type='text/javascript'>var elem=document.getElementById('" & Me.ddlTest2.ClientID & "');elem.style.visibility='hidden';elem.style.display='block';</script>"
                  Page.ClientScript.RegisterClientScriptBlock(Me.GetType (), "newKeyVal", script, True)

            End If

      End Sub

Re: SelectedIndexChanged Event for Dropdownlist AJAX

Abhijit Jana30-Jul-09 8:14

Abhijit Jana

30-Jul-09 8:14

Do not put the both Dropdown list in Same Update Panel. Place it in two different Update Panel and Make the UpdateMode="Conditional" for the Second Updatepanel and call UpdatePanel2.Update() from SelectedIndexChanged event of Dropdownlist1.

Hope this will help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: SelectedIndexChanged Event for Dropdownlist AJAX

Abhishek Sur30-Jul-09 8:59

Abhishek Sur

30-Jul-09 8:59

Hey... Why do you require to pass a script to the client and process to change the visibility of the control, when you simply can change Me.ddlTest2.Visible = false

By this way you are eventually making your response smaller, as if a servercontrol visible is false, it will not rendered to the client. Rose | [Rose]

Or if you need Javascript fix, just use simple AJAX call (May be using ICallBackEventHandler) from the Javascript, and get the status of the Clientside control, and do display=none from javascript.

Dont need UpdatePanel for such a small need.. . Rose | [Rose]

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

System.Runtime.InteropServices.COMException: Cannot activate application

vikash_singh30-Jul-09 4:56

vikash_singh

30-Jul-09 4:56

hi guys please help me !
iam using "Microsoft.Office.Interop.Word.ApplicationClass" for exporting data from DB to word document. it works fine on server where i published the application. but from my machine is shows the following error:-"System.Runtime.InteropServices.COMException: Cannot activate application"

code is.......

public static bool Export( string questionID, int questionNumber, object filename )
try
{
bool result=false;
object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Word.ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
Microsoft.Office.Interop.Word.Document wordDoc = wordApp.Documents.Add( ref missing, ref missing, ref missing, ref missing );

...................

wordApp.Selection.TypeParagraph();
wordDoc.SaveAs( ref filename, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing );
wordDoc.Close( ref missing, ref missing, ref missing );
wordApp.Application.Quit( ref missing, ref missing, ref missing );
return result;
}
--------------------
1. already i configured security setting for word in DCOMcnfg(added network service, aspnet and set access permission to full control and rebooted the system) though iam getting the same error.

2. i changed application platform to x86 still problem continues.....

waiting for help !

thanx

Re: System.Runtime.InteropServices.COMException: Cannot activate application

Abhishek Sur30-Jul-09 5:00

Abhishek Sur

30-Jul-09 5:00

Code looks good.

Do you have the same version of office installed?

Is it Office 2007 installed in your machine?

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

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