Critical decision to be taken by me - ASP.NET Discussion Boards

amina894-Jun-10 0:54

4-Jun-10 0:54

Hi,

I have excel files where the teachers include student marks.
Excel files have these columns:
Id_Student ____libelle_matter1____libelle_matter2
how to import these files to table review(Id_Student,id_matter,marks)
I have the table matter: (id_matter, libelle_matter,coeff)??

Thanks.

Re: Excel to sqlserver

walterhevedeich4-Jun-10 1:31

walterhevedeich

4-Jun-10 1:31

Use import/export wizard of SQL server(http://msdn.microsoft.com/en-us/library/ms140052.aspx[^]). There's a feature there where you can map the fields from your excel spreadsheet to the fields of your table.

Re: Excel to sqlserver

amina894-Jun-10 2:00

amina89

4-Jun-10 2:00

Hi,thanks walterhevedeich
I want the teacher clicks on a button to send the files ,import/export wizard is manually, right?

Re: Excel to sqlserver

Sadheesh R7-Jun-10 20:53

Sadheesh R

7-Jun-10 20:53

Here is the C#.NET code...

// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

// Create Connection to Excel Workbook
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection);

connection.Open();

// Create DbDataReader to Data Worksheet
using (DbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = "Data Source=.; Initial Catalog=Test;Integrated Security=True";

// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "ExcelData";
bulkCopy.WriteToServer(dr);
}
}
}

show multiple files in a single iframe at once

raghvendrapanda4-Jun-10 0:01

raghvendrapanda

4-Jun-10 0:01

Hy,
I have a requirement in which i have to show multiple files in a single iframe at one go so dat i can print them at a single click without having to open print dialog multiple times.The file type can be .pdf,.xls,.txt ets.
Please help

Is RowEditing Event not required in ASP.Net 2.0?

meeram3953-Jun-10 23:46

meeram395

3-Jun-10 23:46

I have a gridview in my form which I am populating data using SqlDataSource. The gridveiw has insert, update and delete. But somehow I forgot to write the RowEditingEvent.

Upon my surpise, when I clicked on Edit button in the grid while executing, the row automatically become editable. Obviously, I have declared the columns with EditItemTemplate.

Is the RowEditing Event not required when I use ObjectDataSource or SqlDataSource? I couldn't find such event in the msdn example also MSDN Link

Thanks
meeram395.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Is RowEditing Event not required in ASP.Net 2.0?

walterhevedeich4-Jun-10 0:01

walterhevedeich

4-Jun-10 0:01

Nope its not. There's no such thing as required event in .Net. Events are raised even if there are no handlers to handle them.

http://msdn.microsoft.com/en-us/library/aa645739%28VS.71%29.aspx[^]

Critical decision to be taken by me

Sadheesh R3-Jun-10 23:04

Sadheesh R

3-Jun-10 23:04

Hello team,

I am in a very critical situation, wherein I will have to take an important decision. I have some existing C programs. Those C programs takes input from .DBF (dBase III) files and .BTR (BTRIEVE) files.

I have been given 2 options:

1) Convert .DBF files to .BTR files and .BTR files to .DBF files. These convertion can be done using .NET. If yes, give me some code snippets or some links where I can get the code.
2) Or using .NET is there any other way to replace this BTRIEVE concept itself? In other ways, instead of BTRIEVE, can we go for some other technology?

Pls advise....

Re: Critical decision to be taken by me

Sadheesh R7-Jun-10 20:49

Sadheesh R

7-Jun-10 20:49

Is there anyone who can respond to my query. This is bit urgent...Pls help me out...

Avoiding Button Double Click - AJAX

Karan_TN3-Jun-10 21:31

Karan_TN

3-Jun-10 21:31

currently i m using asp.net 2005 with c# (framework 2.0). i want to restrict the user to click the save button twice or more than that. Using ajax, i implemented it

<ajaxToolkit:AnimationExtender ID="Anibtnsave" runat="server" TargetControlID="btnsave">
                    <Animations>
                    <OnClick>
                      <EnableAction Enabled="false" /></OnClick>
                    </Animations>
                    </ajaxToolkit:AnimationExtender>

the above block will disable the button. its working fine. but i used few validation controls (ajaxToolkit:ValidatorCalloutExtender).
when i click the button the validation pop-ups and also button getting disable. please help me. - KARAN

Re: Avoiding Button Double Click - AJAX

saini arun3-Jun-10 22:20

saini arun

3-Jun-10 22:20

Try this:

private void checkButtonDoubleClick(Button button)
{
System.Text.StringBuilder sbValid = new System.Text.StringBuilder();
sbValid.Append("if (typeof(Page_ClientValidate) == 'function') { ");
sbValid.Append("if (Page_ClientValidate() == false) { return false; }} ");
sbValid.Append("this.value = 'Please wait...';");
sbValid.Append("this.disabled = true;");
sbValid.Append(this.Page.ClientScript.GetPostBackEventReference(button, ""));
sbValid.Append(";");
button.Attributes.Add("onclick", sbValid.ToString());
}

Copied from here
http://forums.asp.net/t/1362149.aspx[^]

Re: Avoiding Button Double Click - AJAX

michaelschmitt4-Jun-10 0:47

michaelschmitt

4-Jun-10 0:47

Nice ideas in this thread. I like.

Re: Avoiding Button Double Click - AJAX

Karan_TN6-Jun-10 19:59

Karan_TN

6-Jun-10 19:59

great arun. thanks a lot.
also the same i would like to apply for an dropdownlist. because according to the selection of dropdown value, i m changing the button textvalue. according to the text value i m calling different functions.so when user select the dropdownlist item, it take some time. during that time, user should not click the button obviously.

so i want to disable the button while user selecting item from dropdownlist until the text changes.

how to achieve it? help me - KARAN

Develop Video Chat/Voice Chat

Member 47201843-Jun-10 21:25

Member 4720184

3-Jun-10 21:25

Dear Tech Guys,

I want to know ,how to develop messenger with Video chat like Yahoo messenger.

Please provide reference articles.

Thanks
Srinivas

Re: Develop Video Chat/Voice Chat

Sandeep Mewara3-Jun-10 22:59

Sandeep Mewara

3-Jun-10 22:59

You look like too lazy to even Google it out. I am sure there would be no point asking what have you tried till now.
Go here:
http://www.google.com

http://www.codeproject.com

Use keywords like - chat, messenger, etc. You will get lots of articles.

Re: Develop Video Chat/Voice Chat

walterhevedeich4-Jun-10 0:05

walterhevedeich

4-Jun-10 0:05

(sigh) People these days are used to spoonfeeding. Help yourself buddy. research first on what you want to do and then based on your researches, ask questions. It would be an interesting discussion if it was done that way. Wink | ;)

Integrate Google calender with ASP.Net

Amit Patel19853-Jun-10 20:59

Amit Patel1985

3-Jun-10 20:59

Hi All,

i want to integrate google calender api in .net how to do this.please help me to do this?

Thanks ,

Amit Patel

Re: Integrate Google calender with ASP.Net

saini arun3-Jun-10 21:13

saini arun

3-Jun-10 21:13

What about this one:

http://code.google.com/apis/calendar/data/2.0/developers_guide_dotnet.html[^]

Re: Integrate Google calender with ASP.Net

Sandeep Mewara3-Jun-10 23:04

Sandeep Mewara

3-Jun-10 23:04

I did this[^] and got these and many more:
Google: Data API Developer's Guide: .NET[^]
How to Create Google Calendar Events Using .NET[^]
http://ajax.phpmagazine.net/2006/04/howto_integrate_google_calenda.html[^]
http://www.devsource.com/c/a/Techniques/Interacting-with-Google-Calendar-via-NET/[^]

Logout on click

Dot-Net-Dev3-Jun-10 18:18

Dot-Net-Dev

3-Jun-10 18:18

Following is my code for login:

void Page_Load(object sender, EventArgs e) {

string appURL = "http://www.mysite.com/Login.aspx";
string strPostData = String.Format("login={0}&password={1}",
"myloginname", "mypassword");

// Setup the http request.
HttpWebRequest wrWebRequest = WebRequest.Create(appURL) as
HttpWebRequest;
wrWebRequest.Method = "POST";
wrWebRequest.ContentLength = strPostData.Length;
wrWebRequest.ContentType = "application/x-www-form-urlencoded";
wrWebRequest.CookieContainer = new CookieContainer();

// Post to the login form.
StreamWriter swRequestWriter = new
StreamWriter(wrWebRequest.GetRequestStream());
swRequestWriter.Write(strPostData);
swRequestWriter.Close();

// Get the response.
HttpWebResponse hwrWebResponse =
(HttpWebResponse)wrWebRequest.GetResponse();

// Have some cookies.
CookieCollection ccCookies = hwrWebResponse.Cookies;

// Read the response
StreamReader srResponseReader = new
StreamReader(hwrWebResponse.GetResponseStream());
string strResponseData = srResponseReader.ReadToEnd();
srResponseReader.Close();

// Display the response.
Response.Write(strResponseData);
}

It logs me in successfully but when I click on any link, it logs out.

Please let me know what's going wrong.

Re: Logout on click

Viral Upadhyay3-Jun-10 18:50

Viral Upadhyay

3-Jun-10 18:50

From Your code it looks like you are login from other side,

What you need to do is when you login successfully you need to set session values,
And when you go to other page check this value so you will not log out.

hint is when you sent login successfully response from other site, send some values like 'userid',
and set this id session value.

Viral
My Site

Save Our Tigers

Please provide detailed description about delegates

anoop_m833-Jun-10 12:12

anoop_m83

3-Jun-10 12:12

Please provide detailed description about delegates and events. i am get little confuse in both.
1:need of delegate in asp.net??

Re: Please provide detailed description about delegates

dan!sh 3-Jun-10 16:29

dan!sh

3-Jun-10 16:29

Read on MSDN about it.

Re: Please provide detailed description about delegates