|
Hi,
I have a datagrid that Inserts data into sql datbase, and amongest
there is a column that has a radiobuttonlist, the radiobuttonlist
contains two radiobuttons one with Good Mood and the otherone with bad
moods. In the column I placed two images where one shows a happy face
and the other one a sad face and I want when a user selects
radiobutton Good Mood the image with a happy face is inserted. but I'm
having a problem when I select radiobutton Good Mood I only get Good
Mood inserted but not the image. How should I do this? here is the
code I'm using:
DataTable table = new DataTable();
private DataTable Fill()
{
SqlDataAdapter adapter = new SqlDataAdapter("select * from
dbo.DashBoard", con);
adapter.Fill(table);
return table;
}
private void Bind()
{
dgis.DataSource = table;
dgis.DataBind();
}
private void InsertEmpty()
{
table.Rows.InsertAt(table.NewRow(), 0);
}
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":
System.Web.UI.WebControls.TextBox st=new
System.Web.UI.WebControls.TextBox();
st=(System.Web.UI.WebControls.TextBox)e.Item.Cells[6].FindControl("txtobjach");
System.Web.UI.WebControls.TextBox st1=new
System.Web.UI.WebControls.TextBox();
st1=(System.Web.UI.WebControls.TextBox)e.Item.Cells[5].FindControl("txtobj");
System.Web.UI.WebControls.TextBox st2=new
System.Web.UI.WebControls.TextBox();
st2=(System.Web.UI.WebControls.TextBox)e.Item.Cells[4].Controls[0];
System.Web.UI.WebControls.TextBox st3=new
System.Web.UI.WebControls.TextBox();
st3=(System.Web.UI.WebControls.TextBox)e.Item.Cells[3].Controls[0];
System.Web.UI.WebControls.TextBox st4=new
System.Web.UI.WebControls.TextBox();
st4=(System.Web.UI.WebControls.TextBox)e.Item.Cells[2].Controls[0];
System.Web.UI.WebControls.RadioButtonList st5=new
System.Web.UI.WebControls.RadioButtonList();
st5=(System.Web.UI.WebControls.RadioButtonList)e.Item.Cells[1].FindControl("rblmood");
System.Web.UI.WebControls.Image imgDaily = new
System.Web.UI.WebControls.Image();
imgDaily=(System.Web.UI.WebControls.Image)e.Item.Cells[1].FindControl("imgm");
System.Web.UI.WebControls.TextBox st6=new
System.Web.UI.WebControls.TextBox();
st6=(System.Web.UI.WebControls.TextBox)e.Item.Cells[0].FindControl("txtname");
SqlCommand myCommand=new SqlCommand();
myCommand.Connection=con;
myCommand.CommandText="insert into DashBoard
(ObjectiveAchieved,Objective,MoodToday,Name) values
(@ObjectiveAchieved, @Objective,@MoodToday,@Name)";
myCommand.Parameters.Add(new
SqlParameter("@ObjectiveAchieved",SqlDbType.Text));
myCommand.Parameters["@ObjectiveAchieved"].Value=st.Text;
myCommand.Parameters.Add(new
SqlParameter("@Objective",SqlDbType.Text));
myCommand.Parameters["@Objective"].Value=st1.Text;
myCommand.Parameters.Add(new SqlParameter("@Workinghrs",SqlDbType.Char,
45));
myCommand.Parameters["@Workinghrs"].Value=st2.Text;
myCommand.Parameters.Add(new SqlParameter("@Loggedout",SqlDbType.Char,
45));
myCommand.Parameters["@Loggedout"].Value=st3.Text;
myCommand.Parameters.Add(new SqlParameter("@Loggedin",SqlDbType.Char,
45));
myCommand.Parameters["@Loggedin"].Value=st4.Text;
myCommand.Parameters.Add(new
SqlParameter("@MoodToday",SqlDbType.Text));
myCommand.Parameters["@MoodToday"].Value=st5.SelectedValue;
myCommand.Parameters.Add(new SqlParameter("@Name",SqlDbType.Text));
myCommand.Parameters["@Name"].Value=st6.Text;
if(e.Item.Cells[1].Equals("Good Mood"))
{
imgDaily.ImageUrl = "IS_dashboard/Moods/laughing.gif";
}
else
{
imgDaily.ImageUrl = "IS_dashboard/Moods/sad.gif";
}
con.Open();
myCommand.ExecuteNonQuery();
con.Close();
dgis.EditItemIndex=-1;
BindDataGrid();
break;
case "Cancel":
break;
case "Edit":
dgis.EditItemIndex = e.Item.ItemIndex;
EditCommandColumn ecc = (EditCommandColumn) dgis.Columns[7];
ecc.UpdateText = "Insert";
break;
}
Fill();
InsertEmpty();
Bind();
}
protected void rblmood_SelectedIndexChanged(object sender,
System.EventArgs e)
{
RadioButtonList rbl = (RadioButtonList)sender;
Control parent = rbl.Parent;
while(!(parent is System.Web.UI.WebControls.DataGridItem))
{
parent = parent.Parent;
}
}
protected int SetState(object st)
{
string state = st.ToString();
if(state.Equals("True"))
{
return 0;
}
else
{
return 1;
}
}
Thanks.
|
|
|
|
|
hi I have not done anything like this but I think I can try.I have done similiar but using checkbox, but I just need to check or uncheck the checkbox u can do the same for radion button.
U can use this:
<asp:TemplateField HeaderText="Modify">
<ItemStyle HorizontalAlign="Center" Width="50px" />
<HeaderStyle Width="70px" CssClass="heading" />
<ItemTemplate>
<asp:CheckBox ID="chkModify" runat="server" AutoPostBack=true OnCheckedChanged="chkModify_Changed" />
</ItemTemplate>
</asp:TemplateField>
Dim ml_blnflagView As Boolean = False
For intGridRowcounter = 0 To GridViewForm.Rows.Count - 1
If CType(GridViewForm.Rows(intGridRowcounter).FindControl("chkModify"), CheckBox).Checked = False Then
ml_blnflagModify = True
'Exit For
Else
'If cboUserName.SelectedIndex = 0 Then
' CType(GridViewForm.Rows(intGridRowcounter).FindControl("chkUpdate"), CheckBox).Checked = False
' Hidden2.Value = 1
' Exit Sub
'End If
CType(GridViewForm.Rows(intGridRowcounter).FindControl("chkView"), CheckBox).Checked = True
End If
If CType(GridViewForm.Rows(intGridRowcounter).FindControl("chkView"), CheckBox).Checked = True Then
ml_blnflagView = True
'Exit For
Else
ml_blnflagView = False
End If
Next
If ml_blnflagModify = True Then
chkAllModify.Checked = False
chkAllPermission.Checked = False
Else
chkAllModify.Checked = True
chkAllView.Checked = True
AllPermission()
'chkAllPermission.Checked = True
End If
If ml_blnflagView = False Then
chkAllView.Checked = False
chkAllPermission.Checked = False
End If
If chkAllAdd.Checked = True And chkAllModify.Checked = True And chkAllDelete.Checked = True And chkAllView.Checked = True And chkAllPrint.Checked = True Then
chkAllPermission.Checked = True
End If
End Sub
Hope this helps u...
All the best...
|
|
|
|
|
Thanks varshavmane,
I'm tring your example but i'm having a problem you are using VB and I use C# Could you make it in C#?
Thank you.
|
|
|
|
|
Hi All,
1)i am getting Error "Load Report Failed ".when i try to run a CrystalReport.Pls tell me how to solve this problem.
2) And also tell me how to pass parameters to a Report
3) How to run Totals and SubTotals in Crystal Report.
if possible pls send code to my mail id
pusnsuresh@yahoo.com
Thanks
|
|
|
|
|
siddisagar wrote: 1)i am getting Error "Load Report Failed ".when i try to run a CrystalReport.Pls tell me how to solve this problem.
you might not given the report path properly
siddisagar wrote: 2) And also tell me how to pass parameters to a Report
search crystal report push method in code project
siddisagar wrote: 3) How to run Totals and SubTotals in Crystal Report.
on the report, right click on the page footer or report footer then select subtotal or total then choose the filed which you want to sum
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
i want to implement the functionality of remember me checkbox which is usually there on login form whereby the computer remembers the username and encrypted password for user next visit on that page through cookies.
Can anyone pls help me out .
its urgent 
thanks in advance.
|
|
|
|
|
|
a request sorry for not mentioning it before is
I need an encrypted form of Password to store as cookie so how is encryption done can you help me out .
thanks
|
|
|
|
|
|
I am using Visual Studio.NET 2003. i am using datagrid. i want paging to be done in datagrid. i was able to display the 2 records per page.But was not able to go to the second page.How to read the second page.
Mohinder Singh
|
|
|
|
|
Properties: or Add in Html code
AllowPaging : True.
PageSize="3"
then Use this code in codebehind:
---------------------------------
you have to write code in this Event.
DataGrid1_PageIndexChanged():
DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataSource = dsObj.Tables("Login")
DataGrid1.DataBind()
if u have any doubts then ask again
|
|
|
|
|
what is dsobj
This is what i am doing to pop the records in the grid. Now tell me what to do now.
Dim AddDetComm As New SqlCommand("Address_Book_Details", ABCon.Siteconnection)
AddDetComm.CommandType = CommandType.StoredProcedure
Dim AddDetada As New SqlDataAdapter(AddDetComm)
AddDetada.Fill(AddDetDataset)
AddressGrid.DataSource = AddDetDataset
AddressGrid.DataBind()
Mohinder Singh
|
|
|
|
|
hey dear friends please help me out it is not working. i am working on asp.net 2003.
Mohinder Singh
|
|
|
|
|
"dsObj" means Dataset object.Pls find the code below follow these steps then u willn't get any problem.
1.Modify connectionString
2.Place u r storedprocedure or Query in place of my Query
3.Fire DataGri1_PageIndexed Change Event and paste my code
if u still get any prob then ask me again.This code is working here.
.VB(CodeBehind)
--------------
Dim conObj As New SqlConnection
Dim adpObj As New SqlDataAdapter
Dim dsObj As New DataSet
Page_Load()
-----------
Try
conObj = New SqlConnection("Data Source=B4B-2F-323-CK26;user id=sa;password=sa;Database=TEST")
conObj.Open()
adpObj = New SqlDataAdapter("SELECT * FROM Login", conObj)
adpObj.Fill(dsObj, "Login")
DataGrid1.DataSource = dsObj.Tables("Login")
DataGrid1.DataBind()
Catch ex As Exception
Response.Write(ex.ToString())
End Try
DataGrid1_PageIndexChanged()
----------------------------
DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataSource = dsObj.Tables("Login")
DataGrid1.DataBind()
This will definitly helpful for u
Bye
|
|
|
|
|
|
I am using capicom and doing the encryption , the algorithm is 3DES. I am encryting a value and using this value I am doing an encryted login to a site.
I have set the source of the iframe as this url , in which the encrypted value is passed as a query string.
My problem is , I am able to view the page some times and other insatnces I get a "Page Cannot be displayed " message i.e. Error 404 .
Is this due to some problem in encrytion or decrytion. Or is it due to something that is related a .Net while doin an encrypted login.
I am not sure how to trace at who's end the problem is.
Have any body faced a problem like this, please help
Thanks in advance
|
|
|
|
|
I am using Stored Procedures. There i pass a parameter of type datetime. From front end i pass now.date. it gives error. can i format the date which i get by NOW.DATE. I want in the form of "dd/MM/yyyy" and it gives in the form "MM/dd/yyyy".
Mohinder Singh
|
|
|
|
|
u can do as below
DateTime.Now.toString("dd/MM/yyyy")
Thanks,
Sun Rays
|
|
|
|
|
Hi
i'm using asp javascript call back to retrieve
a text from the server and i want to highlight
the keywords in the retrieved text using a
highlight function written in ac# script on the client.
Now i have a problem in calling the highlight function
after getting control back from the server in the client
script, the highlight function is never called after getting back!!
here's the javasript code:
function GetMessageFromServer()
{
CallServer();
}
function ReceiveServerData(rValue)
{
//Label1 is a hidden label inorder to pass the
// string retrieved from the server to the highlight function
document.forms[0]['Label1'].Text=rValue;
if(rValue!="")
{
//calling the highlight function
<% if( ! (Label1.Text.Equals("")))
{
lbl.Text=Highlight(Label1.Text,"test me please!!");
}
%>;
}
}
help is highly appreciated,
Thanx
|
|
|
|
|
r_jaz wrote: URGANT
You may get a faster response if you don't label your post as URGENT (or URGANT as per your preference)
|
|
|
|
|
HI all,
Am working in a maintenance project.so in it am having one webservice.to know the functionality and what it is,how can i run it in VS2003.pls guide me the way.
I mean,simply how to run an already created webservice.
Thanks all
Have a Nice Day Dudes
|
|
|
|
|
Kushi Bobby wrote: I mean,simply how to run an already created webservice.
If you are sure that you can, then creating also will be easy. Start VS2003. Start new webservice project. Write whatever methods you want. Methods you want to be called from some other project set WebMethod() attribute. Now bulid it. Run it , copy the location from browsers address bar.
50% completed
Next is using it, Create one more project, add webreference, paste the url there. Then it will display the methods you created on webservice. Complete adding reference. In codebehind create object for the webservice u added, and call the functions as u do earlier....
|
|
|
|
|
HI Navneeth,
Thanks for the reply,but illustrate me how to create an object in another application.
That too pls guide me how to add the existed webservice in my application.When i tried web reference to add its not showing the webservices in the local machine.
Bye
Have a Nice Day Dudes
|
|
|
|
|
hi
i design a web page with .net and css
when i run this page in IE , it's very good
but when i run with "Mozilla firefox" , show bod .
how can correct it ?
thanks
|
|
|
|
|
DHTML is the best option for all browser
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
