ASP.NET Discussion Boards

Christian Graus9-Nov-09 21:09

9-Nov-09 21:09

If you've done this, why did you post twice to tell us ? Perhaps if it's so good, you could write an article. This area is for questions.

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: Creating Scorm Course in asp.net

netJP12L16-Nov-09 10:57

netJP12L

16-Nov-09 10:57

how did you create SCOM course and also how did you manage to transfer data from scorm object to LMS. Could you provide some basic examples. There is so much information but nothing is simple and takes u not to have headace while reading. I would much appreicat it.

In ASP.Net, how to resize iFRAME at runtime?

hifiger20049-Nov-09 20:19

hifiger2004

9-Nov-09 20:19

Hi Guys,

I have a problem resizing the iFrame at runtime. I need to resize it based on different screen resolutions.

This is the html tag of my iFrame:

<a id="iiframe" href="livechat.aspx iframe=true&amp;width=394&amp;height=520" rel="prettyPhoto[mixed]">
<img src="images/corner.png" width="190" height="205" />
</a></div>

hifiger2004

Re: In ASP.Net, how to resize iFRAME at runtime?

Nishant Singh9-Nov-09 20:37

Nishant Singh

9-Nov-09 20:37

Heyy,
give width and height in % rather than pixels

Datalist Image

KhandelwalA9-Nov-09 19:53

KhandelwalA

9-Nov-09 19:53

I m showing Product image, description, specification in datalist through database........this is asp code.......

<asp:datalist id="DataList1" runat="server" width="80%" cssclass="Datalist">
<itemstyle backcolor="White">
<itemtemplate>

<asp:imagebutton id="ImageButton2" runat="server" height="230px"
="" width="230px" imageurl="<%#Container.DataItem("Picture") %>">

<asp:label id="lblHeading" runat="server" cssclass="ProductHead"
="" text="< %#Container.DataItem("Name") %>">

<asp:label id="lblDesc" runat="server" cssclass="ProductDesc"
="" text="<%#Container.DataItem("Description") %>">

<asp:label id="lblProductDetails" runat="server" cssclass="ProductDetails"
="" font-underline="True" text="Product Details">

<asp:label id="lblItem" runat="server" font-bold="True" font-names="Verdana"
="" font-size="Small" forecolor="Gray" text="Item #">
<asp:label id="lblIt" runat="server" cssclass="ProductPD"
="" text="<%#Container.DataItem("ItemNo") %>">

<asp:label id="lblTI" runat="server" cssclass="ProductDetails"
="" font-underline="True" text="Tanzanite Info">

<asp:label id="lblQuality" runat="server" font-bold="True" font-names="Verdana"
="" font-size="Small" forecolor="Gray" text="Quality:">
<asp:label id="lblQ" runat="server" cssclass="ProductPD"
="" text="<%#Container.DataItem("Quality") %>">

<asp:label id="lblDimensions" runat="server" font-bold="True"
="" font-names="Verdana" font-size="Small" forecolor="Gray" text="(LengthxWidthxHeight):">
<asp:label id="lblW" runat="server" cssclass="ProductPD"
="" text="<%#Container.DataItem("length") %>">
<asp:label id="X1" runat="server" cssclass="ProductPD" text="x">
<asp:label id="lblH" runat="server" cssclass="ProductPD"
="" text="<%#Container.DataItem("width") %>">
<asp:label id="X2" runat="server" cssclass="ProductPD" text="x">
<asp:label id="lblD" runat="server" cssclass="ProductPD"
="" text="<%#Container.DataItem("height") %>">

<asp:label id="lblPrice" runat="server" font-names="Verdana" font-size="Medium"
="" forecolor="Gray" text="PRICE:">
<asp:label id="Label13" runat="server" cssclass="ProductPrice" text="$">

<asp:label id="lblPr" runat="server" cssclass="ProductPrice"
="" text="<%#Container.DataItem("Price") %>">

<asp:button id="btnAddToBasket" runat="server" backcolor="#2165B0"
="" bordercolor="Black" borderstyle="Double" borderwidth="1px" font-names="Verdana" forecolor="White" text="ADD TO BASKET" commandname="atb">

<asp:imagebutton id="ibWishlist" runat="server"
="" imageurl="~/Images/wishlist.gif">
<asp:linkbutton id="lbAddtoWishlist" runat="server" font-names="Verdana"
="" font-size="X-Small" forecolor="#4B7BB0">Add to Wishlist

This is page behind code........

Dim id As Integer = Request.QueryString("id")
      Dim cmd As String = "Select * from Products where StoneID=" & id & ""
      Dim rdr As IDataReader = db.ExecuteReader(CommandType.Text, cmd)
      DataList1.DataSource = rdr
      DataList1.DataBind()

Now wht i want is whnvr user took mouse over on image..........a button of Enlarge will show.............and on click the image got enlarge...........and background become change in black color.........how to do in datalist................plz guide me a bit......... Smile | :)

Re: Datalist Image

Nishant Singh9-Nov-09 20:14

Nishant Singh

9-Nov-09 20:14

Yaar,
Please post only relevent code snippet ,
"itni ramayan kaun padhega Frown | :(

How to Edit a gridview ,Please correct the code which i gave here.

rinku soni 239-Nov-09 19:19

rinku soni 23

9-Nov-09 19:19

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//TextBox t= (TextBox )GridView1.Rows[e.RowIndex ].FindControl ("txtId");
//TextBox t2=(TextBox )GridView1.Rows[e.RowIndex ].FindControl ("txtName");
GridViewRow row = GridView1.Rows[e.RowIndex];
TextBox t = (TextBox)row.FindControl("txtId");
TextBox t2 = (TextBox)row.FindControl("txtName");
con.Open();
cmd = new OdbcCommand("update table AdminAddNewItem set Node_Name= '" + t2.Text + "' where Node_Id=" + t.Text, con);
cmd.ExecuteNonQuery();
con.Close();

Re: How to Edit a gridview ,Please correct the code which i gave here.

Christian Graus9-Nov-09 19:36

Christian Graus

9-Nov-09 19:36

Apart from the part where your code is broken and I can erase your entire database with it ?

What's happening with this code ? Why do you feel it needs correcting ?

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: How to Edit a gridview ,Please correct the code which i gave here.

Arnalyn19-Feb-10 0:37

Arnalyn

19-Feb-10 0:37

$Shucks | :-\$ $Shucks | :-\$ Suspicious | :suss:

Re: How to Edit a gridview ,Please correct the code which i gave here.

Nishant Singh9-Nov-09 20:06

Nishant Singh

9-Nov-09 20:06

Use stored procedure...or atleast use parametrised Query ,
Please don't write like this

Re: How to Edit a gridview ,Please correct the code which i gave here.

Raja Soosai10-Nov-09 2:20

Raja Soosai

10-Nov-09 2:20

Hi,

Please use the following line to access the data grid textbox value from code behind

Convert.ToString(CType(GridView1.Rows(i).FindControl("Text1"), Textbox).Text)

Thanks,
Raja.S

how to display data in grid without sending the data in the database

Flavia A9-Nov-09 18:57

Flavia A

9-Nov-09 18:57

In a web based application i have some textboxes and on the button click the data from the textboxes should be displayed in a gridview or some other conrol where the data can be displayed, modified such that the data be sent back to the textboxes for modifying and back into the gridview .Another button for deleting the data and finally on the click of a button that is outside the gridview the data from it should go into the database.
I was able get the data into the gridview from the textboxes to the grid and back using the
select "textbox1.text" as data1,"textbox2.text"as data2 etc.and was able to modify the data.but for deleting the row i was not able to trace which row is getting deleted and am not able to sent the data to the database on the button click outside the gridview.What should I do? is there some way i can use the gridview itself for the same or i should use some other conrol ?

Re: how to display data in grid without sending the data in the database

Christian Graus9-Nov-09 19:02

Christian Graus

9-Nov-09 19:02

You can use a list of objects as a datasource. You don't need to use a database.

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: how to display data in grid without sending the data in the database

Satish Mahapatra9-Nov-09 19:44

Satish Mahapatra

9-Nov-09 19:44

Why dont u store the IDs of the deleted records and during saving the grid to DB delete the records from DB using thoseIDs.

Re: how to display data in grid without sending the data in the database

Flavia A9-Nov-09 22:19

Flavia A

9-Nov-09 22:19

thanks for the reply..

if i used 2 link button and both have the same command name select on the selected index changed of the gridview i am not able to trace which button has been clicked if the delete or the modify.more over if i use the command name update for the delete button and call the GridView1_RowUpdating event i cannot retain the the gridview1.selectedrow.cells[1].text. for deleting where i update the delete status to be Yes.
As it is a web application on the button click outside the grid cannot retain the gridview1.SelectedRow.cells[0].text cannot be retreived and it throws an enception.
what should i do is there anything optional to a gridview.
Please reply soon

Re: how to display data in grid without sending the data in the database

Satish Mahapatra9-Nov-09 23:38

Satish Mahapatra

9-Nov-09 23:38

I tried your case,deleting the rows by clicking the delete button in each row.then i saved the PK of each row and finally during saving delete those rows by using the IDs.

I just put a column for ID which has the commandargument set to id,on delete event i was getting the IDs by this
int rowIndex = e.RowIndex;
LinkButton lnk = (LinkButton)GridView1.Rows[rowIndex].FindControl("lnkID");

Is it the case that u are searching or anything else.

Re: how to display data in grid without sending the data in the database

Flavia A10-Nov-09 0:27

Flavia A

10-Nov-09 0:27

thanks i will try it and tell you.

Re: how to display data in grid without retreiving data from the database and later the dat from the gridview should go into the database.

Flavia A10-Nov-09 0:51

Flavia A

10-Nov-09 0:51

am sorry for the trouble am new to asp.net ,but as the data in the grid is not from the database but from the textboxes in the form.as the data is not actually in the database i cannot delete the row by using a query.That row has to be out of the grid as soon as i pess the delete button,add on the click of a button that is outside the gridview,i want all the data to go into the database.ie am using the gridview so that the user can modify any entry that he made in the textboxes and delete the rows that he wants and send it to the database later..

connection with my sql with ASP.Net

Amit Patel19859-Nov-09 18:30

Amit Patel1985

9-Nov-09 18:30

Hi All,

I want to connect Asp.net application with the my sql 5.0.please help me which driver need to be installed.

when i m tring to open the connection this is giving error

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

and my connection string is

string ConnStr = "Driver={MySQL ODBC 5.0 Driver};Server=localhost;Database=testwithdotnet;uid=root;pwd=password;Port=3306;Option=3";

and i installed this MySQL Connector Net 5.1.7 diver

Thanks and regards,

Amit Patel

Re: connection with my sql with ASP.Net

Christian Graus9-Nov-09 18:46

Christian Graus

9-Nov-09 18:46

I've never seen the driver specified in the connection string, I've just installed the right classes to deal with the data source, and used 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: connection with my sql with ASP.Net

Gamzun9-Nov-09 20:06

Gamzun

9-Nov-09 20:06

Try this An ASP.NET Application Using a MySQL Database[^]

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

found solution

Amit Patel19859-Nov-09 20:21

Amit Patel1985

9-Nov-09 20:21

Hi All,

Thanks all . I have solved this problem

using following way

MySqlConnection con = new MySqlConnection(("server=127.0.0.1; user id=root; password=password; database=testwithdotnet; pooling=false;"));

Thanks and regards,

Amit Patel

modified on Tuesday, November 10, 2009 2:57 AM

Re: found solution

Christian Graus9-Nov-09 21:09

Christian Graus

9-Nov-09 21:09

Well, that's what we both told you to do, so....

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.

[Message Deleted]

Amit Patel19859-Nov-09 18:30

Amit Patel1985

9-Nov-09 18:30

[Message Deleted]