|
hi,
I would like to build a Webapplication usin ASP.net through VisualStudio Express.
However my host does not support the .mdf database files.
Basically i have three options:
Set up an ODBC to an Access Database file for free,
or
Order a Fullblown MS SQL-Server 2005 wich (beeing a Student with little money) would cost money id rather not spend.
Finnaly
I could also use a MySQL Database for free, but it does not integrate into the VS IDE at all (as far as i know)
This new site will replace an old one, wich over the course of the last few years got an average of about 850page views per day.
so what should i do?
~Luke
-- modified at 9:15 Monday 17th July, 2006
|
|
|
|
|
You could change to a host with Sql Server or see if yours has an add on.
-- modified at 9:50 Monday 17th July, 2006
|
|
|
|
|
but again they want money for it....
i guess the question is rather:
Could i use Access? If not, how hard is it to work with MySQL
|
|
|
|
|
Why not use SQL 2005 Express? It integrates with the express studios just fine and it doesn't limit you in your programming capabilities. The limitations with SQL 2005 Express are some advanced Database server features, concurrent database access and database size limitation (4GB if I'm not mistaken, I'm certain that on MSDE it was 2GB, but not sure with SQL 2005 Express).
MySql is a good option. I've used it and works great with the .net connector found in www.mysql.com.
MySql is just a bit different compared to MS SQL (Sql queries change a bit), there are some differences in data types, but they all translate fine to .net through the connector.
daniero
|
|
|
|
|
I have asked about SQL2005 Experss, but my host claimed they did not support it 
i forgot to mention that the MySQL server avaliable is only version 4.1.19 but ill have a look if i cant find a .net connector anyway..
|
|
|
|
|
the .net connector itself is free for download in www.mysql.com[^]
I've used it witn mysql server versions from 3 to 5 with no problems at all.
daniero
|
|
|
|
|
If i call the Web Service from the same server which i hosted,it's working fine.If i try to call the web service from another server i get the following error.
Unable to generate a temporary class (result=1).
error CS2001: Source file 'C:\WINDOWS\TEMP\39_bmero.0.cs' could not be found.
error CS2008: No inputs specified.
Kindly help me....
Sathiyaraj Ganesan
|
|
|
|
|
I have an DataGrid and a CheckBoxList in EditItemTemplate as shown below:
<asp:TemplateColumn HeaderText="Users">
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.user") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:CheckBoxList runat="server" ID="rolesCBoxL" EnableViewState="true" AppendDataBoundItems="true" RepeatColumns="2" Enabled="true" ></asp:CheckBoxList>
</EditItemTemplate>
</asp:TemplateColumn>
This CheckBoxList is created dynamically in ItemCreated function:
DataView dv = ds.Tables[0].DefaultView;
for (int i = 0; i < dv.Count; i++)
{
ListItem li = new ListItem(dv[i]["name"].ToString(), dv[i]["id"].ToString());
rcbl.Items.Add(li);
}
So, when i click the Edit button everuything seems to be OK.
CheckBoxList is visible and even i have some selected values OK.
But , i have a problem with getting this values in UpdateCommand function.
CheckBoxList rcbl = (CheckBoxList)e.Item.FindControl("rolesCBoxL");
for (int i = 0; i < rcbl.Items.Count; i++)
{
if (rcbl.Items[i].Selected)
{
// some DB queries
}
}
This code returns me nothing. I made a breakpoint and figured out that the
rcbl.Items.Count is zero. I don't know how to manage that. Does anyone knows the answer
for this question ? HOW TO GET VALUES FROM DYNAMICALLY CREATED CHECKBOXLIST IN EDITITEMTEMPLATE IN DATAGRID ? Thank You.
voidtech
|
|
|
|
|
|
I've found solution.
It's pretty starnge for me
but i have moved everything from ItemCreated to ItemDataBound and it works
fine right now.
|
|
|
|
|
and i didn't found it at www.programmingknowledge.com 
|
|
|
|
|
Hi Friends,
I am doing a crm software.I have searched may sites for good menu controls could any one of help me to get standard menu in asp.net with c# coding or in html.
kumar
-- modified at 8:02 Monday 17th July, 2006
|
|
|
|
|
If you use ASP.NET 2.0 there is a menu control in the framework that I find to be very nice.
|
|
|
|
|
hi
i m using datalist for rendering the image and i have got one largeimage under this some Thumbnail image are showing.i want if any mousover on any thumbnail image the large image shuld be displayed. i have no idea abut that..can anybody help me.
Thanks
|
|
|
|
|
Hello People,
I have been trying to understand the difference between IIS 5.0 and IIS 6.0 It states that there is a kernel level process called as Http.sys which will route the message to the appropriate application pool which is not the case with IIS 5.0.
Wat Iam not able to understand is how this will give significant performance improvement? Becos in IIS 5.0 the request message is sent from inetinfo.exe to aspnet_worker process which involves interprocess communication. Similarly in IIS 6.0 the request message is being sent from Http.Sys to w3wp.exe wherin there is inter process communoication.
So the question as how the performance is improved by having Http.Sys remains unanswered....
COuld any one throw more light and give a very clear picture stating as how the performance is increased in IIS 6.0?
Thanks in Advance!!!!!!!!!
Vivek
|
|
|
|
|
Could be that performace is not improved by having Http.Sys, but rather by how Http.Sys is implemented. Perhaps its better written?
|
|
|
|
|
Mite be!!!!!!!!but Wat microsoft is instisting is that the http.sys runs in kernle mode which is why it is improves the performance....If some one can throw light on how a soft ware running on kernel mode can improve the performance
|
|
|
|
|
Hai
Where can i find Ajax.NET latest documention. I am a newbie to Ajx.net.
|
|
|
|
|
|
Thanks for your reply
This one is limited . i need full documentation.
|
|
|
|
|
Hello
i want to the Auto Save the file which is in webeditor in every 10 sec using ajax.
|
|
|
|
|
When I am organizing a table in an application, I do not know beforehand how many columns it will contain.
In the Visual Studio-2003 I made it dinamically through command series:
theGrid.Columns.Clear();
theTable.Columns.Clear();
for (i=0; i < val; i++) {
theTable.Columns.Add();
}
for (i=0; i < val; i++) {
acol= new DataGridViewColumn();
theGrid.Columns.Add(acol);
}
But when I use the Visual Studio-2005 with its dataGridView, these commands do not have the effect.
Though headers are OK, the table by itself is just empty, whereas the data are written into it OK.
What can I do to get the data in its grids will be shown?
HilSoft
|
|
|
|
|
Hi there,
DataGridView is a window control, so you should ask in the C# forum.
|
|
|
|
|
HI all,
i have a problem in datagrid..i want to use ,Groping in Data grid,just like Grouping in Crystal Report,,tell me how can i implement this sort of Grouping in DataGrid..
example is
Name
kadfja
yyyyyy
Description
dfasdf
fasdfasdf
i want to implement this grouing in Datagrid..
thnks
waiting for ur?
|
|
|
|
|
IMO, you should group data before binding to the datagrid control. Here, you can use the nested datagrids with the outter control displaying the Name, Description, and the inner to display the details.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
