|
I've just started playing around with ASP.NET. I run into problem with the datagrid. My intention is to use the "EditItemIndex" feature to get one of the rows converted into edit-boxes instead of plain test.
My problem is that I can't seem to get edit-boxes, instead the row to be edited remains in plain text.
I am using the "create columns automatically at run-time" option. Could this be the problem? I have tried both to handle the event when the "Edit" button is pressed and to set the EditItemIndex = 1 from start. Neither of it seem to work.
Here is the code of the example where the EditItemIndex is set to one from start:
-------- HTML ----------------------------------------------
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="Test1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="dgResult" style="Z-INDEX: 101; LEFT: 280px; POSITION: absolute; TOP: 104px" runat="server" Width="328px" Height="392px" EditItemIndex="2"></asp:DataGrid>
</form>
</body>
</HTML>
-------------- END OF HTML ------------------------------------------------
--------- CODE BEHIND -------------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace Test1
{
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid dgResult;
private void Page_Load(object sender, System.EventArgs e)
{
string sqlQueary;
string connectionString = "server=localhost; database=Northwind; uid=sa; pwd=xxxxx;";
SqlConnection conn = new SqlConnection(connectionString);
sqlQueary = "SELECT CustomerID, CompanyName FROM customers";
SqlCommand sqlCom = new SqlCommand(sqlQueary, conn);
conn.Open();
dgResult.DataSource = sqlCom.ExecuteReader();
dgResult.DataBind();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
--------- END OF CODE BEHIND ------------------------------------
Any idea of what could be wrong is appreciated!
|
|
|
|
|
Hi there,
When you have the AutoGenerateColumns set to true, the datagrid will generate the BoundColumns based on the specified datasource. And one more thing is that you are using the SqlDataReader which basically provides a way to retrieve a read-only, forward-only stream of data. So the automatically generated bound columns all have the ReadOnly[^] property set to true, and as a result of this you don't see the datagrid is in the edit mode. In your case, you either set the AutoGenerateColumns to false and declare the columns for the control or use another type of the datasource like the DataSet, DataTable, ....
|
|
|
|
|
Thanx pal!
I changed AutoGenerateColumns into false and voala.
|
|
|
|
|
Greetings to everyone,
I am implementing a Web Service that will make a SELECT query from a database and then return a dataset.
I am also implementing a client application that will run on a Pocket PC and which will "consume" the web service. In order to test the web service, the client application only has a textbox, a button and a listbox. It looks like this:
http://i8.photobucket.com/albums/a21/Hambos/client.jpg
The Server Application (web service) compiles ok. I can test the web service by entering the string input, then pressing invoke, and I get the query result (in xml).
The Client Application also compiles successfully, but when I try to debug it, I get the error :
System.Net.WebException was unhandled
StackTrace:
σε System.Net.HttpWebRequest.finishGetResponse()
σε System.Net.HttpWebRequest.GetResponse()
σε System.Web.Services.Protocols.WebClientProtocol.GetWebResponse()
σε System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse()
σε System.Web.Services.Protocols.SoapHttpClientProtocol.doInvoke()
σε System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke()
σε Client_Application.GetIngredients.AllergyON.GetIngredients()
σε Client_Application.Form1.button1_Click()
σε System.Windows.Forms.Control.OnClick()
σε System.Windows.Forms.Button.OnClick()
σε System.Windows.Forms.ButtonBase.WnProc()
σε System.Windows.Forms.Control._InternalWnProc()
σε Microsoft.AGL.Forms.EVL.EnterMainLoop()
σε System.Windows.Forms.Application.Run()
σε Client_Application.Program.Main()
I would be grateful if someone could take a look at my code and indicate any errors.
*******************************
SERVER APPLICATION (Web Service)
*******************************
// This code creates a DataSet object by running a query
// against the t_Ingredients table in the "AllergyON" database
// on SQL Server 2005.
namespace AllergyON
{
using System;
using System.Collections;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data.OleDb;
public class AllergyON : System.Web.Services.WebService
{
public AllergyON()
{
}
private void InitializeComponent()
{
}
// Here starts the code that returns the Ingredients
// list from the AllergyON SQL Server database
[WebMethod(Description = "AllergyON GetIngredients WebMethod")]
public DataSet GetIngredients(string food_name)
{
if (food_name == "")
food_name = "%";
DataSet ds = new DataSet();
//creating the connection
string conString = "server=****; uid=**** ; pwd=**** ; database=AllergyON_db";
System.Data.SqlClient.SqlConnection gi = new SqlConnection(conString);
try
{
gi.Open();
}
catch (Exception e)
{
return null;
}
// The SqlCommand contains the SQL select statement and
// the connection object
SqlCommand cm =
new SqlCommand("select t_Ingredients.Ingredient_Name "+
"from t_Ingredients inner join (t_Foods inner "+
"join Foods_Ingredients on "+
"t_Foods.Food_ID = Foods_Ingredients.Food_ID)"+
"on t_Ingredients.Ingredient_ID = Foods_Ingredients.Ingredient_ID "+
"WHERE t_Foods.Food_Name = '"+food_name+"';", gi);
SqlDataAdapter da = new SqlDataAdapter(cm);
da.Fill(ds,"Ingredients");
gi.Close();
return ds;
}
}
}
***************************
And here is the Client Application
***************************
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Diagnostics;
using System.Text;
using System.Windows.Forms;
namespace Client_Application
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
// The Web Service returns the data as a DataSet to the
// client application and the client application holds on
// to that DataSet and binds it to the "listbox1" listbox
private void button1_Click(object sender, EventArgs e)
{
AllergyON.AllergyON temp = new AllergyON.AllergyON();
DataSet ds = temp.GetIngredients(this.textBox1.Text);
listBox1.Items.Clear();
// a single line of code is responsible for pulling
// the entire dataset down to the client side.
// The DataSet is now an object that has all the
// capabilities of the ADO.Net DataSet class
for (int x = 0; x < ds.Tables["Ingredients"].Rows.Count; x++)
{
listBox1.Items.Add(ds.Tables["Ingredients"].Rows[x].ToString().Trim());
}
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
// listBox1.Items.Clear();
}
}
}
|
|
|
|
|
how can i add media player like avi,mpg to my project asp.net with vb.net ?
i want to press button and media player work ?
thank you very much ! please ?
|
|
|
|
|
Hi there.
You can use the Object[^] element to host a player on the web page .aspx, and use the client side script to handle the start/pause/stop actions of the player. You can use the search comments functionality of the site to look for the sample code posted in the past.
|
|
|
|
|
I want to customise browser to display data. It must be looks like a VB form(Hide all bars-menu,task,addressand close button etc.) Plz help me
|
|
|
|
|
When using window.open you can remove some of those, but not all. Menu, address and such can be removed. The status bar can only be removed if the site is added to trusted sites. The close button can not be removed.
---
b { font-weight: normal; }
|
|
|
|
|
Search for help on "Chromeless windows" on google.
Best Regards,
Darpan Gogia
|
|
|
|
|
I'm hosting my page on a European server, the problem is I want the currency in US Dollars. Right now they show as 0,25 SK, but I want it to be $0.25. Is there a web.config setting for this?
|
|
|
|
|
You should be able to do that. There must be a setting somewhere in the Control Panel settings of your account, or if you're using a component, there should be a setting (property) from code. Anyway your best bet would be to contact the support of your provider. They will let you know your options.
regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
|
|
|
|
|
Specify a culture when you convert the values to strings.
Example (for swedish culture):
CultureInfo se = new CultureInfo(1053);<br />
double price = 0.25;<br />
<br />
string priceTag = price.ToString("c2", se);
---
b { font-weight: normal; }
|
|
|
|
|
|
Hi,
My self vijen kumar. i want some help about Search Engine. I want to Create a Search Engine, But i am confused that from where start the project.
Please Help Me asap.
Thanks
Vijender kumar
|
|
|
|
|
how do i make a row of a table invisible in the beginning, and visible when the following function is run
function Expand(name)
{
var elem = document.getElementById(name);
if (elem.style.display == "none")
{
elem.style.display = "block";
}
else
{
elem.style.display = "none";
}
}
|
|
|
|
|
Please don't cross post.
---
b { font-weight: normal; }
|
|
|
|
|
add style attribute (display=none) in TR.
Or, if using ASP.Net use RegisterStartupScript to call a collapse function on page load, similar to your expand function. Collapse function should collapse all rows in the table/grid at once.
Best Regards,
Darpan Gogia
|
|
|
|
|
I have created my own usercontrol and associated its namespace to VWCVS.
in main.aspx, where i want to use the control, i have assocated its partial class to VWCVS as well
but VS doesnt regconize my usercontrol class. when i type the namespace "VWCVS.", its only giving me main. why does this happen?
|
|
|
|
|
Hi 2hdass 
You're probably in the CodeBehind file when you're trying to access your User Control (UC).
When you drag and drop a UC on to the webform where you want to use it - Visual Studio.net only adds the UC to the ASPX file, not the ASPX.CS (or ASPX.VB).
That means that you have to declare your User Control yourself in your CodeBehind file.
For example:
If your User Control's name is MyUserControl, and the name of the UC instance in the ASPX file is MyUserControl1, then somewhere in your CodeBehind file, declare:
MyUserControl MyUserControl1 Then you should be able to access the usercontrol in code.
Make sure that the name of the UserControl on the page, and in the CodeBehind file are the same, or else it won't work
Kind regards - Jakob 
*********************************************
Three kinds of people in the world:
- Those who can count..
- Those who can't!
10 kinds of people in the world:
- Those who understand binary
- Those who don't
|
|
|
|
|
How do you go about doing something like this?
i want to keep a record of the current page number i know i could use a session but I wanted to try the property method as a different way.
Here is what I have came up with
Pageload()
if NOT ispostback()
pagenumber =1
end if
Public Property pagenumber()
Get
Return value ' not sure what to put here if i need to declare an integer or what?
End Get
Set(ByVal value)
dim myvalue = value ' confused on this if thats what i need to do? or not.
End Set
End Property
thanks for the help just confused on this one.
couldn't find an answer on google but probably not looking in the right place 
MeterMan
"Live life to its fullest because, you never know when it will be taken away."
|
|
|
|
|
Here is what I have came up with but for some reason the code doesn't hold the current pagenumber it resets it every time to 1 according to debugger. I have it is not ispostback so this has me puzzled. Please look at code and advise thanks
http://pastebin.com/662278
thanks alot
MeterMan
"Live life to its fullest because, you never know when it will be taken away."
|
|
|
|
|
The value is not reset, it simply doesn't exist from one request to the next. For each request a new Page object is created, it isn't preserved from one request to the next.
---
b { font-weight: normal; }
|
|
|
|
|
Why won't this work?
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Title" %>
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Request.Form("Search_Box") <> "" Then
Display_Text.Text = Request.Form("Search_Box")
End If
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="Main" Runat="Server">
<asp:Label ID="Search_Text" runat="server" Text="Search:" />
<asp:TextBox ID="Search_Box" runat="server" />
<asp:Button ID="Search_Button" runat="server" Text="Search" /><br />
<asp:Label ID="Display_Text" runat="server" Text="" />
</asp:Content>
I want to type in the text box, press enter (or click the button) and have the text show in the Display_Text label. If I put it on a page without a Master Page it's fine, so what am I missing? Should I post the Master Page also (I tried it in a blank Master Page, and still had the issue)?
|
|
|
|
|
I would think you would want to reference the text box's Text property directly, like this:
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Title" %>
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Search_Box.Text <> "" Then
Display_Text.Text = Search_Box.Text
End If
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="Main" Runat="Server">
<asp:Label ID="Search_Text" runat="server" Text="Search:" />
<asp:TextBox ID="Search_Box" runat="server" />
<asp:Button ID="Search_Button" runat="server" Text="Search" /><br />
<asp:Label ID="Display_Text" runat="server" Text="" />
</asp:Content>
|
|
|
|
|
Wow, don't know how I screwed that up, now that I can get the data I want, I'd like to use it in a SelectCommand...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Search_Box.Text <> "" Then
Want_SQL.SelectCommand = "SELECT * FROM [Wanted Cost] WHERE [Name] LIKE '%" & Search_Box.Text & "%'"
Else
Want_SQL.SelectCommand = "SELECT * FROM [Wanted Cost]"
End If
End Sub
But it won't work the SelectCommand was changed (I made a label and added Label1.Text = Want_SQL.SelectCommand) but it wasn't run again. How do I fix that?
On another subject, I want to format a BoundField as Currency, what's the DataFormatString setting to do that? Is there somewhere I can find how to make DataFormatStrings?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
