|
I have a dropdownlist and two datetimepicker textboxes i want to fill gridview while taking data from these controls. i use OR clause it not working. When i fill dropdown and datetime thn its working. i want that any of control is fill it show relevent data in gridview
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString29 %>"
SelectCommand="SELECT CouponTransaction.TransactionDate, CouponTransaction.SerialStart, <\pre><pre>CouponTransaction.SerialEnd, CouponTransaction.TotalSale, CouponTransaction.Price FROM<\pre>
<pre>CouponType INNER JOIN CouponTransaction ON CouponType.CouponTypeID = CouponTransaction.CouponTypeID <\pre><pre>WHERE (CouponType.CouponTypeID = @Coupon) OR (CouponTransaction.TransactionDate BETWEEN (@Start)AND( @End ))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="Coupon"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="UltimateCalendar1" Name="Start"
PropertyName="SelectedDate" />
<asp:ControlParameter ControlID="UltimateCalendar1" Name="End"
PropertyName="SelectedDate" />
</SelectParameters>
</asp:SqlDataSource>
|
|
|
|
|
I need to set a perticular cell color. I know how to set the whole gridview background color or a row bkg color, but I dont know how to do it for a particular one...
|
|
|
|
|
GridView1.Rows[0].Cells[0].BackColor = System.Drawing.Color.Red;
Hope this'll do the job.
|
|
|
|
|
You can do this!
For example:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[0].BackColor = System.Drawing.Color.Red;
}
}
I hope it can help you !
|
|
|
|
|
Hello every one i have a storeprocedure and i am calling it in my application but it gives an error.i am giving code here.
=================the error is============================
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.30]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'addloc2' at line 1
===================store procedure is=================
ELIMITER $$
DROP PROCEDURE IF EXISTS `addloc2` $$
CREATE DEFINER=`root`@`%` PROCEDURE `addloc2`(_loc varchar(50))
BEGIN
insert into test(Location) value(_loc);
END $$
DELIMITER ;
==================asp.net code is================================
odbcconnection con=new odbcconnection(connectionstring);
cmd=new OdbcCommand ("addloc2",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OdbcParameter ("_loc",OdbcType.VarChar)).Value ="nagpur";
con.Open();
cmd.ExecuteNonQuery();
con.Close();
|
|
|
|
|
Why would your stored proc include a drop statement ? This looks messy to me, it certainly looks wrong.
The first intelligent thing to do, is to run the proc inside your DB, so you can check if the proc is broken, or the code is broken. The code looks OK to me.
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.
|
|
|
|
|
Why dont you write a bit cleaner ?
OdbcConnection con=new OdbcConnection(connectionstring);
cmd=new OdbcCommand ("addloc2",con);
cmd.CommandType = CommandType.StoredProcedure;
OdbcParameter pLoc = new OdbcParameter("_loc",OdbcType.VarChar);
pLoc.Value = "nagpur";
cmd.Parameters.Add(pLoc);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
rinku soni 23 wrote:
===================store procedure is=================
ELIMITER $$
and hey where is D in the line ??
Is it what you are missing 
|
|
|
|
|
I used the following code for updating a record in gridview
protected void gvcmem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sMemberID=gvcmem.DataKeys[e.RowIndex].Values["nMemberID"].ToString();
TextBox txtnumber=(TextBox)gvcmem.Rows[e.RowIndex].FindControl("txtnumber");
string sMemebername = gvcmem.DataKeys[e.RowIndex].Values["sMemberName"].ToString();
DataView dvUpdate = objGeneral.EditMemberPhoneNumber(sMemberID, sMemebername, string.Empty, txtnumber.Text, string.Empty, "1");
if (dvUpdate[0]["sStatus"].ToString() == "Success")
{
lblmess.Text = "Member Details Updated Sucessfully";
lblmess.Visible = true;
}
else
{
lblmess.Text = dvUpdate[0]["sStatus"].ToString();
lblmess.Visible = true;
}
gvcmem.EditIndex = -1;
this.loadGrid();
}
while updating when the text in the textbox is changed its not taking the updated text its taking the previous data itself nyone help pls
|
|
|
|
|
What happens when you step through in the debugger ?
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.
|
|
|
|
|
the old text is coming in to the textbox but not the updated one
|
|
|
|
|
4anusha4 wrote: the old text is coming in to the textbox but not the updated one
You may be binding the grid on page_load without checking IsPostBack.
|
|
|
|
|
i am not binding it in page_load
|
|
|
|
|
OK. Let me try again. What happens when you step through the debugger ?
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.
|
|
|
|
|
there is no error but the record is not updating
|
|
|
|
|
OK, so your datalayer call is being called with the values you expect, but they are not being updated in the database ? Then you need to look at your data layer code to work out why.
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.
|
|
|
|
|
|
Hi dear all,
i am using the ajax enable web site. i created a master page where i placed Script manager and Update Panel. and a contenat place holder into the Update Panel. the master page have some buttons which is used to display other page(content page).
but when i run this web site and when i click any button it reloads whole page again.it there any setting for this into web.config file or properties of update panel that i have to make.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I would suggest you download the ASP.NET AJAX samples, run them and then work out why they work and your code does not. Or, read the documentation. If you still can't work it out, post the code here, so people can help you.
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.
|
|
|
|
|
Is the button inside the updatepanel ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
EnablePartialRendering="true"
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Hi All,
I am facing a proble in ASP.Net 1.0.
The Prob is that I am generating TextBoxes on user input. Like if user input 3 in textbox and click generate button 3 textboxes are added to Table Control (Web Control).
But when I m trying to access its .Text in code behind it is not showing anything..
My code sample is here
''Generate button
For i = 1 To num
Dim r As New TableRow()
Dim c As New TableCell()
Dim txtCaf As New TextBox()
txtCaf.ID = "txtCAF" & i.ToString
txtCaf.Attributes.Add("onkeypress", ONLY_NUMBER)
txtCaf.MaxLength = 10
Dim txtNoOfMDN As New TextBox()
txtNoOfMDN.ID = "txtNoOfMDN" & i.ToString
txtNoOfMDN.Attributes.Add("onkeypress", ONLY_NUMBER)
txtNoOfMDN.MaxLength = 3
c.Controls.Add(New LiteralControl(i))
r.Cells.Add(c)
c = New TableCell()
c.Controls.Add(txtCaf)
r.Cells.Add(c)
c = New TableCell()
c.Controls.Add(txtNoOfMDN)
r.Cells.Add(c)
Table1.Rows.Add(r)
Next
Access its value..
txtCaf = CType(Page.FindControl("txtCaf" & i.ToString), TextBox)
'this show Nothing
Please Help...
Be an Eagle, Sky is Yours.
|
|
|
|
|
Please read the forum guidelines, Please Help is a useless subject line.
Where do you add these controls ? If you add them during page load or later, they will not have any viewstate. they should still exist, assuming you added them before this code. If the access code is in an event, and the code to add is in page prerender, the controls are not there yet. But, I do expect once you find the control, you'll find it has no value.
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.
|
|
|
|
|
Sir,
Thanks for your reply..
Controls are added on Button's click event (after page load).
But I want to access its value..
Can you suggest me any idea to do this...
Be an Eagle, Sky is Yours.
|
|
|
|
|
suresh suthar wrote: Controls are added on Button's click event (after page load).
That's the problem. Read about ASP.NET page life cycle and how it uses viewstate to manage the control values. ASP.NET won't maintain viewstate for controls that are created on page_load.
|
|
|
|
|
Like Navaneeth said. The buttons you added on one click, will disappear in the next one. Your best bet is to abandon ASP.NET 1.0, although the problem persists in up to date versions of the framework, there are more appropriate events you can hook into. Any tutorial you find online may well tell you to hook into events you don't even have.
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
