|
I have a web form that a user fills out. The form fills in several tables which key off another table that I'll call Table1. When I add a record to Table2, I need a valid key from Table1. What I'm currently doing is adding a record to Table1 and using the key SQL Server returns to me. So far so good. My problem is if the user doesn't complete the form, I'll have a basically empty record in Table1 and bunch of records in Table2.
What I would do in a desktop app would be to use DataTables (C#) in memory and update the DB later but since this is a Web Form, I don't want to kill the server with a bunch of extra junk.
So is what I'm currently doing correct? Should I write a utility/query to clean out the half completed records? Am I correct in assuming that keeping a couple DataTables in memory for each logged in user is bad practice?
Thanks in advance!
|
|
|
|
|
I have a SQL database with a "Real" field called "MinutesRemining", I am trying ot load it into a DataGrid as in the example below:
<br />
Dim dt As New DataTable<br />
Dim MyDataRow As DataRow<br />
<br />
dt.Columns.Add(New DataColumn("MinutesRemaining", GetType(GetSQLInt32)))<br />
<br />
sqlStatement = "Select MinutesRemaining from tblStatusLot "<br />
<br />
Dim cmd As New SqlCommand(sqlStatement, cn)<br />
Dim dr As SqlDataReader = cmd.ExecuteReader<br />
Do While dr.Read()<br />
MyDataRow = dt.NewRow()<br />
MyDataRow(0) = dr.GetSqlInt32(0)<br />
The database field type is "Real", but there is not an option for real in the "dr." options, nor is there one in the DataColumn function options. I get an error "Specified Cast is Not Valid", when I use GetDouble, GetSQLInt32, I am not what conversion I should be usng as there is not an option for Real.
Thanks in advance...
|
|
|
|
|
Hard to know for sure, but I think what you want here is the Decimal type GetSqlDecimal. So the type in your table will also need to be of Type Decimal or float. I am pretty sure if you have a real number in sql calling it an int is not going to work.
Hope that helps.
Ben
|
|
|
|
|
Thanks for the suggestion, I changed the table and tried a few other casts. It turns out to be happiest with no casting at all... Now why did I not think if that first....
|
|
|
|
|
Great, I am glad that it worked out. Isn't that funny how it works out that way sometimes?
Ben
|
|
|
|
|
The equivalent .NET data type for a Real is Single. You can use the GetFloat method to read it from the data reader.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I'm trying to Insert a new Row on a dagrid. When I did a google search, I got an example on this address: http://www.codeproject.com/ASPNET_DataGrid.asp.
I've done mycode as follows:
private void Fill()
{
DataSet ds=new DataSet();
SqlDataAdapter adapter =new SqlDataAdapter("select * from DashBoard", con);
adapter.Fill(ds);
}
private void Bind()
{
DataSet ds=new DataSet();
dgis.DataSource = ds;
dgis.DataBind();
}
private void InsertEmpty()
{
DataSet table=new DataSet();
Table.Rows.InsertAt(Table.NewRow(), 0);
}
private void bttnew_Click(object sender, System.EventArgs e)
{
dgis.EditItemIndex = 0;
EditCommandColumn ecc = (EditCommandColumn) dgis.Columns[0];
ecc.UpdateText = "Insert";
Fill();
InsertEmpty();
Bind();
}
private void dgis_ItemCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgis.EditItemIndex = -1;
switch (e.CommandName)
{
case "Insert":
break;
case "Update":
break;
case "Cancel":
EditCommandColumn ecc =(EditCommandColumn) dgis.Columns[0];
ecc.UpdateText = "Update";
break;
case "Edit":
dgis.EditItemIndex = e.Item.ItemIndex;
break;
}
Fill();
Bind();
}
On compiling I get this error
-'System.Web.UI.WebControls.Table' does not contain a definition for 'NewRow'
-'System.Web.UI.WebControls.TableRowCollection' does not contain a definition for 'InsertAt'
-'An object reference is required for the nonstatic field, method, or property 'System.Web.UI.WebControls.Table.Rows'
Where could I be going wrong?
|
|
|
|
|
Hi,
I want a customized User Profile Search. I cannot use GetUserProfile method as it returns only one user profile. What is the way to get a list of users matching the input user name.Please help me with the sharepoint 2007 code for the same.
Thanks in advance...........
Usha
|
|
|
|
|
hi,
i want to do keyword search in word .doc files, e.g in resumes, i want to implement a script in asp 3.0, please guide me by giving some help full links to get started, or give some code snipts... any help will be highly appreciated.
Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com
|
|
|
|
|
Hi all,
actually i am very depressed of VS.NET 2.0 i have a real problem and am sure i'll found the solution here. firstly i can't understand how .net 2.0 doesn't automatically create dll file for the project, while i was using .net 1.1 there was bin\debug which contains dll file for the web project so i can upload it on the server each time i change something in the code. now after converting to .net 2.0 i don't know what to do? also i found a tool which is "web deployment" i installed it and tried to get the dll it works once and didn't work again but when it worked the build number was 0.0.0.0 and it never changes when i make changes and build again. please i really need help if anyone can. Thank you all
|
|
|
|
|
The problem may be in your solutionInfo file. You should find something like this:
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.0.*")]
[assembly: AssemblyFileVersion("1.0.0.*")]
I am guessing that you don't have * in the build you just have 0.0.0.0 which means you are controling the build number.
Hope that helps.
Ben
|
|
|
|
|
Hi All,
I'm setting up a webserver and I'm a noob when it comes to. I will be doing my own research but just so I can direct my energy (and money!) on the right references, can I have your suggestions on:
1. Beginner's Guide
2. Definitive Reference
when it comes to
a. Setting up
b. Maintaining
webserver/website.
I am planning for the website to be interactive and not just plain html. Also, please don't limit your suggestions to books, websites will also be good.
Thank you and have a nice week ahead!
-- modified at 20:59 Sunday 25th February, 2007
I am a SysAdmin, I battle my own daemons.
|
|
|
|
|
Don't do it. If you are planning to create a web server that is publicly available then you will need more then just what references can teach you, you need experience. I would advise you use a hosting service to host your website and learn by example.
Also what language and platforms are you planning to use?
Brad
Australian
- Christian Graus on "Best books for VBscript"
A big thick one, so you can whack yourself on the head with it.
|
|
|
|
|
Thanks mate. I am weighing whether to use IIS/Asp.Net or Apache/Java (then there's CSS and a myriad other technologies). Since I am a C#/MS developer I have bias towards the former. I have registered a DNS but I thought if I host it myself I would learn more from it (I'll just use a dynamic DNS host). Yes I would like to do hands on hence I've bought all the necessary h/w and the DNS service but still it would be great to have some references. One that is for beginners and another definitive.
Cheers!
DC
I am a SysAdmin, I battle my own daemons.
|
|
|
|
|
Well, You are about to embark on a journey fraught with danger.
It's one thing setting up the server to run, but it's another thing when the banshee's arrive and start attacking the server, and believe me they will arrive in a matter of days, it is then that unfortunately no amount of books, references etc. will prepare you for, and you will be spending most of your time trying to figure out what they have done, instead of actually learning.
I think what you have to decide is what do you actually want to learn? To you want to learn how to code and deploy a website? Or do you want to learn how to defend a web server? Sadly learning how to do both will take plenty of time and effort.
I found this book invaluable when it came to IIS 6.0
IIS 6.0 book
|
|
|
|
|
Web development is one thing; running and securing a web server is another.
If you want to run a web server and understand how you can lock it down, instead of hosting it at a service provider, maybe the following links can point you in the right direction. Be prepared for getting some unwanted attention, and spending some time to deal with it.
http://articles.techrepublic.com.com/5100-10878_11-5055458.html
http://www.microsoft.com/technet/community/events/iis/tnt1-40.mspx
http://www.windowsecurity.com/articles/Installing_Securing_IIS_Servers_Part1.html
http://www.washington.edu/computing/support/windows/UWdomains/IISsecchecklist.html
http://searchsecurity.techtarget.com/tip/1,289483,sid14_gci1015581,00.html
If you want to just run a web server that you and a few people known to you wants to access, you can use a port other than port 80. Also make sure that only the web server port remains accessible from the Internet.
Go through the web server logs regularly. A hardware firewall may be good to have, but not essential. After all, if you have problems that take up too much of your time, you can just block the port, take down the webserver, and host it on a hosting service. It might also be a good idea to capture incoming packets (you won't have too many) using Wireshark so that you understand what kind of traffic your webserver attracts.
If you have the time, I will recommend that you do this. It will enhance your skills for sure. But, if you are interested in just getting a web presence and not in understanding how to run an Internet facing server, you better use a hosting service.
IIS or Apache -- the issues are the same. Your windows background makes IIS ideal. Checkout Ruby on Rails also. http://www.rubyonrails.org/. Paul Watson is the resident expert on this subject.
Thomas
Thomas
modified 29-Aug-18 21:01pm.
|
|
|
|
|
I'd suggest a book which i have:
Internet Information Services (IIS) 6.0 -- its a Microsoft Press Resource Kit book, very informative.
If your on vista or longhorn however you may want to look for a version 7 book, IIS has changed a great deal, the management console especially.
I'd suggest going with ASP.net if your a c# developer, Java will just p*ss you off to no end.
--
Real programmers don't comment their code. It was hard to write, it should be hard to understand.
|
|
|
|
|
Hi,
I'm using .Net 1.1 and AJAX.
I'm using a "div" in my aspx page.
I have a textbox and a button used to search the database.
Now, whatever the user types in the textbox I want to show the returned results within the "div".
The problem I'm facing is that in my code the "xmlHttp.responseText" is returning the entire content of the page. And not the returned results part.
And so, is throwing me "Unknown Runtime Error" (javascript error).
Am I doing something wrong?
Please Help.
|
|
|
|
|
The response will contain whatever you put into it. What's your code for setting up the response ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
As a quicky, try adding Response.End() after you write what you want on the server.... 
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Thanx for the suggestion...Richard...
Your advice worked...
Thanx once again...
|
|
|
|
|
I am developing a site with multilanguage. Now my question is how to translate english to other language (french ) and vice versa. I want to use one database for all language. I am using php. plz. suggest me!!!
Bharat Bhusanam
|
|
|
|
|
If the pages are dynamic in your site, I am affraid you won't be able to translate the site to other languages because it would become an hassel for you to do it. If there are some static content such as (text, label, title, etc.) in the pages, you can set the the appropriate strings in different languages in database also variables in the pages for these strings.
With LCID session variable, you can retrive the value and then load the appropriate strings for the variables in pages from database. The most web sites actually have partially static pages in different languages.
What a curious mind needs to discover or penetrate a knowledge is noting else than a pin-hole.
|
|
|
|
|
I have to translate the site to 6 language.I have already done what you have maintioned.Your procedute is vety simple. If the user is in english labguage and it changes to some other language then the content dynaminc data from the database should displayed with converted language. For your reference you can take the example of www.Unister.com. How they does? Exactly I need that. In that case they are using one database or one database for each language.Plz. help me.
Bharat Bhusanam
|
|
|
|
|
Okay! I have examined the www.unister.com and saw that they have a different domain name for each language and they have developed the pages as I mentioned above.
You should decide about data in the pages what must be dynamic or static and then the things would become easier for you realize the project. For example if you have a news section in the pages that must be dynamic because you suppose to display the news in different languages on daily basis. If you have some static messages. you don't have to enter this to database just keep it static in the specific language.
Of course I assume that you have a control panel where you can add or modify the data (right?). If you don't have a control panel in asp or php, you better consider to have it first.
Also it is not mandatory to have everything translated to another language for example banners. Of course it is up to you.
Let me know the progress.. OKAY! Take it easy... 
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
