Click here to Skip to main content
15,396,239 members

Comments by $ultaNn (Top 60 by date)

$ultaNn 23-Dec-21 4:51am View
   
yes the problems if for hijri dates calculation
$ultaNn 16-Apr-20 14:51pm View
   
try catch removed
$ultaNn 27-Mar-20 9:02am View
   
Invalid column name 'PayDescr'.
Invalid column name 'PayMonAmt '.
$ultaNn 21-Sep-17 2:15am View
   
i tried googling . couldn't get solution for Update panel removed
$ultaNn 26-Apr-17 1:17am View
   
i am getting this error on replacing

The SqlParameter is already contained by another SqlParameterCollection.
$ultaNn 7-Apr-16 7:20am View
   
with below code i am trying to check the checkboxlist
but instead of selecting item checkbox list is repeating.

foreach (DataRow rw in dt.Rows)
{
string Aclst = rw[1].ToString();
if (chlst == Aclst)
{
item.Selected = true;
}
$ultaNn 1-Sep-15 4:58am View
   
The TreeView1 is empty, by this code i have filled treeview from active directory , but i cannot search from tree view..


DirectoryEntry directoryObject = createDirectoryEntry();

//Searcher.Filter = ("(objectClass=organizationalUnit)");
foreach (DirectoryEntry firstChild in directoryObject.Children)
{
if (firstChild.Name.Contains("OU"))
{
TreeNode Node = new TreeNode(firstChild.Name.Remove(0, 3));
TreeView1.Nodes.Add(Node);
}

}
$ultaNn 1-Sep-15 4:25am View
   
The TreeView1 is empty to find to search . even the treeview is filled ..
$ultaNn 28-Jun-15 3:58am View
   
ok, i have a user with all permissions , how should i enter in AD with that user and create new user
$ultaNn 14-Aug-14 2:43am View
   
i have proxy server its giving me proxy ip not my machine IP
$ultaNn 20-Jan-14 4:17am View
   
i can convert gridview to pdf . i want to send that pdf in email i am getting error

The remote certificate is invalid according to the validation procedure.
$ultaNn 8-Dec-13 3:04am View
   
i want to get only link of that image from sql .
$ultaNn 28-Oct-13 6:21am View
   
Thank You
$ultaNn 24-Oct-13 7:05am View
   
i want to rename the file on destination folder before saving
$ultaNn 3-Oct-13 6:21am View
   
how can i create setup package ??? can u provide me a link please
$ultaNn 23-Jul-13 8:32am View
   
It worked when remove date column..
$ultaNn 23-Jul-13 8:32am View
   
Cheersss.,.......!!!!!

worked fine when removed date column from select statement..
$ultaNn 23-Jul-13 8:18am View
   
Dear Maciej Los the query failed . if i change the date then execute still its getting sum of whole record instead of getting sum so specific date records
$ultaNn 23-Jul-13 8:18am View
   
Dear ArunRajendra the query failed . if i change the date then execute still its getting sum of whole record instead of getting sum so specific date records
$ultaNn 23-Jul-13 8:17am View
   
Dear Vinay the query failed . if i change the date then execute still its getting sum of whole record instead of getting sum so specific date records
$ultaNn 23-Jul-13 8:12am View
   
Msg 207, Level 16, State 1, Line 3
Invalid column name 'Qty_Device_ID'.
Msg 209, Level 16, State 1, Line 4
Ambiguous column name 'Qty_Date'.
Msg 209, Level 16, State 1, Line 4
Ambiguous column name 'Qty_Date'.
$ultaNn 23-Jul-13 7:57am View
   
what if frst fetch the data for between dates then sum of that data only ... ??? how can this be done ???
$ultaNn 23-Jul-13 7:54am View
   
i need only like this

Device_Name Qty_Device_ID Qty_User Qty_Date SubTotal
HP Printer 100 Label 2013-07-21 11:40:31.667 450
HP LaserJet 101 Label 2013-07-21 11:40:40.027 450
KeyBoard 102 Label 2013-07-21 11:40:42.153 350
Dell Mouse 103 Label 2013-07-21 11:40:44.250 150
$ultaNn 23-Jul-13 7:54am View
   
i am getting output like this
Device_Name Qty_Device_ID Qty_User Qty_Date SubTotal
HP Printer 100 Label 2013-07-21 11:40:31.667 450
HP LaserJet 101 Label 2013-07-21 11:40:40.027 450
KeyBoard 102 Label 2013-07-21 11:40:42.153 350
Dell Mouse 103 Label 2013-07-21 11:40:44.250 150
HP Printer 100 Label 2013-07-21 11:41:24.663 450
HP LaserJet 101 Label 2013-07-21 11:41:27.247 450
KeyBoard 102 Label 2013-07-21 11:41:29.620 350
HP Printer 100 Label 2013-07-22 14:28:10.257 450
HP LaserJet 101 Label 2013-07-22 14:28:13.620 450
$ultaNn 23-Jul-13 7:47am View
   
the query works but it cannot group by Qty_Device_ID
its repeating records
$ultaNn 23-Jul-13 7:38am View
   
the query works but it cannot group by Qty_Device_ID
its repeating records
$ultaNn 23-Jul-13 7:38am View
   
the query works but it cannot group by Qty_Device_ID
its repeating records
$ultaNn 23-Jul-13 7:26am View
   
also i want inner join with Tbl_Device Table
$ultaNn 23-Jul-13 7:23am View
   
Error

Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "d.Device_ID" could not be bound.
$ultaNn 23-Jul-13 7:22am View
   
i got error

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near 'temp1'
$ultaNn 4-Jul-13 3:54am View
   
yes i dont want database interference . just need to edit row on client side ...
$ultaNn 9-Jun-13 11:50am View
   
i used webservice and auto complete
still its aking time to search/...
$ultaNn 3-Jun-13 8:45am View
   
@Savalia : i have data in CPU table , i have cpu id C-101 and so on , monitor ID M-101 and so on .. in the tables ..

i am trying to save ID's in Order_Request from different tables.
$ultaNn 3-Jun-13 8:41am View
   
I am trying enter monitor ID in Order_Request at once ,
i can select cpu list, monitor list , printer list from a dropdown . where i can only select one item from one table . when i select one model its giving me error .
$ultaNn 25-May-13 7:13am View
   
Thank You Mishra
It works fine with my requirement.
$ultaNn 25-May-13 3:19am View
   
yes Sql db table ,

when i load page i want the last saved ID from Sql Db tble in text box .
$ultaNn 22-May-13 1:37am View
   
i checked i am getting this error
Invalid object name 'sysPeram'.
in c#code.
$ultaNn 21-May-13 7:40am View
   
I am getting this error
Procedure or function 'pro_Monitor' expects parameter '@Monitor_ID', which was not supplied.


con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "pro_Monitor";
cmd.Parameters.AddWithValue("@Monitor_Name", TextBox1.Text);
cmd.Parameters.AddWithValue("Qty_Received", Quantity.Text);
cmd.Parameters.AddWithValue("@Monitor_O_N", DropDownList1.Text);
cmd.Parameters.AddWithValue("@Monitor_user", Label1.Text = Session["l_name"].ToString());
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
$ultaNn 21-May-13 6:33am View
   
i am using 2008R2
$ultaNn 21-May-13 6:31am View
   
i have to insert monitors one by one in back end P101 P102 and so on should save in db table with every insertion on new monitor.
Ex : If i enter Name: Dell Model: Inspiron Quantity :100 then in Monitor ID it should save P101 when i enter second model It should save P102
$ultaNn 30-Mar-13 3:28am View
   
i am getting this error The specified string is not in the form required for an e-mail address.
near SmtpClient serverobj = new SmtpClient();
$ultaNn 14-Mar-13 13:01pm View
   
users will change every time , so i have to change the user when the shift changes,
$ultaNn 10-Mar-13 3:15am View
   
Thanks it work fine...
$ultaNn 27-Feb-13 4:07am View
   
ALTER PROCEDURE [dbo].[Tech_sup]

(


@Build_name varchar(max),
@Dept varchar(max),
@P_type varchar (50),
@id int output



)
AS
BEGIN

set @id = 0
INSERT INTO dbo.Tech_data (Build_name,Dept,P_type)
values (@Build_name,@Dept,@P_type)
set @id = Scope_identity()

END
$ultaNn 25-Feb-13 6:01am View
   
Error : Incorrect syntax near select statement
$ultaNn 25-Feb-13 5:52am View
   
Deleted
tried this worked fine . thnk you all


DateTime datetime = Convert.ToDateTime(Date.Text);
SqlCommand cmnd = new SqlCommand("SELECT * FROM Tech_data where Call_assign= @Call_assign and dateadd(dd, datediff(dd,0, [date_time]), 0) = @date_time ");
cmnd.Connection = con;
cmnd.Parameters.Add("@Call_assign", SqlDbType.VarChar).Value = Label1.Text;
cmnd.Parameters.Add("@date_time", SqlDbType.DateTime).Value = datetime.Date;
SqlDataAdapter da = new SqlDataAdapter(cmnd);
DataSet ds = new DataSet();
da.Fill(ds);
$ultaNn 25-Feb-13 0:34am View
   
this code is working perfectly in another page y??

protected void Button1_Click(object sender, EventArgs e)
{
DateTime date = Convert.ToDateTime(TextBox1.Text);
SqlCommand cmd = new SqlCommand("SELECT * FROM Tech_data where Call_assign = @Call_assign and dateadd(dd, datediff(dd,0, [date_time]), 0) = @date_time ");

cmd.Connection = con;
cmd.Parameters.Add("@Call_assign", SqlDbType.VarChar).Value = DropDownList1.SelectedValue;
cmd.Parameters.Add("@date_time", SqlDbType.DateTime).Value = date.Date;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
Tech_grid.DataSource = ds;
Tech_grid.DataBind();
}
$ultaNn 19-Feb-13 4:53am View
   
i changed it to 9999 its working fine thank you.
$ultaNn 16-Feb-13 6:25am View
   
after 5 to 8 prints its giving this error..

how should i fix the limits every day ?
and the website is deployed user need to print every report . this -1 is not working.
$ultaNn 16-Feb-13 5:15am View
   
The Error Showed again. :(
$ultaNn 16-Feb-13 5:13am View
   
Deleted
The error come again. :(
$ultaNn 16-Feb-13 2:54am View
   
yes i had edited this file yesterday and after some prints it was giving me this error . and today its not giving me the error ..

i have to restart my PC after editing ???
$ultaNn 16-Feb-13 2:47am View
   
is this the right path to edit ???
HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer\PrintJobLimit
$ultaNn 16-Feb-13 2:44am View
   
how?
$ultaNn 16-Feb-13 2:40am View
   
i Did make it -1 it work fine for some times then again it is showing me this error,.,.
$ultaNn 16-Feb-13 1:01am View
   
I try to find the path to edit the registry key , i find this path and edited PrintJobLimit to -1 from 75 but still after some prints its giving me this error ,.,.

HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer\PrintJobLimit
$ultaNn 29-Jan-13 7:14am View
   
i want to use data table instead of dataset
$ultaNn 23-Jan-13 4:04am View
   
protected void Print(object sender, EventArgs e)
{
CrystalReport objReport1 = new CrystalReport();
CrystalReportViewer1.ReportSource = objReport1;

}

The type or namespace name 'CrystalReport' could not be found (are you missing a using directive or an assembly reference?) C:\inetpub\wwwroot\Mreport\crystal.aspx.cs
$ultaNn 23-Jan-13 1:08am View
   
its giving me this error on crystalreport1
The type or namespace name 'CrystalReport1' could not be found (are you missing a using directive or an assembly reference?)
$ultaNn 22-Jan-13 6:44am View
   
i want to show the data frst then print with button click event