|
I use Javascript merge ms excel cells,my code is :
oSheet.Range(Cells(1, 1), Cells(2, 2)).Merge();
It report errors,
pls help me,Thank you!
|
|
|
|
|
I got a answer from one of my friends.
oSheet.Range("A1:B2").Merge();
It works.
I don't know what wrong with this:
oSheet.Range(Cells(1, 1), Cells(2, 2)).Merge();
|
|
|
|
|
I m working on a project in asp.net 2.0.
I want to see "web form designer generated code" in dotnet 2.0.
In dotnet 1.1 we can see this in code behind file(e.g cs file). But in dotnet 2.0 code behind file does not show this.
How can we see this................
Do good and have good.
|
|
|
|
|
If you are using the Web Site default template, then have a look at the cache folder of the ASP.NET 2.0:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\XXXX If you use the Web Project 2005 template, you will see it in the same folder as the code-behind source file.
|
|
|
|
|
If you are looking to edit this code, then you'll find that it is all auto-generated now. Editing this code, as was possible in asp.net 1.1 was never recommended.
|
|
|
|
|
i donot want to edit it. I just want to see that code.
Do good and have good.
|
|
|
|
|
Imanage to insert data from textbox into data table and bind that datatable to datagrid. actually I want following things
I am making an application in which I have to insert data in data table .and bind that datatable to datagrid.
1) but i want to insert this values from datagrid footer or datatable footer how to do that.
2) also i want to update the row of data grid . I am not using database for that . how to update a single row of datagrid from using data table there is no transection with database.
************************************************************
The code i wrote is follow
Dim TB As DataTable
Dim TR1 As Data.DataRow
Dim td1 As DataColumn
Dim TD2 As DataColumn
Dim td As DataColumn
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Me.IsPostBack = False Then
Display()
End If
End Sub
Function Display()
TB = New DataTable
td1 = New DataColumn
td1.ColumnName = "SHAPE"
td1.DataType = GetType(String)
td1.AllowDBNull = False
TB.Columns.Add(td1)
TD2 = New DataColumn
TD2.ColumnName = "SIZE"
TD2.DataType = GetType(String)
TD2.AllowDBNull = False
TB.Columns.Add(TD2)
Datagrid1.DataSource = TB
Datagrid1.DataBind()
Session("DiaDetails") = TB
End Function
Sub AddToCart(ByVal sender As System.Object, ByVal e As System.EventArgs)
TB = Session("DiaDetails")
TR1 = TB.NewRow
TR1("Shape") = txtshape.Text
TR1("Size") = txtsize.Text
TB.Rows.Add(TR1)
Datagrid1.DataSource = TB
Datagrid1.DataBind()
Session("DiaDetails") = TB
End Sub
Sub Delete_Item(ByVal s As Object, ByVal e As DataGridCommandEventArgs)
TB = Session("diadetails")
TB.Rows(e.Item.ItemIndex).Delete()
Datagrid1.DataSource = TB
Datagrid1.DataBind()
Session("diadetails") = TB
End Sub
Private Sub Datagrid1_EditCommand(ByVal source As Object, ByVal e As tem.Web.UI.WebControls.DataGridCommandEventArgs) Handles Datagrid1.EditCommand
Datagrid1.EditItemIndex = e.Item.ItemIndex
End Sub
Private Sub Datagrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Datagrid1.UpdateCommand
Dim strshape As String = CType(Datagrid1.Items(Datagrid1.EditItemIndex).Cells(1).Controls(0), TextBox).Text
Dim strid As String = Datagrid1.Items(Datagrid1.EditItemIndex).Cells(0).Text
Datagrid1.EditItemIndex = -1
End Sub
pls Send code if possible
Pls its urgent
|
|
|
|
|
how to do RSS feed for asp.net1.1 application
|
|
|
|
|
|
Hi friends,
in my application, i am using outlook 11.0 to send mail to the recipient whose address stored in excel. i am fetching excel and stored the address in grid view and sending the mail. For me the mail should send to all the recipients but one mail at a time. after sendnig the first mail the next mail should send. i used for loop for this. but very first email id is sending properly thro outlook. but for the next loop it gives error that item moved or deleted. i give the code. please help.
Code:
Outlook.Application o = new Outlook.ApplicationClass();
Outlook.MailItem myMail = (Outlook.MailItem)o.CreateItem(Outlook.OlItemType.olMailItem);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
myMail.Recipients.Add(GridView1.Rows[i].Cells[0].Text);
myMail.Subject = "Check";
myMail.Body = "Its a Demo Mail. Good Afternoon";
myMail.Attachments.Add("C:/New1.txt", Missing.Value, Missing.Value, Missing.Value);
myMail.Send();
}
Prya
|
|
|
|
|
Try to declare myMail object in the loop
Outlook.Application o = new Outlook.ApplicationClass();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Outlook.MailItem myMail = (Outlook.MailItem)o.CreateItem(Outlook.OlItemType.olMailItem);
myMail.Recipients.Add(GridView1.Rows[i].Cells[0].Text);
myMail.Subject = "Check";
myMail.Body = "Its a Demo Mail. Good Afternoon";
myMail.Attachments.Add("C:/New1.txt", Missing.Value, Missing.Value, Missing.Value);
myMail.Send();
}
Nobody is perfect i'm Nobody
|
|
|
|
|
Thank u its working.
Prya
|
|
|
|
|
Hi
I am using Visual Studio 2003 and SQL Server 2000 to try and develop an E-Commerce website. Amongst others I have a Customers table, Suppliers table and a Roles table in the database. What is the standard procedure regarding storing usernames and passwords? At the moment I have Username and Password columns, as well as a foreign key column to the Roles table, in the Customers table as well as in the Suppliers table.
On my login page I have two radiobuttons so the user can specify whether they are logging in as a Customer or a Supplier. That determines then in which table I go to check the username and password. If the user is a valid user, the following line of code runs:
FormsAuthentication.RedirectFromLoginPage(userIndex.ToString(), ChkRemember.Checked);
The problem is that then I do not know how to use the Application_AuthenticateRequest() method in the Global.asax.cs. How would I specify in there which database table to be accessed to retrieve the roles? I tried using session variables, but they were not accepted in the Application_AuthenticateRequest() method.
protected void Application_AuthenticateRequest(Object sender, EventArgs e)
{
string[] roles = Access_Customers.GetCustomerRoles(HttpContext.Current.User.Identity.Name);
HttpContext.Current.User = new GenericPrincipal(HttpContext.Current.User.Identity, roles);
}
Am I missing the point completely here? Is there a better way of approaching this? Perhaps have all login data (usernames and passwords in one table)?
What is better from a security point of view to use in authentication and authorization: Cookies or Session variables?
Thanks.
Kobus
|
|
|
|
|
Hi
If you have defined roles, user and password in database, then why u r using Application_AuthenticateRequest(Object sender, EventArgs e) event of globaal.cs. You can directly access through database by forms submit button.
Kumar
|
|
|
|
|
hi,
i want to know how should i return values from jagged arrays
public string[][] fync(Type webtype)
{
string[][] dimen= new string[3][];
dimen = getDetails(Type Webtype);
//how should i collect values in dimen
}
public string[][] getDetails(Type webtype)
{
//suppose ss is jagged array of dimension ss[3][]
//ie i have ss[0] = i have something
// ss[1]= i have something else
// ss[2]= i have some third item
return ss;
}
I hope i am doing right
help please
Thanks JIny
|
|
|
|
|
A jagged array is just an array of arrays. To create one you first create the main array, then create each sub-array:
string[][] ss;
ss = new string[3][];
ss[0] = new string[] { "Some", "strings" };
ss[1] = new string[] { "Some", "more", "strings" };
ss[2] = new string[2];
ss[2][0] = "Individual";
ss[2][1] = "strings";
When you get the jagged array from the function, you shouldn't create an array first. That only means that you create an array that you will just throw away. Just declare the reference for the array:
string[][] dimen;
dimen = getDetails(webtype);
---
b { font-weight: normal; }
|
|
|
|
|
Hi friends,
I just have one small doubt. I just inserted one button into the itemtempelate of a datalist and without writitng any code i ran the project. i tried the same with repeater and datagrid. but the button inserted was not to be seen in any of the above mentioned controls. Where as when i inserted a button to a form i was able to see that button. can anyone tell me why is it like that.
Vipin
|
|
|
|
|
The DataList control is a data-bound control like Repeater, DataGrid. It means you need to bind a datasource to the control to create the UI, otherwise the control displays nothing. You can read more about how to use these controls in MSDN.
|
|
|
|
|
I'm playing by the rules, I have a theme setup with a skin file for all my control style settings.
For some reason as I'm working what appear to be defaults for styles for controls keep creeping back into my aspx page and overriding my .skin file.
I think when I bring up the properties of a component in the visual designer and change something innocuous like enableviewstate it's automatically setting a bunch of default style settings that I had just removed.
Is there any setting or way to prevent visual studio from setting any default style settings for components either existing ones or when putting new ones on the forms?
(or is this just a half implemented feature?)
P.S. And why doesn't it preview the page in the designer with the settings in the skin file (or is this again a half implemented feature?)
|
|
|
|
|
Hi there,
What do the generated style settings contain? Are they all related to positioning like left, top ...or something else?
|
|
|
|
|
I don't have it in front of me but definitely settings for fonts etc.
I'm now wondering if it's only the infragistics components that are doing this. I nearly work with only infragistics components so perhaps it's something that doesn't happen with the "stock" ms components.
|
|
|
|
|
Hello all,
I have a very small problem, but could not find the solution.
I have a link button on aspx page. I have some functionality in the link button's click event. I have some data on client side. I want those data from the client side to the server side when somebody click on the link button.For say, I have three datafields in javascript file, which contains data- eventid, date, name. Well, I don't know the AJAX tech., but I would like to implement it if somebody help me out in this problem.
Thanks,
Robin
|
|
|
|
|
If the entire web page is reloaded when the user hits the button, then you simply persist the client side data in a hidden field so that it can be posted to the server and you can easily access it. You might only consider using AJAX when you don't want to reload the entire web page, and you surely can find lots of tutorials out there with your friend Google.
|
|
|
|
|
Hi, from Italy,
I've a problem with a RegularExpressionValidator.
I want validate a textbox following these condition:
1) length must be beetween 3 and 7 charachters
2) spaces not allowed
3) must contains at least 2 of these special charachters ($,%,&,/,(,),=,£,")
4) must contains only these special charachters ($,%,&,/,(,),=,£,"), numbers, letters (uppercase and lowercase) and no spaces
It's too difficult for me.
In Italy there aren't serious guidelines for RegularExpressions, and i've not find answer to my questions online in other sites.
Please help me, i know you can.
thank you.
|
|
|
|
|