GridView Delete() with ObjectDataSource - ASP.NET Discussion Boards

Hey,
Did u check this http://www.codeproject.com/useritems/JumpyForum.asp[^]

Mehedi Hasan

http://www.communityserver.org/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

I am getting this error when i load my page. Seems there is an configuration error of some sort in web.config....can anyone please suggest a solution??

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The container specified in the connection string does not exist.

Source Error:

Line 24:

Hello All,
I am working in Visual Studio 2003. I want to access local cube (.cub) file with ADODB object. How is this possible?
I am using the following code, but it doesnt seems to work

<br />
 Dim cnActive As New ADODB.Connection<br />
 Dim rs As ADODB.Recordset<br />
 cnActive = New ADODB.Connection<br />
 Try<br />
   cnActive.Open("provider=msolap;Data Source=c:\temp\mycube.cub;", "", ",0)<br />
   rs = cnActive.OpenSchema(ADODB.SchemaEnum.adSchemaCatalogs)<br />
   Catch ex As Exception<br />
   sError = ex.Message<br />
   Exit Sub<br />
 End Try<br />

The error is "The operation has failed because of an error in the COM component - unknown error c:\temp\mycube.cub Access Denied. ". I have given full access to this folder but no use. Any ideas?

thanx
Mubashir

Every job is a self portrait of the person who did it.

See this example:

http://sqljunkies.com/WebLog/mosha/archive/2006/03/08/local_cube_password.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

hi

,
If any website developed in asp.net 2.0 whenever we need to make change in code behind (even a bit of change in code ) then again we have need to upload the whole website.
Is there any way to upload only the bin folder (dll) only.
if any please help .

Many many thank in advance..

Regards
Srinandan

Xcopy?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

I am using ObjectDataSource to display records on a Gridview. In my BLL I have three functions GetAll() [returns MyEntity], Save(MyEntity entity) and Delete(MyEntity entity) which make use of a business entity called MyEntity.

The GetAll() and Save(MyEntity entity) works perfectly fine but the Delete(MyEntity entity) does not work at all. This is what my BLL Delete(MyEntity entity) looks like:

[System.ComponentModel.DataObjectMethod(DataObjectMethodType.Delete,true)]
public Boolean Delete(UserEntity tblUserXref)
{
UserXrefDAL dal = new UserXrefDAL();
return dal.Delete(tblUserXref);
}
And my DAL Delete(MyEntity entity) looks like this:

public Boolean Delete(GlobalClassLibrary.Site.Entities.UserXrefEntity entity)
{
try
{
SqlDatabase dbHelper = new SqlDatabase(ConnectionString.GetConnectionString());
SqlCommand dbCommand = (SqlCommand)dbHelper.GetStoredProcCommand("tblUserXrefD");
dbHelper.AddInParameter(dbCommand, "@XrefId", SqlDbType.Int, entity.XrefId);
dbHelper.ExecuteNonQuery(dbCommand);
return true;
}
catch (Exception)
{
throw;
}
}

Now, when I put a break point I found out that Delete button on GridView does call the BLL's Delete(MyEntity entity) method, but, all the values of my entity are null.

<asp:GridView ID="GridView1"
runat="server"
AllowPaging="True"
DataSourceID="odsUserXrefBLL"
AutoGenerateColumns="False">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"></asp:CommandField>
<asp:BoundField DataField="RemoteId" SortExpression="RemoteId" HeaderText="Id"></asp:BoundField>
<asp:BoundField DataField="XrefId" SortExpression="XrefId" HeaderText="XrefId">
</asp:BoundField><asp:BoundField DataField="UserId" SortExpression="UserId" HeaderText="UserId"></asp:BoundField>
<asp:BoundField DataField="siteUserId" SortExpression="siteUserId" HeaderText="siteUserId"></asp:BoundField>
<asp:BoundField DataField="CreationDate" SortExpression="CreationDate" HeaderText="CreationDate"></asp:BoundField>
</Columns>
</asp:GridView>
<asp:ObjectDataSource
ID="odsUserYardXrefBLL"
runat="server"
UpdateMethod="Save"
DataObjectTypeName="GlobalClassLibrary.Site.Entities.UserXrefEntity"
OldValuesParameterFormatString="original_{0}"
SelectMethod="GetAll"
DeleteMethod="Delete"
TypeName="GlobalClassLibrary.Site.BLL.UserXrefBLL">
</asp:ObjectDataSource>

Please help. Thanks.
.

Well you have written a bit complex code but thats your own way.
Are you setting DataKeyNames property of DataGrid? that should be the name of your primarky ke of the table.

Also you need to handle DataRowDeleting event of the Datagrid while you are deleting.

It may help I think if not then excuse me Smile | :)

Naveed Kamboh

Thanks a lot for your help, DataKeyNames did the trick Smile | :)

.

Also on a seperate note: what would you suggesst i should do diffrently to make the code less complex?

Reallly i dont knonw what to tell you.
May be you are writing v.good.
but i use this simple code which is simple to me Smile | :)

.

///

///Delete the record for specified ID
///

/// <param name="catid" />
public void DeleteRecord(Int64 Newsid) {
connection= dbConnect();
string sqlDelete = "Delete from tblTestimonials where Newsid=?Newsid";
MySqlCommand myCommand = new MySqlCommand(sqlDelete, connection);

myCommand.Parameters.Add("?Newsid", Newsid);
int rowsAffected = 0;
try
{
rowsAffected = myCommand.ExecuteNonQuery();
}
finally
{
connection.Close();
connection.Dispose();
}
}

Naveed Kamboh

I'm having issues sorting a GridView whose datasource is dynammically determined by which report is selected from a drop down. I know sorting is an easy thing if I used a SQLDataSource or an ObjectDataSource and maybe created a table adapter for each report I'm pulling but the idea was to only have to make changes in sql server when new reports are added rather than having to modify any code. Any ideas on how I can sort this dynamically filled GridView? I'm running into an StackOverflowException was unhandled error probably becuase GridView1 doesn't have bound columns or something like that I imagine. When stepping through the code I see e.SortExpression does have the column name in there but it's not working. The RunRptButton_Click event is what the user clicks after selecting the report from a drop down and filling out two text fields for start date and end date (used free daintydate datepicker). And please, if there is a better approach, any help would be great. Here's my code...

<asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle" AutoGenerateColumns="True" AllowSorting="true" OnSorting="Sort_GridView">
</asp:GridView>

protected void RunRptButton_Click(object sender, EventArgs e)
{
try
{
DateTime StartDate = System.Convert.ToDateTime(DaintyDate1.Text);
DateTime EndDate = System.Convert.ToDateTime(DaintyDate2.Text);
SqlCommand cmd = new SqlCommand(RptsDropDownList.SelectedItem.Value, new SqlConnection(
WebConfigurationManager.ConnectionStrings["SID_RequestConnectionString"].ConnectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("StartDate", StartDate);
cmd.Parameters.AddWithValue("EndDate", EndDate);
//cmd.Parameters.AddWithValue("StartDate", "2006/01/01");
//cmd.Parameters.AddWithValue("EndDate", "2007/01/01");

cmd.Connection.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();

cmd.Connection.Close();
cmd.Connection.Dispose();
}
catch (Exception ex)
{
lblErr.Text = "Error: " + ex.Message;
}

}

protected void Sort_GridView(object sender, GridViewSortEventArgs e)
{
try
{
GridView1.Sort(e.SortExpression, SortDirection.Ascending);
}
catch (Exception ex)
{
lblErr.Text = "Error Sorting: " + ex.Message;
}

}

Darren

-- modified at 12:58 Wednesday 28th February, 2007

I figured out a way to do this with minimal changes by adding a table adapter for each report but if anyone knows a way for me to avoid this, please let me know. No code was necessary for sorting. For those who may want to see this...

I added a table adapter for each report (about 10). In the code below, I have SelectMethod and TypeName hardcoded but that will actually be populated from a table in sql server based on the report they choose from a drop down.

create an ObjectDataSource with just the bare bones

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}">
</asp:ObjectDataSource>

GridView with also minimal config

<asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle" AutoGenerateColumns="True" AllowSorting="true">
<HeaderStyle CssClass="HeaderStyle" />
<AlternatingRowStyle CssClass="AlternatingRowStyle" />
</asp:GridView>

button to run report

<asp:Button ID="RunRptButton" runat="server" Text="View Report" OnClick="RunRptButton_Click" />

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{

}
else
{
// must have this for sorting!
ObjectDataSource1.SelectMethod = "GetRptSIDRevisionCount";
ObjectDataSource1.TypeName = "ReportsBLL";
}

}

protected void RunRptButton_Click(object sender, EventArgs e)
{
try
{
DateTime StartDate = System.Convert.ToDateTime(DaintyDate1.Text);
DateTime EndDate = System.Convert.ToDateTime(DaintyDate2.Text);

ObjectDataSource1.SelectMethod = "GetRptSIDRevisionCount";
ObjectDataSource1.TypeName = "ReportsBLL";
ObjectDataSource1.SelectParameters.Add("StartDate",Convert.ToString(StartDate));
ObjectDataSource1.SelectParameters.Add("EndDate", Convert.ToString(EndDate));
GridView1.DataSourceID = ObjectDataSource1.ID;
GridView1.DataBind();

}
catch (Exception ex)
{
lblErr.Text = "Error: " + ex.Message;
}

}

Now when I add a new report I'll have to add the report info to the table in sql server and unfortunately still have to go in and create a table adapter for the new report. I'd love to not have to do this if anyone knows a better way. Thanks!

Anyone every hear of any software that tracks users click and records them to a DB or something. We have a decent error trapping process in place but it very hard to try to recreate the error that the user caused. Any thoughts?

Why cant you trace the information from exceptions with the user clicks...When an error generates it need to log the message exception also to your DB...

Thanx,
RPM.

Why humans having 99.9% of unused brain!!!

Hi all,

I have a web page that contains a link that is connected to an attachement.Clicking on that link brings up a small window that allows me to save/open the attachment.It works fine without SSL. but once I use https:// and click on the same link I get the following error:

Internet explorer cannot download file from server.
IE was not able to open the site.The requested site is either unavailable or cannot be found.

Any ideas why this is happening?

Any help would be appreciated.It is on the .NET 2.0 framework.

Thanks.

CafeDreamz.
D'Oh! | :doh:

hi all,

I am trying to access a web application built on the .NET 2.0 framework and I keep getting this error pop-up which asks me to select a debugger....

The error is:
system.security.cryptography.cryptographicexception caused by w3wp.exe(which is the w2k3 worker process).

any ideas why this is happening?

any help would be appreciated.

Thanks.

Cafedreamz.

assalam-o-alaikum!
dears i want to provide the download option at my site please tell about the code....have you any idea about download...?

Feroze

Just make files a link.
it will does automatically.

Naveed Kamboh

Assalam-o-Alaikum dear Naveed thanks for reply me yaar. please give me some idea about link or some code to do this....thanxxxxx....

Feroze

Feroze its v.easy and simple

for example "Download my CV"

Naveed Kamboh

You can stream the file right?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Hi,
I want to share this problem. I have a datagrid that will help me Insert data into sql database. So I made a button On my form so that when I press the button a new row on datagrid should be created and I could be able to insert data. But with this code below I've failed could someone help me and tell me where I'm going wrong:

private void Page_Load(object sender, System.EventArgs e)
{
if (! IsPostBack)
{

Fill();
Bind();
}
}
DataTable table = new DataTable();
private void Fill()
{
SqlDataAdapter adapter = new SqlDataAdapter("select * from dbo.DashBoard", con);
adapter.Fill(table);
}
private void Bind()
{
dgis.DataSource = table;
dgis.DataBind();
}

private void InsertEmpty()
{
table.Rows.InsertAt(table.NewRow(), 0);
}

private void bttnew_Click(object sender, System.EventArgs e)
{
// inserting
dgis.EditItemIndex = 0;

// modify text
EditCommandColumn ecc = (EditCommandColumn) dgis.Columns[6];
ecc.UpdateText = "Update";

// fill table, insert empty row, bind to datagrid
Fill();
InsertEmpty();
Bind();
}

private void dgis_ItemCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
// stop editing
dgis.EditItemIndex = -1;

switch (e.CommandName)
{
case "Insert":
break;

case "Update":
break;

case "Cancel":
break;

case "Edit":
// begin editing
EditCommandColumn ecc = (EditCommandColumn) dgis.Columns[6];
ecc.UpdateText = "Insert";
dgis.EditItemIndex = e.Item.ItemIndex;
break;
}

// fill and bind
Fill();
//InsertEmpty();
Bind();
}

Thanks.

A popup window on a form does not move when I scroll up or down the web page. How can I correct this so that the popup window moves with the rest of the form when scrolling.

Try these two links, These two links are saying something related to your need. Try it out according to your need

http://www.codeproject.com/aspnet/AspNetScrollbarMove.asp[^]

http://www.codeproject.com/useritems/AutoScroll.asp[^]

Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com

Score it if you like my post