Comments by $ultaNn (Top 62 by date)

i tried googling . couldn't get solution for Update panel removed

i am getting this error on replacing

The SqlParameter is already contained by another SqlParameterCollection.

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;
}

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);
}

}

The TreeView1 is empty to find to search . even the treeview is filled ..

ok, i have a user with all permissions , how should i enter in AD with that user and create new user

i have proxy server its giving me proxy ip not my machine IP

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.

i want to get only link of that image from sql .

Thank You

i want to rename the file on destination folder before saving

how can i create setup package ??? can u provide me a link please

It worked when remove date column..

Cheersss.,.......!!!!!

worked fine when removed date column from select statement..

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

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

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

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'.

what if frst fetch the data for between dates then sum of that data only ... ??? how can this be done ???

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

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

the query works but it cannot group by Qty_Device_ID
its repeating records

the query works but it cannot group by Qty_Device_ID
its repeating records

the query works but it cannot group by Qty_Device_ID
its repeating records

also i want inner join with Tbl_Device Table

Error

Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "d.Device_ID" could not be bound.

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'

yes i dont want database interference . just need to edit row on client side ...

i used webservice and auto complete
still its aking time to search/...

@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.

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 .

Thank You Mishra
It works fine with my requirement.

yes Sql db table ,

when i load page i want the last saved ID from Sql Db tble in text box .

i checked i am getting this error
Invalid object name 'sysPeram'.
in c#code.

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();

i am using 2008R2

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

i am getting this error The specified string is not in the form required for an e-mail address.
near SmtpClient serverobj = new SmtpClient();

users will change every time , so i have to change the user when the shift changes,

Thanks it work fine...

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

Error : Incorrect syntax near select statement

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();
}

i changed it to 9999 its working fine thank you.

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.

The Error Showed again. :(

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 ???

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

how?

i Did make it -1 it work fine for some times then again it is showing me this error,.,.

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

i want to use data table instead of dataset

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

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?)

i want to show the data frst then print with button click event