ASP.NET

FirstPrevNext

Re: sqlbulk copy asp.net c# Ashfield28-Jul-08 1:12 Ashfield 28-Jul-08 1:12  Usually I import into a staging table where every column is a varchar, then validate the contents to the real data type before moving them to the actual destination table. This gives you a chance to perform other validation too. Bob Ashfield Consultants Ltd Re: sqlbulk copy asp.net c# VijayVishwakarma28-Jul-08 20:10 VijayVishwakarma 28-Jul-08 20:10  HI, is there any way to detect that what kind of value is there in an .csv file rows?? thanks Vijay V. Yash Softech Re: sqlbulk copy asp.net c# Ashfield28-Jul-08 21:04 Ashfield 28-Jul-08 21:04  Not until its in a table. You should be able to do some basic checks as you know the final destination table. Bob Ashfield Consultants Ltd Re: sqlbulk copy asp.net c# VijayVishwakarma28-Jul-08 21:20 VijayVishwakarma 28-Jul-08 21:20  Hi Bob, thanks for reply. I was googling and found that I can use Namespace System.Microsft.SqlServer.SMO that has a class datatype using which I can set the datatype depending on my requirement but this I m not able to import this class in my project. Do u have any idea regarding this here is the code public DataType GetDataType(string dataType) { DataType DTTemp = null; switch (dataType) { case ("System.Decimal"): DTTemp = DataType.Decimal(2, 18); break; case ("System.String"): DTTemp = DataType.VarChar(50); break; case ("System.Int32"): DTTemp = DataType.Int; break; } return DTTemp; } Thanks Vijay V. Yash Softech Re: sqlbulk copy asp.net c# Ashfield29-Jul-08 9:37 Ashfield 29-Jul-08 9:37  You can do it from there, or this sql works too select column_name,data_type from information_schema.columns where table_name = '<yourtable>'</yourtable> |For details on using the smo method see my CP article [^] Bob Ashfield Consultants Ltd Re: sqlbulk copy asp.net c# VijayVishwakarma29-Jul-08 19:44 VijayVishwakarma 29-Jul-08 19:44  Hi Bob, thanks for the help. Vijay V. Yash Softech Re: sqlbulk copy asp.net c# Ashfield30-Jul-08 1:17 Ashfield 30-Jul-08 1:17  No problem Bob Ashfield Consultants Ltd Access Denied Error. Binod K27-Jul-08 22:12 Binod K 27-Jul-08 22:12  Hi, I have taken refrence of Microsoft Excel 11.0 Object Library in my project to export data in Excel. And included following Name spaces Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices.Marshal Now i have declared following variables. Dim objExcel As New Excel.Application When i execute the code it gives Access Denied Error. I check all the sharing and Security settings. Your comments will be highly appreciated. Thanks Binod K. (Miles to go before I sleep) Re: Access Denied Error. Vasudevan Deepak Kumar28-Jul-08 18:27 Vasudevan Deepak Kumar 28-Jul-08 18:27  Check out this related thread: http://www.velocityreviews.com/forums/t107560-excel-interop-problem-access-is-denied.html[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips All the world's a stage, And all the men and women merely players. They have their exits and their entrances; And one man in his time plays many parts... --William Shakespeare Accessing Shared Variables nagendrathecoder27-Jul-08 21:46 nagendrathecoder 27-Jul-08 21:46  Hello Friends, I am developing as application in ASP.Net with code behind as VB. I have declared a variable as shared in a code behind class like: Partial Class MyPage Inherits System.Web.UI.Page Public Shared MyArray(1,2) as String Now, how can i access this MyArray in some other code behind class? Plz help me. Thanks and regards, Nagendra. Re: Accessing Shared Variables eyeseetee27-Jul-08 21:56 eyeseetee 27-Jul-08 21:56  Why dont you put your array in a common methods class and then just access that from your class pages Re: Accessing Shared Variables nagendrathecoder27-Jul-08 22:10 nagendrathecoder 27-Jul-08 22:10  Sorry, i didn't understand. Can u plz explain. Re: Accessing Shared Variables eyeseetee27-Jul-08 22:28 eyeseetee 27-Jul-08 22:28  Put a page class in your app folder and put the array in there. Then you can reference that page from other pages. Re: Accessing Shared Variables nagendrathecoder27-Jul-08 22:53 nagendrathecoder 27-Jul-08 22:53  It worked.....Thanks Re: Accessing Shared Variables eyeseetee27-Jul-08 23:31 eyeseetee 27-Jul-08 23:31  Glad to hear it From datatable binding the mail body in runtime Member 387988127-Jul-08 21:22 Member 3879881 27-Jul-08 21:22  Hi runtime i am telling whats my mail body have to contain..., But its not at all considering that for loop of j and inside if condition: This is my code: foreach (FileInfo f in fInfos) { attach = new MailAttachment(f.FullName); for (int j = DS.Tables.Count - 1; j < DS.Tables.Count; j++) { if(Path.GetFileNameWithoutExtension(d.Name)==DS.Tables[j].Rows[0][1].ToString()) { mbody = "<table width='600' style='FONT-SIZE: 8.5pt; COLOR: #003d6a; FONT-FAMILY: tahoma; HEIGHT: 24px'>" + "<tr bgcolor='#F1F1F1'><td colspan='2' align='left' height='25px'><b>Time Sheet For Last Week Employee Details :</b></td></tr>" + "<tr><td>Employee Name:</td><td>Working Dates :</td><td>Worked Dates :</td></tr>" + "<tr><td>" + DS.Tables[j].Rows[0][2].ToString() + "</td>" + "<td>" + DS.Tables[j].Rows[0][3].ToString() + "</td>" + "<td>" + DS.Tables[j].Rows[0][4].ToString() + "</td></tr>" + "</table>"; } mailMessage.Body = mbody; } Re: From datatable binding the mail body in runtime Sherin Iranimose27-Jul-08 22:45 Sherin Iranimose 27-Jul-08 22:45  New one wrote: for (int j = DS.Tables.Count - 1; j < DS.Tables.Count; j++) what you are trying to do with the loop? That loop always iterates one time. Add TabPanel inside a tabpanel of ajax tabcontainer Bharani_Ram27-Jul-08 21:08 Bharani_Ram 27-Jul-08 21:08  Add TabPanel inside a tabpanel of ajax tabcontainer i need to add a subtabpanel in side a main tabpanel Here is a sample code Protected Button_Click(object sender,EventArgs e) { Listbox ListBox1 = new ListBox(); ListBox1.SelectedIndexChange += new EventHandler(ListBox1_SelectedIndexChange); AjaxControlToolkit.TabPanel Maintab = new AjaxControlToolkit.TabPanel(); Maintab.Controls.Add(ListBox1); TabContainer1.Tabs.Add(Maintab); } void ListBox1_SelectedIndexChange(object sender,EventArgs e) { // This code does not works string str = Listbox1.SelectedItems.Text.Trim(); } i want to add a sub tab inside the Maintab on selected index change of the listbox. i have tryed in this way too i.e declared the ListBox as common ListBox Listbox1 = new ListBox(); Protected Button_Click(object sender,EventArgs e) { ListBox1.SelectedIndexChange += new EventHandler(ListBox1_SelectedIndexChange); AjaxControlToolkit.TabPanel Maintab = new AjaxControlToolkit.TabPanel(); Maintab.Controls.Add(ListBox1); TabContainer1.Tabs.Add(Maintab); } void ListBox1_SelectedIndexChange(object sender,EventArgs e) { // This code does not works only for a single tab alone string str = Listbox1.SelectedItems.Text.Trim(); AjaxControlToolkit.TabPanel stab = new AjaxControlToolkit.TabPanel(); stab.Header = str; TabContainer1.Tabs.Add(stab); } Can Any Help me Please. Bharani Add Ajax TabPanel Dynamically on button click Bharani_Ram27-Jul-08 21:06 Bharani_Ram 27-Jul-08 21:06  Add Ajax TabPanel Dynamically on button click I have placed the TabContainer From ajax toolkit i want to add the tabs dynamically on button click. Help me. Bharani Re: Add Ajax TabPanel Dynamically on button click Sam Xavier27-Jul-08 21:16 Sam Xavier 27-Jul-08 21:16  Please look into this forum post which provides a detailed information: http://forums.asp.net/p/1235993/2243816.aspx[^] Best Regards, Sam Xavier www.componentone.com iis issue Tauseef A27-Jul-08 20:49 Tauseef A 27-Jul-08 20:49  hi guys i am getting the following error while i run my project , i am using vs2008 and C#. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information. my application is configured with IIS correctly and runs through virtual directory , but from my solution i cannot run it, why ? thanks in advance . hello Re: iis issue Sam Xavier27-Jul-08 21:13 Sam Xavier 27-Jul-08 21:13  To run a website from a solution, are you using ASP.NET development server (provided by default in VS 2008) or IIS? Best Regards, Sam Xavier www.componentone.com How to deal with the error of "The page cannot be displayed" Robert Wang198327-Jul-08 20:49 Robert Wang1983 27-Jul-08 20:49  I have a web service and an web application deployed on my laptop. the webservice works fine but when open my web application It told me The page cannot be displayed, the title is "Server can not find" Any one has the solution? Thanks! Re: How to deal with the error of "The page cannot be displayed" Robert Wang198327-Jul-08 20:50 Robert Wang1983 27-Jul-08 20:50  BTW, I use asp.net 2.0 Re: How to deal with the error of "The page cannot be displayed" neilmajithia27-Jul-08 23:29 neilmajithia 27-Jul-08 23:29  was that the whole error message? what could it not find? the web applications main page?

Last Visit: 31-Dec-99 18:00     Last Update: 14-Jun-24 23:37 Refresh ᐊ Prev1...2970297129722973297429752976297729782979 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.