|
I have a ReorderList that uses a SqlDataSource linked to an ODBC data source. I can get the initial population of the control from the database, the save of reorder updates to the database, and the deletion of records from the table to all function properly. My issue is when I am attempting to update from the controls specified in the EditItemTemplate. The database engine throws an exception because the column I use for the sort order (disporder in my case) is being passed a null value and the column has a not null constraint on it. Below is the ReorderList and SqlDataSource from the page. My codebehind is empty. Does anyone have an idea as to how I can get the proper disporder value passed to the UPDATE statement when LinkButton3 in the EditItemTemplate is clicked?
<cc1:reorderlist id="ReorderList1" runat="server" xmlns:cc1="#unknown">
AllowReorder="True"
DataSourceID="AsaSource"
PostBackOnReorder="false"
DataKeyField="id"
ItemInsertLocation="end"
SortOrderField="disporder"
ShowInsertItem="true" OnCancelCommand="ReorderList1_CancelCommand" OnEditCommand="ReorderList1_EditCommand" OnUpdateCommand="ReorderList1_UpdateCommand">
<itemtemplate>
<asp:textbox id="TextBox1" runat="server" text="<%# Eval( "name" ) %>" readonly="true" xmlns:asp="#unknown" />
<asp:linkbutton id="LinkButton1" runat="server" text="Edit" commandname="Edit" causesvalidation="false" xmlns:asp="#unknown" />
<asp:linkbutton id="LinkButton2" runat="server" text="Delete" commandname="Delete" causesvalidation="false" xmlns:asp="#unknown" />
</itemtemplate>
<edititemtemplate>
<asp:textbox id="TextBox2" runat="server" text="<%# Bind( "Name" ) %>" xmlns:asp="#unknown" />
<asp:linkbutton id="LinkButton3" runat="server" text="Update" commandname="Update" xmlns:asp="#unknown" />
<asp:linkbutton id="LinkButton4" runat="server" text="Cancel" commandname="Cancel" causesvalidation="false" xmlns:asp="#unknown" />
</edititemtemplate>
<insertitemtemplate>
<asp:textbox id="TextBox3" runat="server" text="<%# Bind( "Name" ) %>" xmlns:asp="#unknown" />
<asp:linkbutton id="LinkButton3" runat="server" text="Add" commandname="Insert" xmlns:asp="#unknown" />
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" controltovalidate="TextBox3" errormessage="Enter a value." xmlns:asp="#unknown" />
</insertitemtemplate>
<draghandletemplate>
<asp:image id="Image1" runat="server" imageurl="~/fire.bmp" xmlns:asp="#unknown" />
</draghandletemplate>
</cc1:reorderlist>
<asp:sqldatasource id="AsaSource" runat="server" xmlns:asp="#unknown">
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
SelectCommand="SELECT [name], [disporder], [id] FROM [ajaxtest] ORDER BY [disporder]"
UpdateCommand="UPDATE ajaxtest SET name = ?, disporder = ? WHERE id = ?"
DeleteCommand="DELETE FROM ajaxtest WHERE id = ?"
InsertCommand="INSERT INTO ajaxtest (name, disporder) VALUES (?, ?)">
<updateparameters>
<asp:parameter name="name" type="String" />
<asp:parameter name="disporder" type="Int32" />
<asp:parameter name="id" type="Int32" />
</updateparameters>
<deleteparameters>
<asp:parameter name="id" type="Int32" />
</deleteparameters>
<insertparameters>
<asp:parameter name="name" type="String" />
<asp:parameter name="disporder" type="Int32" />
</insertparameters>
</asp:sqldatasource>
|
|
|
|
|
I found a solution that works for me. It would appear that each column in the SET clause of the UPDATE statement needs to be bound to a control in the EditItemTemplate. When I changed it from this:
<edititemtemplate>
<asp:textbox id="TextBox2" runat="server" text="<%# Bind( " name"="" )="" %>"="" xmlns:asp="#unknown">
<asp:linkbutton id="LinkButton3" runat="server" text="Update" commandname="Update" xmlns:asp="#unknown">
<asp:linkbutton id="LinkButton4" runat="server" text="Cancel" commandname="Cancel" causesvalidation="false" xmlns:asp="#unknown">
to this:
<edititemtemplate>
<asp:textbox id="TextBox2" runat="server" text="<%# Bind( " name"="" )="" %>"="" xmlns:asp="#unknown">
<asp:textbox id="TextBox1" runat="server" text="<%# Bind( " disporder"="" )="" %>"="" visible="false" xmlns:asp="#unknown">
<asp:linkbutton id="LinkButton3" runat="server" text="Update" commandname="Update" xmlns:asp="#unknown">
<asp:linkbutton id="LinkButton4" runat="server" text="Cancel" commandname="Cancel" causesvalidation="false" xmlns:asp="#unknown">
it worked like a champ.
|
|
|
|
|
I'm looking for a good CMS for small business that will allow me to expose contact, product, and work history details. It needn't be free, but must be quick. Is DNN up to this?
|
|
|
|
|
|
Hi guys i am posting this msg another time,
Plz help me,
I have two grid view, both are having checkbox template field...,
Now my question is when ever i click the first grid any of the row check box the second grid all the check box have to uncheck...,
Similarly whenever i click the second grid any of the row check box the first grid all the check box have to uncheck...,
I given checkbox autopostback event and on check changed event...,
<b>Now probs is when ever i click the first grid check box the second grid checkbox getting uncheck..., same time second grid check change event also firing.., so the first grid selected checkbox losing the check event...,</b>
How to solve this...,
This is my code:
protected void chk1_CheckedChanged(object sender, EventArgs e)
{
foreach (GridViewRow ug2C in ug2.Rows)
{
CheckBox cb = ((CheckBox)(ug2C.FindControl("chk2")));
cb.Checked = false;
}
}
protected void chk2_CheckedChanged(object sender, EventArgs e)
{
foreach (GridViewRow ug1C in ug1.Rows)
{
CheckBox cb = ((CheckBox)(ug1C.FindControl("chk1")));
cb.Checked = false;
}
}
and my aspx page:
<asp:gridview id="ug1" runat="server" autogeneratecolumns="False" xmlns:asp="#unknown">
OnRowDataBound="ug1_RowDataBound" >
<columns>
<asp:templatefield>
<alternatingitemtemplate>
<asp:checkbox id="chk1" runat="server" autopostback="true" oncheckchanged="chk1_CheckChanged" />
</alternatingitemtemplate>
<headertemplate>
<asp:checkbox id="chk1">
runat="server" Text="All"></asp:checkbox>
<cc1:mutuallyexclusivecheckboxextender id="ugm1" xmlns:cc1="#unknown">
runat="server"
TargetControlID="chk1"
Key="onegridhead" />
</cc1:mutuallyexclusivecheckboxextender></headertemplate>
<itemtemplate>
<asp:checkbox id="chk1" runat="server" autopostback="true" oncheckchanged="chk1_CheckChanged" />
</itemtemplate>
</asp:templatefield>
<asp:boundfield datafield="Itembrand" headertext="Brand" />
</columns>
<headerstyle cssclass="GHedr" />
</asp:gridview>
<asp:gridview id="ug2" runat="server" autogeneratecolumns="False" xmlns:asp="#unknown">
OnRowDataBound="ug2_RowDataBound">
<columns>
<asp:templatefield>
<alternatingitemtemplate>
<asp:checkbox id="chk2" runat="server" autopostback="true" oncheckchanged="chk2_CheckChanged" />
</alternatingitemtemplate>
<headertemplate>
<asp:checkbox id="chk2" runat="server" text="All"></asp:checkbox>
<cc1:mutuallyexclusivecheckboxextender id="ugm2" xmlns:cc1="#unknown">
runat="server"
TargetControlID="chk2"
Key="onegridhead" />
</cc1:mutuallyexclusivecheckboxextender></headertemplate>
<itemtemplate>
<asp:checkbox id="chk2" runat="server" autopostback="true" oncheckchanged="chk2_CheckChanged" />
</itemtemplate>
</asp:templatefield>
<asp:boundfield datafield="Itemflavour" headertext="Flavour" />
</columns>
<headerstyle cssclass="GHedr" />
</asp:gridview>
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
modified on Thursday, August 21, 2008 7:50 AM
<div class="ForumMod">modified on Thursday, August 21, 2008 7:50 AM</div>
|
|
|
|
|
Do it in javascript, why would you need to do a postback ? Just set the ids of the checkboxes so they are something like
box1chk1 box1chk2,etc
doesn't matter what it is, so long as you can get it via string mashing and use document.getElementById to iterate over them easily. Then make your check changed on the client side for one box, call the method that clears the other. On the client. In javascript.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
S graus,
The problem is they dont want the functionality change...,
Ok if using javascript also how u can achieve that?,
Becoz how u will get the id of gridview template column checkbox field and how u will uncheck the second grid checkbox?,
Give me some idea plz i need that
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
New one wrote: The problem is they dont want the functionality change...,
Who are 'they' and, what change ? you're going to make it work.
New one wrote: Ok if using javascript also how u can achieve that?,
In the manner I described. Which bit are you stuck on ?
New one wrote: Give me some idea plz i need that
OK, in the first instance, do you know anything about javascript ? Because, I gave you the script to find the checkbox, and it has a property you set to uncheck it.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
When I compile the following lines in Release mode is pass ok but not in Debug mode somebody knows why????
DWORD WINAPI AddressViolation(LPVOID ptr)
{
CmyDoc * pDoc = (CmyDoc*)ptr;
CPacket* pcGidelPacket = pDoc->GetProcCard()->m_pproc->GetPack();
//This is the problematic line....
bool is_discconeted = (static_cast<cpacket*>(pcGidelPacket))->send_ping(12);
};
Compiler error :
error LNK2001: unresolved external symbol "public: bool __thiscall CPacket::send_ping(int,unsigned long)" (?send_ping@CPacket@@QAE_NHK@Z)
thank you...
|
|
|
|
|
curiel44 wrote: When I compile the following lines in Release mode is pass ok but not in Debug mode somebody knows why????
DWORD WINAPI AddressViolation(LPVOID ptr)
{
CmyDoc * pDoc = (CmyDoc*)ptr;
CPacket* pcGidelPacket = pDoc->GetProcCard()->m_pproc->GetPack();
//This is the problematic line....
bool is_discconeted = (static_cast<cpacket*>(pcGidelPacket))->send_ping(12);
};
Compiler error :
error LNK2001: unresolved external symbol "public: bool __thiscall CPacket::send_ping(int,unsigned long)" (?send_ping@CPacket@@QAE_NHK@Z)
thank you...
Wow - you win my award for the most hopelessly lost post, ever. Not only is this not ASP.NET code, it's not .NET code at all. Did you spam the entire site, or did you really think this was the place for a C++ question ?
Try the Visual c++ forum.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
when I'm using the auto post back true of a check box i'm getting this error. can any body tell me how to solve this
|
|
|
|
|
It will be better if you explain it in detail and provide the code
Cheers!!
Brij
|
|
|
|
|
I have some menu control in my master1.master page.
And i am filling the content of menu and sub menu from xml file.
In menu and sub menu i have written the url of the page.
In url there is aspx page.
If I put aspx page then there is no problem .
BUT I WANT TO LINK HTML PAGEIN THAT URL.
And its working but after clicking menu or submenu it diplays the only html page...it does not showing any master page control.
MY AIM IS TO DISPLAY THE HTML PAGE IN THE CONTENT PLACE HOLDER OF MASTER PAGE
OR ANY ALTERNATIVE SUGESSION
|
|
|
|
|
The problem is obviously with the links you are rendering in your menu.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Convert those html pages into .aspx pages and reference the proper master page.
|
|
|
|
|
HI friends,
I am using report viewer in my Asp.Net application. In the report viewer loaded,
i got export,refresh,paging,search options .But print option is not showed in the
report. I set "showPrintButton="True"".And Install ActiveX control also.But again
i couldn't get the print icon. I am asking so many forums. But no one give useful
reply. So please give me the solutions. Very urgent.
Reply me as soon as possible.
Hope ur's reply
Thanks
Failing to plan is Planning to fail 
Every Successful Person Have A Painful Story
|
|
|
|
|
CrystalReportViewer1.HasPrintButton = true;
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Hi
Thanks for ur's reply. But i am using sql report viewer.
Not crystal report viewer buddy.
Please give a useful suggestion.
Friendly
Guvera 
Every Successful Person Have A Painful Story
|
|
|
|
|
Hi, I have a DropDownList in an EditItemTemplate within the GridView.
Problem is I can't find the control.
In the OnDataBound there is no e.Row.RowType == DataControlRowType.EditIem like in a DataGrid.
And when I try to bind the DataSet in the RowEditing Event the same thing happens.
EG RowEditing
protected void gvRegisters_RowEditing(object sender, GridViewEditEventArgs e)
{
this.gvRegisters.EditIndex = e.NewEditIndex;
this.SetErrorMessage("Record opened for editing", ErrorClass.Info);
DropDownList ddlCompany = ((DropDownList)gvRegisters.Rows[e.NewEditIndex].FindControl("ddlCompany"));
DropDownList ddlBranch = ((DropDownList)gvRegisters.Rows[e.NewEditIndex].FindControl("ddlBranch"));
DropDownList ddlDepartment = ((DropDownList)gvRegisters.Rows[e.NewEditIndex].FindControl("ddlDepartment"));
FillLocationDropDowns(ddlCompany, ddlBranch, ddlDepartment);
}
Got any Ideas???
modified on Thursday, September 4, 2008 2:18 AM
|
|
|
|
|
HI
Mention the cell name or index like this
DropDownList ddlList=(DropDownList)(GridView1.Rows[e.NewEditIndex].Cells[0].FindControl(""));
R.Palanivel 10:01 4 Jan '06
|
|
|
|
|
Affraid not. I even tryed looping through each Cell, it always returns null.
|
|
|
|
|
try to set runat="server" property else
send me you gridview's HTML code.
R.Palanivel 10:01 4 Jan '06
|
|
|
|
|
<pre>
<edititemtemplate>
<table style="width: 100%">
<tr>
<td>
<asp:dropdownlist id="ddlProfileEdit" runat="server" xmlns:asp="#unknown">
</asp:dropdownlist>
</td>
<td>
<asp:dropdownlist id="ddlCompany" runat="server" xmlns:asp="#unknown">
</asp:dropdownlist>
</td>
<td>
<asp:dropdownlist id="ddlBranch" runat="server" xmlns:asp="#unknown">
</asp:dropdownlist>
</td>
<td>
<asp:dropdownlist id="ddlDepartment" runat="server" xmlns:asp="#unknown">
</asp:dropdownlist>
</td>
</tr>
</table>
</edititemtemplate></pre>
|
|
|
|
|
Hi
the problem is your drop downl list not loaded please check viewsouce.
your c# code write. you have modify your Gridview HTML code.
Thanks & Regards
R.Palanivel 10:01 4 Jan '06
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
