problem in commit & roll back [modified] - ASP.NET Discussion Boards

No sir, if you can provide me some help or if possible some code snippet too. Please. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

A larger subject, please do a little research first.

only two letters away from being an asset

Ok. Thanks any way.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

The solution may not be the best but it would work....

You have to try out using frames concept....

Lets say there is a homepage.aspx
Place your adrotator control in sepearte aspx page i.e.rotator.aspx

Now add a new aspx page like final.aspx and include the two pages as frames.
For that goto the html view of the page and add frameset and align the frame accordingly..

For guidance looking into frameset in www.w3schools.com -> learn html!!!

Gautham

No, I cant use the frames concept. I already know this. Can I use any other method, within the same page. If you can please give me. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

hi

Can any one please let me know how to sign the cookies secure in ASp.NET 1.1, please reply ASAP, thankx in advance,

Hi,
I am facing this unique problem which can be explained only with the code below
<code>
protected void grdQueryList_RowCommand(object sender, GridViewCommandEventArgs e)
{
string Sugg_Id;

if (e.CommandName == "View")
{
Sugg_Id = dv.Table.Rows[Convert.ToInt32(e.CommandArgument)][1].ToString();
Response.Redirect("Feedback_Data.aspx?Sugg_Id=" + Sugg_Id);
}
}

protected void grdQueryList_RowDataBound(object sender, GridViewRowEventArgs e)
{
//if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header)
// {
// e.Row.Cells[1].Visible = false; // Hiding the SUGG ID COLUMN
// }

if (e.Row.RowType == DataControlRowType.DataRow)
{
RowIndex += 1;
e.Row.Cells[0].Text = Convert.ToString(RowIndex);
}

if (e.Row.RowType == DataControlRowType.Header)
{

TableCellCollection cells = e.Row.Cells;

foreach (TableCell cell in cells)
{
if (!(cell.Text.Contains("VIEW") || cell.Text.Contains("SR NO")))
{
cell.Text = Server.HtmlDecode(GenerateScript(cell.Text, grdQueryList));
}
}
}
}

protected void grdQueryList_Sorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;

if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
RowIndex = 0;
SortGridView(sortExpression, " DESC");
}
else
{
GridViewSortDirection = SortDirection.Ascending;
RowIndex = 0;
SortGridView(sortExpression, " ASC");
}
}

private void SortGridView(string sortExpression, string direction)
{
DataSet objQueriesData;

objQueriesData = BusinessClass.GetQueriesList();
dv = new DataView(objQueriesData.Tables[0]);

if (sortExpression != "" && direction != "")
{
dv.Sort = sortExpression + direction;
}

grdQueryList.DataSource = dv;
grdQueryList.DataBind( );
}

private string GenerateScript(string columnName, GridView gv)
{
string optionalParam = "Sort$" + columnName;

StringBuilder sb = new StringBuilder( );
sb.Append("<a style='color:Black' href=\"");
sb.Append("javascript:");
sb.Append(ClientScript.GetPostBackEventReference
(gv, optionalParam, false));
sb.Append("\">");
sb.Append(columnName);
sb.Append("</a>");

return sb.ToString( );

}

public SortDirection GridViewSortDirection
{

get
{

if (ViewState["sortDirection"] == null)

ViewState["sortDirection"] = SortDirection.Ascending;

return (SortDirection)ViewState["sortDirection"];

}

set
{
ViewState["sortDirection"] = value;
}

}
</code>

Now the problem is that, whenever user sorts data in the grid using Hyperlink Header, the data gets sorted properly, but when a RowCommand is fired, then the e.commandArgument shows 0th row being picked, but the value picked from one of the cells is from some other row instead of Row 0.
How to track or solve this ?
Pls guide
Thanks and best regards
Omkar Ghaisas

Hi anybody pls help me its very urgent

I am facing a problem while doing commit & roll back in one of my pages. My problem is i have
to upload data from one database(accounts) to another say Gaccounts programmatically.
In my web.config i wrote 2 connections by name con(for database accounts), con1(for
Database-Gaccounts).
Then in my program i am using commit & roll back.

I have to check the code from ledger table (say 0003) with code in accounts table if it exist then i have to check whether that code exits in accounts table of gaccounts database. If it is not there I have to add more value in the code like (0003tvm) and then create a row in accounts table of gaccounts database with this new code. This much am not feeling any problem.

Now I have to update this new code back in accounts table of accounts database. .here the problem comes if roll back happens then also updating of this code take place
Creating complete error .I am giving database details in a class file. In this project I used 2 class files say objdb-representing accounts and objmdb-for gaccounts.

‘This is the code I am using for roll backing

Dim objCon1 As New oleDbConnection(ConfigurationSettings.AppSettings.Get("con1"))
Dim objCmd As New OleDbCommand
Dim objTran As OleDbTransaction
objCon1.Open()
objTran = objCon1.BeginTransaction
objCmd.Connection = objCon1
objCmd.Transaction = objTran

Try
****** I have given the code for updating as *******

'sSQL = " Update accounts set txtmastcode='" & snewcode& "'WHERE txtcode='" & objdr("txtcode") & "'"
ireturn=objdb.executenonquerry(ssql,objdb.opendb)

objTran.Commit()

Catch ex As Exception
objTran.Rollback()
MessageBox.Show("Transaction failed. Contact Administartor")
MessageBox.Show(ex.Message().ToString())
Finally
objCon1.Close()
objCmd.Dispose()
End Try

Please anybody help me , this is very urgent.

-- modified at 13:25 Wednesday 24th January, 2007

Hi,

I have configured my project in the server.
I am using menus in my project.
I get a java script error as "menu is undefined" in the server.
But locally the same setup is running fine.It doesnt give any error message.

So i found that there is an error in the path where menu is defined.
I hardcoded the path as .It runs fine.But this should be set globally.

If i give globally as <script language="JavaScript" src="../scripts/menu.js">
it doesnt work.

Is there any ways how to specify the path to run the application in the server.If anyone knows reply me as soon as possibe.

Thanks,
Anandhakumar

-- modified at 6:09 Tuesday 23rd January, 2007

Try:

More Info:
<a href="http://msdn2.microsoft.com/en-us/library/ms178116.aspx">http://msdn2.microsoft.com/en-us/library/ms178116.aspx</a>[<a href="http://msdn2.microsoft.com/en-us/library/ms178116.aspx" target="_blank" title="New Window">^</a>]

<div class="ForumSig">Declan Bright
www.declanbright.com</div>

Thanks. I tried with the solution u gave, but doesnt seem to work.
Can u give me some other solution.

Thanks,
Anandhakumar

Hi,
I am using

tag in one of my pages to display text entered into a text box. The problem is I don't want horizontal scroll bar. How do I achieve this?

If I am using
style="OVERFLOW: auto;height=150;width=125"
I am getting both the scroll bars. But I want the behaviour similar to wrap text property.

Regards,
Uma

style attribute overflow: hidden

Keep Smiling !!!
Parwej Ahamad
g_parwez@rediffmail.com

There are two attributes - overflow-x and overflow-y, which control the scrollbars independently, so to hide one and show the other, use something like...

<div style="overflow-x:scroll; overflow-y:hidden"></div>

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

hi
I am showing my data on webpage thro gridview. I want to add context menu
in it. I dont know how to do it. I m doing my project in vs2005 using C# lang.

plz help guys.

Hi bipin,
Following Microsoft Cutting edge article shows good example with source code on context menu but only limitation is, this context menu is running in IE not in firefox.

http://msdn.microsoft.com/msdnmag/issues/05/02/CuttingEdge/

Regards,
Swap.

swap
i know that link...
but they used readymade option overthere called contextmenu..
how can i get that menu?

i hve not seen that in my gridview property..
i think that contextmenu is custom control.

Bipin,
You are right, it is custom control. But to put it in to gridview you can add it in to cell during databind method. But it will not feasible to put it in all cell, so if you have functionality to put it in one column or particular cell than it will work.

and if you want to add to whole grid than you need to develop custom control and for that javascript context menu will help you, this menu attaches with any html element in case of gridview(table), and popup on right click of that particular html element.
http://www.dynamicdrive.com/dynamicindex1/jsdomenu/index.htm

Regards,
Swap.

thanks man..
ur absolutly right..
i m thinking abt javascript...
i think it is little bit lenthy process..
i wil see the link .

thanks

Hi Bipin,

I just surf around and got this link on codeproject itself may be it helps you.

http://www.codeproject.com/aspnet/dynamenu.asp

Regards,
Swap.

hai
i want to refresh the page of asp.net without blinking.my code is

.
if i given this code means page are refresh with blinking.so i want code for refresh without blinking.plz help.
regards,
sathyanarayanan

You can use AJAX to get updates from the server and then update the page without reloading it.

---
Year happy = new Year(2007);

hi i have written code in xml to load ads to the adrotator control , the images are not changed so i added
the below code to refresh the page

then the page will refresh for every 5 seconds , but page was blinked (i mean visible,invisible )

what is the solution?

HI
try This

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Hi,
I have this program that I'm trying to compile and it flags this error:
The type or namespace name 'src' could not be found(are you missing a using directive or an assembly reference?) I've tryed to look for a .dll called src I can't find it. It's only a folder called src that I find. Am I missing something?
thank you