|
Solved by using the correct user in sql server logins.
Thanks
|
|
|
|
|
hi
i am using table {page-break-after:always} in printing HTML page and it is working fine
but when i export the same report to word and print the word document the page break is not working.
Any ideas or is there another work around so if i have multiple reports to print each new report on new page
example
report1 on pages 1,2,3
report2 starts on page 4 and so on
|
|
|
|
|
Hello,
I have placed the web project (built in vs2008) into the DEV web server for testing...
virtual directory is also created.
After checking the asp.net version on the web server it seems only the version 2.0 is available and so when I browse to the site i.e. http://servername/site
then I get this error below. Should I put something in the web.config file to solve this issue?
It seems the error is to do with the reportviewer control I am using.
NOTE that the ERROR is on line 117
Any thoughts please?
Thanks
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Source Error:
Line 115: <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
Line 116: <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
Line 117: <add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
Line 118: <add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
Line 119: </assemblies>
|
|
|
|
|
This seems to be to do with installing the reportviewer into the Dev web server.
How do I do this because these dlls are present in my local machine where I have developed this web project in C:\Program Files\Microsoft Visual Studio 9.0\ReportViewer
whereas in the webserver I only see :
\\DevWebServer\c$\Program Files\Microsoft visual studio 8
\\DevWebServer\c$\Program Files\Microsoft visual studio .NET
\\DevWebServer\c$\Program Files\Microsoft .NET
to which folder do I copy the dlls to?
Thanks
|
|
|
|
|
This is now solved by copying the dlls into the bin directory of the project.
Thank you
|
|
|
|
|
Cool Cheers!!
Brij
|
|
|
|
|
MY opinion is 4
I want to check whether particular value for a column exists before inserting , for that i want to ask which one is recommended ?
1) Set the unique constraint in table field, and in data access layer throw error catch it in presentation layer , and check whether error number is 2626 and display duplicate message.
OR I Use
2)In store procedure use EXISTS before inserting and if their is duplicate found then raise error.
Or I Use
3) I create another store procedure for checking whether value exists for a field, call this store procedure in my BLL Before inserting , if duplicate found then raise duplicate exception in presentation layer catch and display duplicate exception.
or i usemodified on Friday, February 19, 2010 3:16 AM
|
|
|
|
|
According to me its better to use 2 option becuase you can do all you task in one go i.e in one procedure and you dont have to call database two time.
|
|
|
|
|
|
I am not able to see 4th option Cheers!!
Brij
|
|
|
|
|
if you want to check for User name in registration form then i recommended you to 3 where other procedure will call by ajax when you enter user name.
If it is not for registration then use 2.
|
|
|
|
|
|
Where is 4 option? I am not able to see it.
|
|
|
|
|
I will suggest, Use the combination of 1st and 2nd.
|
|
|
|
|
How to make a sub-report which get data from SQL Server based on a primary key passed from the main-report.I know how to pass parameter to the report but I don't know to pass parameter from the main report to subreport and make link in the main report. After clicking the link the subreport shows its table.
|
|
|
|
|
error occured for me in online : File or assembly name CrystalKeyCodeLib, or one of its dependencies, was not found.
how to upload assembly name CrystalKeyCodeLib in online.
|
|
|
|
|
|
Hello All,
I am following the SearchableGrdview article posted on this site and am trying to implement it in ASP.net VB. To that end, I've taken the source file posted on the article and ran it through a C# to VB converter and pasted the resulting VB code in my application where applicable.
I have an entitydatasource that I'm trying to attach to the DataView in the article's code. Here' the pertinent snippet of the codebehind:
Private Sub BindData()
'hfSearchText has the search string returned from the grid
If hfSearchText.Value <> "" Then
EntityDataSource1.Select += " where " & hfSearchText.Value
End If
Dim dv As DataView = DirectCast(EntityDataSource1.[Select](New DataSourceSelectArguments()), DataView)
'hfSort has the sort string returned from the grid
If hfSort.Value <> "" Then
dv.Sort = hfSort.Value
End If
MySearch.DataSource = dv
Try
MySearch.DataBind()
Catch ex As Exception
'If databinding threw execept bc current
'page index is > than available page index
MySearch.PageIndex = 0
MySearch.DataBind()
Finally
'Select the first row returned
If MySearch.Rows.Count > 0 Then
MySearch.SelectedIndex = 0
End If
End Try
End Sub
I'm a relative newbie to data access and don't fully understand why a DataView is being implemented. Can someone enlighten me?
When I check my error listing, I see the following:
Value of type 'System.Web.UI.DataSourceSelectArguments' cannot be converted to 'Integer'.
How do I correct this? Is this issue being caused by the conversion from C# to VB? Or, is there something particular to the use of an entity datasource that must be done differently for the code in the article to work?
Thanks so much for your help an guidance!
|
|
|
|
|
using that code im able to insert the check box value
but if i check multiple check box im able to insert only one value to db how ineed to insert for multiple values..
and how do i retrieve that values from db i.e, the check boxes should be checked when i get the values from db..
please help me...
foreach (DataListItem dli in DataList1.Items)
{
CheckBox Chk = (CheckBox)dli.FindControl("CheckBox1");
if (Chk.Checked)
{
SqlConnection SqlCnn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
SqlCommand SqlCmd = new SqlCommand();
SqlCmd.Connection = SqlCnn;
SqlCnn.Open();
SqlCmd.CommandText = "insert into test(test1) values('"+ck.Text+"')";
SqlCmd.ExecuteNonQuery();
SqlCnn.Close();
break;
}
else
{
str13 = "you need to check";
}
}
LblErr.Visible = true;
LblErr.Text = str13;
|
|
|
|
|
Bigger picture here would help. What exactly do you want to do?
Do you wish to save the text for all the check boxes that have been checked? If yes then your code here is not doing it right.
Your code is static in nature
SqlCmd.CommandText = "insert into test(test1) values('"+ck.Text+"')";
SqlCmd.ExecuteNonQuery();
i.e. every time you get a positive, the query take the text value of the check box and saves it in the db against the same table column. So, what happens is the first positives text get over written by next which again get over written by the next and goes on until the last positive which gets saved ultimately.
If you wish to save all the texts to the db, then you have got to concatenate all the text values in one string, inside the foreach loop and use it in the query and execute it outside the loop.
HTH!
|
|
|
|
|
i want to save text for every check box that is checked
and how to i retrieve those values..
the checkboxs should be checked when i get values from db...
thank you..
Dinesh Mani wrote: you have got to concatenate
and how do i concatenate those text values
|
|
|
|
|
First things first, tell us how exactly are you creating your check boxes? I mean the what is the source for your checkbox's text?
|
|
|
|
|
source is a column from table 'test'
<asp:CheckBox ID="chkItem" runat="server" Text='<%# Eval("test1") %>' />
|
|
|
|
|
I don't want to see your code buddy. I want the business case.
|
|
|
|
|
im having around 30 checkboxes in page i used datalist to display.
when check boxs checked i need to insert their names into one column(seperated by comma or space)
then when i get those values from db check boxs need to be checked(edit mode)...
|
|
|
|