Click here to Skip to main content
14,865,773 members

Comments by krishna97 (Top 143 by date)

krishna97 28-Apr-15 8:50am View
   
out put will given wrong
out put be can this format...

ID STATUS TIME
1 IN
2 OUT
3 OUT
krishna97 28-Apr-15 7:47am View
   
yes time and date also
krishna97 24-Apr-15 7:11am View
   
min and max value can both
krishna97 13-Mar-15 6:53am View
   
check link
krishna97 13-Mar-15 6:53am View
   
http://www.c-sharpcorner.com/UploadFile/akkiraju/url-rewriting-in-Asp-Net/
krishna97 24-Feb-15 5:02am View
   
error given
Data type used text

this error can given
===========================
SELECT
REPLACE(REPLACE(ProductInfo, '<p>', '') , '</p>', '') from tbl_ProductInfo

my matter :
==
<p> From farmhouse to industrial chic, from the urban loft all the way out to the lodge, we have all rustic looks covered in floor lamps styles. If your style leans towards the naturalist looks check out the iron metal twigs or curling wood vine floor lamps. However, if you&#39;re feeling a little bit country or maybe even French provincial, don&#39;t miss our shabby vintage chic and pickled wood choices in floor lamps, often with matching table lamps. And if you&#39;re into mountain cabin chic, our oversized real antler or bronze modern craftsman floor lamps are great choices. Or how about an industrial pipe or safari animal floor lamp? We also have adjustable reading floor lamps. We hope you enjoy browsing our selection!</p>
krishna97 24-Feb-15 4:58am View
   
ok thanks
krishna97 24-Feb-15 4:47am View
   
end tag can not replace

From farmhouse to industrial chic, from the urban loft all the way out selection!</p>
krishna97 17-Feb-15 23:37pm View
   
your language explain it
krishna97 27-Jan-15 4:21am View
   
ddlCountry.Items.Count > 1
then given validation Please Select the value..!!1
krishna97 19-Jan-15 6:59am View
   
proper ur own word given answare
krishna97 16-Jan-15 2:31am View
   
<asp:Label ID="lbl" runat="server" CssClass="cssLabel">
krishna97 9-Jan-15 4:54am View
   
how can used this query from sql server
krishna97 9-Jan-15 0:57am View
   
yes
krishna97 9-Jan-15 0:28am View
   
I am Create Calander event can access from database table
krishna97 9-Jan-15 0:26am View
   
how can access event from database table
EventId,Eventname ,Eventdate
krishna97 3-Jan-15 6:06am View
   
not given out put

declare @IssueDate datetime,@ReturnDate datetime,@Curr datetime

set @IssueDate='2014-12-25 00:00:00.000'
Set @ReturnDate='2015-01-01 00:00:00.000'
Set @Curr=GETDATE()

--2 day Extra can fine given
SELECT DATEDIFF(d, @ReturnDate, @Curr) * 10 as Fine from tbl_LibraryBookIssue
WHERE DATEDIFF(d, @IssueDate,@ReturnDate) > 7
--select * from tbl_LibryMemberCategory
krishna97 3-Jan-15 5:16am View
   
how can calculate library Book return fine
krishna97 2-Jan-15 6:16am View
   
out put can not given for this query
krishna97 2-Jan-15 6:11am View
   
find out day and multiply by this table select FineLimt from tbl_LibryMemberCategory
krishna97 2-Jan-15 6:10am View
   
SELECT DATEDIFF(day, GETDATE(), ReturnDate)*(select FineLimt from tbl_LibryMemberCategory)

from tbl_LibraryBookIssue

this query used
krishna97 23-Dec-14 0:16am View
   
ID Stuname abc xyz abc1
1 kkp yes Null Null
2 kkp1 null null null

krishna97 19-Dec-14 3:34am View
   
Prisent,Abset can show date wise
krishna97 15-Nov-14 3:29am View
   
create setup file then install setup automatically connect and working in windows application
krishna97 15-Nov-14 2:14am View
   
create for windows based not for web based
krishna97 14-Nov-14 23:27pm View
   
how can install the setup file then how can connect to sql database from another system
krishna97 12-Nov-14 1:30am View
   
Create Setup and Insert the value then this error given
"SQL ERROR CANNOT OPEN DATABASE "DATABASENAME" REQUESTED BY THE LOGIN"
krishna97 14-Oct-14 6:39am View
   
how can work in weekday
krishna97 14-Oct-14 6:39am View
   
given sql query
krishna97 11-Oct-14 1:10am View
   
how can date wise record insert into sql server
krishna97 11-Oct-14 1:10am View
   
how can date wise record insert into sql server
krishna97 2-Sep-14 3:32am View
   
browser cookies and history can delete from Windows desktop application through
krishna97 2-Aug-14 2:21am View
   
software expiration then system can not work only show message
krishna97 2-Aug-14 2:09am View
   
how can create Software set the date then system can not work and expiry date then system can not open only show message only this is possible r not
krishna97 2-Aug-14 2:07am View
   
how can create Software set the date then system can not work and expiry date then system can not open only show message only this is possible r not
krishna97 25-Apr-14 4:55am View
   
local database can working then database can online then this error given

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
krishna97 24-Apr-14 8:11am View
   
this error given

online working then this error will given
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
krishna97 23-Apr-14 3:03am View
   
my Question This one
insert into Voterinfore(CustID,DID,SID)
select CustID from CustomerVoterInfo
Only one column data can copy from another table and DID and SID column can insert not copy data can insert
krishna97 2-Apr-14 8:00am View
   
Value Can Access From Data base table..??
krishna97 21-Mar-14 2:27am View
   
not use WCF code can used only C# code not in aspx page can used
krishna97 18-Feb-14 21:24pm View
   
My question is How to Print data from a Panel Control using windows Form C#
and your answer is Take the Path from drive then print...??

Button Click Show the data from Panal Control and Print Button Click to Panel data all can Print it
krishna97 18-Feb-14 10:41am View
   
Link Will Given Error Not working ..??
krishna97 31-Jan-14 2:03am View
   
User Profile can Show Transaction Details Payment Pending or Successfully show in User Profiles
krishna97 20-Jan-14 22:45pm View
   
<asp:GridView ID="gradevents" runat="server" CssClass="gridview" DataKeyNames="CityId" AutoGenerateColumns="False" Width="100%" AllowPaging="True">
<alternatingrowstyle cssclass="gridview_alter">
<columns>
<asp:TemplateField HeaderText="Select">
<itemtemplate>
<asp:CheckBox ID="chkDel" runat="server" />


<asp:TemplateField HeaderText="S.NO.">
<itemtemplate>
<%#Container.DataItemIndex+1 %>



<asp:TemplateField Visible="false">
<itemtemplate>
<asp:Label ID="lblid" runat="server" Text='<%#Eval("CityId") %>'>
</label>



<asp:TemplateField HeaderText="City Name">
<itemtemplate>
<label>
<%#Eval("CityName") %>
</label>


<edititemtemplate>
<asp:TextBox ID="txtcityname" runat="server" Text='<%#Eval("CityName") %>'>





<asp:TemplateField HeaderText="Status">
<itemtemplate>
<asp:Label ID="lblstat" runat="server" Text='<%#Eval("Status") %>' >



<edititemtemplate>
<asp:DropDownList ID="Dllstatus" runat="server">
<asp:ListItem Value="1">Active
<asp:ListItem Value="2">UnActive




<asp:CommandField HeaderText="Process" ShowDeleteButton="false" ShowEditButton="True" />



<PagerStyle CssClass="gridview_pager"></PagerStyle>

krishna97 20-Jan-14 22:38pm View
   
This code not working color not change
krishna97 20-Jan-14 22:38pm View
   
This code not working
krishna97 23-Dec-13 7:23am View
   
ok
krishna97 23-Dec-13 5:47am View
   
i am try but not given proper example given...??
krishna97 23-Dec-13 5:42am View
   
how can send Message from Domain mail Id
Mail can send from POP3 not used SMTP server
krishna97 23-Dec-13 5:33am View
   
given coding
message send from pop3
krishna97 3-Dec-13 7:43am View
   
but my own table create and used not used for sql server table..???
krishna97 3-Dec-13 7:38am View
   
ya

given coding..???
krishna97 3-Dec-13 7:28am View
   
Edit Button,Delete Button,Update Button
Can Enable/Disable Role Base Given Permission to enable/disable process to check which user given permission enable button and disable button

to different pages given permission
krishna97 26-Nov-13 4:34am View
   
not given any code for google ....??
krishna97 26-Nov-13 4:14am View
   
why
krishna97 23-Nov-13 6:39am View
   
private bool RecordExists(string ItemName, string weightgm, string Weightmg, string Purity, string groupName)
{
string connect1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\BSTJewellers.accdb";
olcon = new OleDbConnection(connect1);
OleDbCommand cmd = new OleDbCommand();

//query for duplicate
cmd.CommandText = "select count(*) from StoreManagement where ItemName = @ItemName and groupName=@groupName and weightgm = @weightgm and Weightmg = @Weightmg and Purity=@Purity";
cmd.Parameters.AddWithValue("@ItemName", txtItemname.Text);
cmd.Parameters.AddWithValue("@groupName", cmbgrpname.Text);
cmd.Parameters.AddWithValue("@weightgm", txtweightgm.Text);
cmd.Parameters.AddWithValue("@Weightmg", txtweghtmg.Text);
cmd.Parameters.AddWithValue("@Purity", txtpurity.Text);

//cmd.CommandText = "select count(*) from StoreManagement where ItemName = '"+txtItemname.Text+"' and groupName='"+cmbgrpname.Text+"' and weightgm ='"+ txtweightgm.Text+"' and Weightmg ='"+ txtweghtmg.Text+"' and Purity='"+ txtpurity.Text+"'";


olcon.Open();

int recordCount = Convert.ToInt32(cmd.ExecuteScalar());
//cmd.ExecuteScalar();
olcon.Close();

return recordCount > 0;
//if (recordCount > 0)
//{
// MessageBox.Show("duplicate value insert");
//}
}

but error given it..??
krishna97 31-Oct-13 2:33am View
   
ok i am try it
krishna97 31-Oct-13 2:00am View
   
query given for my question sir pleas
krishna97 30-Oct-13 14:57pm View
   
no any error given

but my question is
USE [ddrr]
GO

/****** Object: Table [dbo].[Temp] Script Date: 10/31/2013 00:22:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Temp](
[Id] [int] IDENTITY(1,1) NOT NULL,
[StartDte] [date] NULL,
[Enddate] [date] NULL,
[Statu] [nvarchar](50) NULL,
CONSTRAINT [PK_ssse] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


1- Insert query First time data can insert then second data insert then check the Status Column Inactive or Active Status Column can Inactive then Second Data can insert
2- Status Column can Update Automatically for endate can less then getdate
krishna97 30-Oct-13 14:50pm View
   
This query Not given Proper Out Put
krishna97 30-Oct-13 13:18pm View
   
This Query not Proper Out Put given
krishna97 30-Oct-13 13:17pm View
   
this query not proper work ...???
krishna97 30-Oct-13 12:08pm View
   
This Query not Proper Work
Status Column Not Update automatically End Date is Less then Current Date Only one data can insert then end date is less then current not update...??
krishna97 30-Oct-13 3:10am View
   
DECLARE @previousstatus nvarchar(50)
DECLARE @presentstatus nvarchar(50)

Select @previousstatus = statu FROM ssse where ID = (Select max(id) From ssse)

IF '2013-10-29' < cast(getdate() as date)
set @presentstatus = 'Inactive'

IF @previousstatus = 'Inactive'
BEGIN
Insert INTO ssse(StartDte,Enddate,Statu) VALUES('2014-09-09','2014-09-08','Active')
END

Used this One also but not Update Status Column
krishna97 30-Oct-13 2:55am View
   
DECLARE @previousstatus nvarchar(50)
DECLARE @presentstatus nvarchar(50)

Select @previousstatus = statu FROM ssse where ID = (Select max(id) From ssse)

IF '2014-08-08' < cast(getdate() as date)
--@presentstatus = 'Inactive'

IF @previousstatus = 'Inactive'
BEGIN
Insert INTO ssse(StartDte,Enddate,Statu) VALUES('2014-09-09','2014-09-08','Active')
END

I am used this One But not Update the Previous Record Status Column 'Inactive'
krishna97 30-Oct-13 2:49am View
   
this code also given error
Incorrect syntax near '@presentstatus'
krishna97 30-Oct-13 2:44am View
   
but remove this line then status Column not update automatically
krishna97 30-Oct-13 2:33am View
   
then do not used

@presentstatus = 'Inactive' error given
krishna97 30-Oct-13 1:07am View
   
DECLARE @previousstatus nvarchar(50)
DECLARE @presentstatus nvarchar(50)

Select @previousstatus = statu FROM ssse where ID = (Select max(id) From ssse)

IF Enddateparameter < cast(getdate() as date) then @presentstatus = 'Inactive'

IF @previousstatus = 'Inactive'
BEGIN
Insert INTO ssse(startdate,enddate,status) VALUES(startdateparameter,enddateparameter,@presentstatus)
END


error given
"Incorrect syntax near the keyword 'then'."
krishna97 30-Oct-13 0:57am View
   
if '2013-08-08'< CAST(getdate() as enddate)
then
error given "Incorrect syntax near the keyword 'then'."
krishna97 29-Oct-13 22:38pm View
   
Run from Offline and Online
krishna97 29-Oct-13 22:37pm View
   
windows application
krishna97 24-Oct-13 2:50am View
   
decimal format
krishna97 24-Oct-13 2:46am View
   
droup downlist bind

DataTable dtf = new DataTable();
dt = SelectData();
DataView dv = dt.DefaultView;
dv.RowFilter = "Category='" + s + "'";
if (dv.Count > 0)
{
DataTable ddd = new DataTable();
ddd = dv.Table;
ddlexp.DataTextField = "Planname";
ddlexp.DataValueField = "Amount";
ddlexp.DataSource = dv.Table;
ddlexp.DataBind();
}
krishna97 17-Oct-13 3:29am View
   
Asking for Coding for Roles & Permissions Users And Employess like that(Edit,update,delete)
krishna97 17-Oct-13 3:26am View
   
Roles & Permissions from users and Employees
krishna97 17-Oct-13 3:25am View
   
thatraja given this link not proper given code
krishna97 17-Oct-13 3:13am View
   
Admin Given Permission for Users (Like that Edit,Update,Delete)
krishna97 16-Oct-13 8:39am View
   
Create table (name,Add,Startdate,endate,Status)
how to update status colum for processer through Active and Unactive
endate>getdate() according
krishna97 16-Oct-13 8:36am View
   
how to used online date in storeprocesser
krishna97 16-Oct-13 8:22am View
   
I have table there is a status column when status is active then data not inserted otherwise insert. status depend on end date if enddate is smaller than the today date then automatically status become unactive and data will be inserted
krishna97 16-Oct-13 6:26am View
   
Status is Unactive then Insert value
krishna97 16-Oct-13 6:01am View
   
i am using single table
krishna97 16-Oct-13 5:54am View
   
single table
krishna97 16-Oct-13 5:51am View
   
ya then Status Colum Can Update Automatic Unactive
krishna97 16-Oct-13 5:48am View
   
only one single table not for multipal table
krishna97 16-Oct-13 5:46am View
   
and Status Will Update Automatic Is Unactive
krishna97 16-Oct-13 5:46am View
   
not grater then start date grater then system current date
krishna97 16-Oct-13 5:38am View
   
I am Asking
Column name ("Name,Address,Startdate,enddate,Status default value='Active')
I am Asking Enddate Can Grater then Current Date then Status Colum Automatic Update status='UnActive' in SQL server
krishna97 14-Oct-13 1:35am View
   
End Date can grater then current date then status colum can update is Show in UnActive
krishna97 14-Oct-13 1:34am View
   
End Date can grater then current date then status colum can update is Show in UnActive
krishna97 14-Oct-13 1:34am View
   
End Date can grater then current date then status colum can update is Show in UnActive
krishna97 14-Oct-13 1:32am View
   
End Date can grater then current date then status colum can update is Show in UnActive
krishna97 13-Oct-13 1:30am View
   
Single Table Can Use then
But this error given

Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 50: MenuItem mnu = new MenuItem(dr["MenuName"].ToString(), dr["MenuId"].ToString(),
Line 51: "", dr["LocationUrl"].ToString());
Line 52: menuBar.FindItem(dr["ParentId"].ToString()).ChildItems.Add(mnu);
Line 53: }
Line 54: con.Close();
krishna97 13-Oct-13 1:23am View
   
I am Singele Table can Also Use but Given Error ......:???
krishna97 13-Oct-13 1:22am View
   
ok try it now
krishna97 13-Oct-13 1:03am View
   
This Code only given
Menu and SubMenu Not given Submenu Child
krishna97 13-Oct-13 1:02am View
   
Menu Like this one
MainMenu
Home Student Teacher (Submenu Of Teacher)-->Add Student
|-->Show Record and (SubMenu Child in Show Record)
|---->More Ino
|----->Otrher
This format

krishna97 13-Oct-13 0:24am View
   
Teacher-->Student
|
--->Staff
|
---Other
This Formate Out Put not given in this Code
krishna97 13-Oct-13 0:17am View
   
How Can Used Then Given Example
krishna97 12-Oct-13 23:58pm View
   
How Can Create MainMenu and Submenu--->SubmenuChild
krishna97 12-Oct-13 23:57pm View
   
Out Put given For Home--->Subhome

But MyProblem given
Home-->subhome-->SubHome
krishna97 12-Oct-13 10:58am View
   
Tree Formate Given Menu and Subment Create
krishna97 20-Sep-13 21:01pm View
   
But Given the Error solve this error
krishna97 20-Sep-13 21:01pm View
   
MailMessage objmsg = new MailMessage();
try
{
if (Txt_email.Text.Trim() != "")
{
StringBuilder strmsg = new StringBuilder();
objmsg.To.Add("contact@domain.com");
objmsg.From = new MailAddress(Txt_email.Text);


strmsg.Append("Email Id: " + Txt_email.Text + "<br/><br/>Name: " + Txt_name.Text + "<br/><br/>Phone Number: " + Txt_Phone.Text + "<br/><br/>comment: " + Txt_comm.Text + "<br/><br/>");

strmsg.Append("<br/><br/>" + Txt_email.Text + "<br/><br/>");
objmsg.Body = strmsg.ToString();
objmsg.IsBodyHtml = true;
objmsg.Priority = MailPriority.Normal;
SmtpClient objsmtp = new SmtpClient("email.domain-view.com");
objsmtp.Send(objmsg);
//MsgBox.MessageBox.Show("Mail delivereds successfully!!!!!!");
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('Enquery Send Succesfully');</script>");

//clear();
}
//Response.Redirect("contact.aspx");
}
catch (ApplicationException ex)
{
throw new ApplicationException(ex.Message);

}
krishna97 20-Sep-13 8:44am View
   
given coding in c#
krishna97 20-Sep-13 8:22am View
   
how can send message for domain id
krishna97 17-Sep-13 7:40am View
   
ok thank sir given the advice then sir i am do it now confident i am do it
krishna97 17-Sep-13 7:33am View
   
given the function code
krishna97 17-Sep-13 7:33am View
   
this is function name PERSISTED
krishna97 13-Sep-13 10:35am View
   
Project Can Upload Server then error given
krishna97 7-Sep-13 10:40am View
   
how to upload Video from database all format like thake (.flv etc)
krishna97 7-Sep-13 10:24am View
   
but sir/Madam this error will come from upload the project in server then this error given,,,,??
krishna97 7-Sep-13 5:18am View
   
only find Month
(01/09/2013) or (01/10/2013)
out put given 1 month return
krishna97 5-Sep-13 1:07am View
   
Error Not Solve Same Error Given ..Plz Help Me,,,...??
krishna97 21-Aug-13 0:02am View
   
How can create Dynamic Menu and Submenu and Role Also Define in Asp.net C#
krishna97 17-Aug-13 3:08am View
   
i am not proper understand ur query sir plz sir problem example given in my my

Delete from CustSelling,CustSellingItems using CustSelling inner join CustSellingItems inner join sellpayment where CustSelling.SerialNO=CustSellingItems.SerialNO and CustSellingItems.SerialNO=sellpayment.SerialNO ='" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "'";
krishna97 17-Aug-13 2:57am View
   
cmd.CommandText = "Delete from CustSelling,CustSellingItems using CustSelling inner join CustSellingItems inner join sellpayment where CustSelling.SerialNO=CustSellingItems.SerialNO and CustSellingItems.SerialNO=sellpayment.SerialNO ='" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "'";
krishna97 12-Aug-13 1:04am View
   
not for web
windows application using datagridview export to Excel
krishna97 5-Aug-13 8:53am View
   
Also not solve these for............??
krishna97 5-Aug-13 8:26am View
   
This error for crystal report run time error

Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI...
krishna97 5-Aug-13 8:25am View
   
I am Developed Windows Application
crystal report given error for run time

Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI...
krishna97 4-Aug-13 12:10pm View
   
i am used this code also but same error given
krishna97 4-Aug-13 10:25am View
   
same error
krishna97 4-Aug-13 10:24am View
   
ok i am check...
krishna97 4-Aug-13 10:02am View
   
ok this code
con.Open();
OleDbCommand cmd = new OleDbCommand("Select * from kkp", con);
OleDbDataAdapter sdt = new OleDbDataAdapter(cmd);
DataTable ds = new DataTable();
sdt.Fill(ds);
CrystalReport2 crp = new CrystalReport2();
crp.SetDataSource(ds);
crystalReportViewer1.ReportSource = crp;
crystalReportViewer1.Refresh();
con.Close();
krishna97 4-Aug-13 9:35am View
   
yes sir
this error given run time
krishna97 30-Jul-13 4:07am View
   
not given any proper coding...........:)
i no google friend...........
krishna97 27-Jul-13 6:32am View
   
sir this code only colum wise but i am click the button data insert in row wise
krishna97 27-Jul-13 6:30am View
   
sir how can fill row wise value in button clik event in show in listview in c#
krishna97 25-Jul-13 4:40am View
   
problem given in role base sir u can help me r not....??
krishna97 25-Jul-13 4:38am View
   
create the login page in window application with user can login role based and coding c# and oledb
krishna97 25-Jul-13 4:21am View
   
C# Login Page Windows Form Application - OleDbException with Role Base User Can Login
krishna97 23-Jul-13 3:21am View
   
vb.Net with c# Coding
krishna97 22-Jul-13 7:36am View
   
ok sir thanks........... for help me..
krishna97 22-Jul-13 6:37am View
   
sir your answer i am not proper satisfy given proper example...??
krishna97 22-Jul-13 5:47am View
   
ok
krishna97 22-Jul-13 5:19am View
   
My code not a proper way ,,,,,??
sir you can post me for MVC code and C# and databse design plz sir ....??
krishna97 22-Jul-13 5:06am View
   
ya..sir Dynamic Menu And Submenu for MVC4
krishna97 22-Jul-13 5:06am View
   
example and coding
krishna97 22-Jul-13 5:06am View
   
Deleted
ya..sir Dynamic Menu And Submenu for MVC4