Comments by Member 10021658

Member 10021658 14-Dec-15 4:19am View

<table style="border: 1px solid #c1650f; width: 35%; padding: 10px 0px 10px 10px"
cellpadding="0">
<asp:Repeater ID="Repeater2" runat="server">
<itemtemplate>
<tr align="right">
<td>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("SName")%>' />
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text='<%#Eval("Address")%>' />
<asp:Label ID="Label3" runat="server" Text='<%#Eval("Phone") %>' />
</td>
</tr>

</table>

Here I want to display three columns data like SName, Address and Phone. If Student don't have phone number that row should be displayed on SName data, at same time Address and Phone numner is disabled. Thanks

Member 10021658 14-Dec-15 4:02am View

Deleted

Dear Sinisa, Thanks for your reply. I have already used where condition. But I need to display SName always and disable the address if Phone is null.
O/p
SName Address Phone
Sai Bglr 1234567890
Alex (Alex don't have phone so address data is disabled)

Thanks

Member 10021658 14-Dec-15 4:00am View

Dear Sinisa, Thanks for your reply. I have already used where condition. But I need to display SName always and disable the address if Phone is null.
O/p
SName Address Phone
Sai Bglr 1234567890
Alex (Alex don't have phone so disabled the address data)
Raju hyd 1245678990

Thanks

Member 10021658 14-Dec-15 3:58am View

Dear Sinisa, Thanks for your reply.
Thanks

Member 10021658 23-Jul-15 3:23am View

Thanks Suvendu Sekhar.
It's working fine. Thanks once again

Member 10021658 23-Jul-15 3:19am View

I want to bind the value to repeater control based on string values.
Please follow bellow example based on above query .

I have two tables like tblCategories(CategoryId, CategoryName) & tblSubCategories (CateoryName, Id, SubCategoryName). Now I would like to bind the subcategories based on categoryName. I hope you understand my issue.

Member 10021658 18-Nov-14 7:59am View

I got the output by using StateId's.

Thanks.

Member 10021658 18-Nov-14 7:47am View

Same thing using except like,

select * from tblStates except select * from tblStates where StateName='Andhra Pradesh' or StateName='Andaman & Nicobar Islands'

I have got the output all states except Andhra pradesh.

Member 10021658 18-Nov-14 7:45am View

Dear Tomas,

Thanks for your reply. I have already tried using these query

select * from tblStates intersect select * from tblStates where StateName='Andhra Pradesh' or StateName='Andaman & Nicobar Islands'

But I got the output Andhra Pradesh only, not both.

Member 10021658 30-Oct-14 8:07am View

Dear Aajmot,

Thanks for your reply.

I have to tired this way Visible='<%# Eval("Img1") != string.Empty %>'
Visible='<%# Eval("Img2") != string.Empty %>'

In these slideshow is working very fine but empty values also sliding.
Is it correct way?

Member 10021658 29-Oct-14 6:43am View

Dear Suvendu,

Thanks for your reply it's working fine. It's great help me.

Thank you sooo much.

Member 10021658 29-Oct-14 6:35am View

Deleted

Dear George,

Thanks for your reply. I have already written a code in
if (chkTerms.Checked == true)
{
//login code
}
else
{
lblTerms.Text = "Please accept terms & conditions";
}

Now I have to try working with JQuery for alert message.

Note: I am beginner for .net, I followed with this example http://www.aspdotnet-suresh.com/2014/09/jquery-validation-for-terms-and-conditions-checkbox-checked-or-not.html#more

Thank you

Member 10021658 27-Oct-14 7:37am View

Dear Kumaran, Thanks your reply. According your answer is suitable for how to set paging in gridview. But my requirement is I have to pass the gridview row data values from BindGrid.aspx to Details.aspx page. Here I need to working with previous & next buttons not entire records only respective Id values (one record).

Member 10021658 27-Oct-14 4:41am View

Thank you Animesh. It's great help to me.

Member 10021658 27-Oct-14 3:36am View

Dear Animesh,

Thanks for your reply. But in my requirement the Details.aspx output is like,
Id:100, Name: Raju, College: Govt Engg College, City: Bangalore.

Now whenever click on previous I need display 99 Id records in same Details.aspx page, in the same next button I need to display 101 record.

Member 10021658 16-Sep-14 4:57am View

Thanks for reply. To bind the records from database to data bound controls.

Member 10021658 16-Sep-14 4:55am View

Thanks for all.

I have already used in frond end the following code,
replace(CONVERT(varchar, CAST(price as money),1), '.00','') as fee.

But I am try to asking about by chance is there any possible to directly change at database column like set to default value?

Already I got the output also in proper way.

Member 10021658 16-Sep-14 3:31am View

But I don't want to use these type of code I need to insert normal insert query only.

Member 10021658 16-Sep-14 3:30am View

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int i = GridView1.SelectedIndex;

string str = GridView1.Rows[i].Cells[1].Text;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Constring"].ConnectionString);
a.Open();

string strinsert = "insert into savetable(userid,productid,Quantity) values('" + Userid.Value + "','" + str+ "','" + 1 + "') ";

SqlCommand cmd = new SqlCommandstrinsert , con);
cmd.ExecuteNonQuery();
a.Close();
}

Member 10021658 16-Sep-14 2:49am View

Thanks for reply. Forget about login credentials, now how to save the row records using the login
email id?

Member 10021658 15-Sep-14 5:10am View

Thanks for your reply. Whenever try to insert a record from front end that time I have left the Email textbox. In that situation I need to insert the record at database default value. You are given that query it will work at after record is inserted only, but I need at time of insertion.

Once again thanks.

Member 10021658 12-Sep-14 8:17am View

But how to set before creating a table?

Member 10021658 12-Sep-14 7:54am View

Msg 207, Level 16, State 1, Line 1
Invalid column name 'amount_cal'.

I have create the price column datatype si int.

Member 10021658 12-Sep-14 7:15am View

Thanks for your reply. Actually I have a doubt about this format. Is there any control for that output or we can create the path dynamically for every page?

Member 10021658 11-Sep-14 3:26am View

But I have using these query update student set result='Pass' where result=''
Its working properly. But before I have tried to insert record using insert query constraint like CONS_DF_RESULT its not inserted default value, but using gui mode its working.

Member 10021658 11-Sep-14 3:05am View

datatype is varchar(50) and Allow Nulls is checked

Member 10021658 11-Sep-14 3:01am View

I think it is working on empty table only.

Member 10021658 11-Sep-14 2:59am View

(0 row(s) affected)

Member 10021658 11-Sep-14 2:55am View

Thanks for reply Griff. Whenever I have tried this one ALTER TABLE Student ALTER COLUMN Result SET DEFAULT 'Pass', I got the error message like Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'SET'.

Member 10021658 11-Sep-14 2:51am View

Thanks for reply Syed. The query is execute successfully, but its not updated for already existing records.

Member 10021658 10-Sep-14 4:53am View

Santhosh please help me.

Member 10021658 10-Sep-14 2:36am View

Thanks for your reply. Its working without errors, but the link show up to end of the column text
, I don't want to such type. I need Entire row where you are placed the mouse. Please checkout your side output properly.

Member 10021658 10-Sep-14 1:34am View

Thanks for your reply. Whenever replace all BoundFields of rest of columns, the link shows only the respcted column. But I need to entire row where you placed mouse in row at anywhere not only columns. Is there any possibility for without using TemplateFiled how can set the hyperlink.

Member 10021658 10-Sep-14 1:32am View

Thanks for your reply. I understand what you told, but whenever placed on empty spaces of the row its don't have link. Is there any possibility for without using TemplateFiled how can set the hyperlink.

Member 10021658 10-Sep-14 0:15am View

In place of "Select$", how can i use "~/StuDetails.aspx?Id="+DataBinder.Eval(Container.DataItem,"Id"). I have to navigate the entire row in next page only.

Member 10021658 9-Sep-14 8:38am View

Please please help me.

Member 10021658 9-Sep-14 8:38am View

Deleted

Please please help me.

Member 10021658 9-Sep-14 7:56am View

onmouseover i got the hand symbol.

cursor=pointer; but I didn't get the like for entire row. I got the link on SName only.

Member 10021658 9-Sep-14 7:52am View

Thanks for your reply. How to set this path like StuDetails.aspx?Id="+DataBinder.Eval(Container.DataItem,"Id"), because of I have to see the details in next page only in place of
e.Row.Attributes["onclick"] = this.Page.ClientScript.GetPostBackClientHyperlink(this.GridView1, "Select$" + e.Row.RowIndex);

Thanks in advance.

Member 10021658 9-Sep-14 7:48am View

Thanks for your reply. How to set this path like StuDetails.aspx?Id="+DataBinder.Eval(Container.DataItem,"Id"), because of I have to see the details in next page only in place of
e.Row.Attributes["onclick"] = this.Page.ClientScript.GetPostBackClientHyperlink(this.GridView1, "Select$" + e.Row.RowIndex);

Thanks in advance.

Member 10021658 9-Sep-14 7:29am View

Thanks for your reply. But I need to working with hyperlink only. And when ever place onmouseover
to display the cursor like hand symbol only not arrow.

Member 10021658 8-Sep-14 3:28am View

Thanks for your reply. I have 10 web forms like StudentRegistration, Signin, Logout, ViewRecords,
ChangePassword, ForgotPassword....ect. Please give me these type of website application, because of am fresher for dotnet.

Member 10021658 8-Sep-14 3:00am View

Thank you for your reply. Except fileuploadcontrol is there any control for uploading multiple images at a time. Even i don't know how to work with uploading multiple images using fileuploadcontrol also. Give the some links to me. And how to insert the record in at a time for two tables using single insert query.

Member 10021658 28-Aug-14 5:41am View

Thanks for your reply.

But I don't to display in listitems, whenever try to click the dropdownlist it will shows the fisrt value is 'C' only, like watermark.

Member 10021658 26-Aug-14 4:33am View

Thanks you response. I am sorry to say, i don't know to give the session. That's main problem.

Member 10021658 26-Aug-14 0:02am View

Good Morning ChauhanAjay,
Thanks for your response.
If you don't mind can you place the query?

Member 10021658 22-Aug-14 7:23am View

Thank your reply Yogesh.

In that example the user details send directly using mail, but my requirement is i have to send a link that user and that provid as UserId, UserName, Email also. now they can try to change their password.

Member 10021658 22-Aug-14 7:12am View

I don't got error on change password.

I got the error on whenever try to click the link that am unable to retrieve the user respective details using UserId?

Member 10021658 22-Aug-14 7:06am View

There is no row at position 0.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: There is no row at position 0.

Source Error:

Line 23: DataSet ds = new DataSet();
Line 24: sda.Fill(ds, "Registrion");
Line 25: lblId.Text = ds.Tables["Registrion"].Rows[0][0].ToString();
Line 26: da = new SqlDataAdapter(cmd);
Line 27: ds = new DataSet();

whenever try to click this link i got the error message.

the link is: http://localhost:1312/DemoExamples/Admin/ForgotPassword.aspx/3

Member 10021658 22-Aug-14 7:01am View

i have to display UserId, UserName, Email mandatory along with the link for respective user details.
And now i need to enter old password as well as new password also.

Member 10021658 7-Aug-14 8:07am View

hi friends,

am waiting for solution, please any one could help me.

Member 10021658 7-Aug-14 7:17am View

please any one help me.

Member 10021658 7-Aug-14 3:04am View

some times its working but some times not working. I don't no what is the reason. But when ever placed as label its not working.

Member 10021658 7-Aug-14 2:33am View

Thank your reply.

Its not align problem. Suppose the requireFieldValidator error message width as 100 characters. Now the regularexpression error message shows after 100characters. Now i need from starting point only not after 100characters.

Thanks in advance.

Comments by Member 10021658 (Top 54 by date)