|
Hi,
i've been trying to create a website in asp that uses a connection to a sharepoint list so i can display the data as i please. here is my latest attempt that still does not work:
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("Provider=Microsoft.ACE.OLEDB.12.0; User iD=xxxxx; Password=xxxxx; Domain=mydomain; WSS; IMEX=1; RetrieveIds=Yes;DATABASE=http://server/path/; List={a1a1a1a-a1a1aa-a1a1a-a1a1a-a1a1aa1};")
SQL = "SELECT * FROM [list]"
Set admin = oConn.Execute(SQL)
all i keep getting is error in iis log:
Cannot_start_your_application._The_workgroup_information_file_is_missing_or_opened_exclusively_by_another_user.
Can anyone help?
|
|
|
|
|
Hi all
I got one error when i am trying to get backup of database.
my error is:An exception of type 'Microsoft.SqlServer.Management.Smo.FailedOperationException' occurred in Microsoft.SqlServer.Smo.dll but was not handled in user code
The medium on device 'd:\' expires on Aug 21 2009 6:44:24:000PM and cannot be overwritten.
BACKUP DATABASE is terminating abnormally.
my code is:
ServerConnection connection = new ServerConnection(con);
Server sqlServer = new Server(connection);
sqlBackup.SqlBackup(sqlServer); //i got error on this line
con is object of sqlconnection
Thanks
|
|
|
|
|
You are trying to overwrite a new backup to existing backup file for which expiration date is set.. and this is not advisable. You can try using init skip parameters in your backup command which will initialise the backup file. Firstly existing backup data will be removed and so your data expiration date check would be skipped. Google for init skip params.
Best Of Luck.
|
|
|
|
|
hi
I have a web based project with asp.net and vb.net.I want to get the hardware information of clients for example cpu,RAM,etc.and save this information in database,I dont want to do it with javascript or activeX control.I think it might be a way to do it through active directory..
if anybody could help me plz answer my post
thanks
|
|
|
|
|
Web is a secured environment. You are not accessing directly through LAN using active directory user account.
AFIK, it is impossible to get CPU and RAM info. The only info available to you from the client is what comes through Request Header.
|
|
|
|
|
Hi All,
I have string which is composed of non English characters(in Indian language). I copied it from some portal and pasted in notepad, while saving file i changed Encoding to UNICODE.
I display the text on webpage using
StreamReader srunicode = new StreamReader(@".....\Enc\Unicode.txt");
Response.Write(srunicode.ReadToEnd());
above code snippets gives expected result.
Now if I pick some part of string and assign to string variable
string sData = "प्रश्न";
Response.Write(sData);
shows some unreadable characters.
Do i need to convert the encoding format?
I tried adding below line in Head element
Still no effect.... Plz help
|
|
|
|
|
yogesh.rain wrote: I have string which is composed of non English characters
Hi Yogesh,
I think you need something more-Internationalization[^].
In case, if you do not have such a generic information then I am not sure of this. 
|
|
|
|
|
Hello,
The below code returns the image-button that causes the post back. However it causes another problem. when I clicked one of the image_button (that is placed in datalist), the items of that datalist disappear.
Please, please help. I am dealing with this problem for a while now, and it is drawing me crazy.
Please click on any "Ekle" button in this Page[^] to what I mean.
private string getPostBackControlName()
{
Control control = null;
string ctrlname = Page.Request.Params["__EVENTTARGET"];
if (ctrlname != null && ctrlname != String.Empty)
{
control = Page.FindControl(ctrlname);
}
else
{
string ctrlStr = String.Empty;
Control c = null;
foreach (string ctl in Page.Request.Form)
{
if (ctl.EndsWith(".x") || ctl.EndsWith(".y"))
{
ctrlStr = ctl.Substring(0, ctl.Length - 2);
c = Page.FindControl(ctrlStr);
}
else
{
c = Page.FindControl(ctl);
}
if (c is System.Web.UI.WebControls.Button ||
c is System.Web.UI.WebControls.ImageButton)
{
control = c;
}
}
}
if (control != null)
{
return control.ID;
}
else { return "budegil";}
}
|
|
|
|
|
i hav a gridview with check box in it
if i click the checkbox
the value should be saved
tanx
|
|
|
|
|
Check if you bind always gridview on page load.
try this
<br />
if(!Page.IsPostBack)<br />
{<br />
}
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
anbusenthil wrote: gridview with check box
I just google with the above string and first result is this[^].
Please do some searching then post.
|
|
|
|
|
how to add coding to the click event of the pager control in gridview
when i click the pager control i need an alert msg
lik yes or no...
if the user clicks yes only , the page should get to next page or it should stay in the same page
tanx
|
|
|
|
|
Look at this Article in the OnPageIndexChanging event show alert box from there
http://www.codeproject.com/KB/aspnet/Paging_without_a_Wizard.aspx[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi all,
I haved used a DataTable to fill a grid. On mouse over of a row ,I want to show some other info about this row in some textboxes . I really dont know how to do this.
Can anyone help?
Thanks in advance.
|
|
|
|
|
onmouse over this is how we do it
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='Silver'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='White'");
}
}
now you can choose to to add what you want your grid to do, i just did the color changing.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
hi Vuyiswa Maseko
thank u for the answer
i already know how to change the color of the rows,but calling a javascript function to get some other details about that row from the dataTable is somehow complex.
i can't pass that row to the function so that i can extract the fields and display them in textboxes .
|
|
|
|
|
hii...
i hav 3 textbox named:txtqty,txtproductprice,txttotalprice.
i want that when the cursor goes to txttotalprice.the txttotalprice
textbox get initialized by the value which is multiple of txtqty and txtproductprice.i hav used the textbox changed event of txttotalprice
like this:
<asp:textbox id="txttotalprice" runat="server" ontextchanged="txttotalprice_TextChanged">
then i hav coded it like this:
protected void txttotalprice_TextChanged(object sender, EventArgs e)
{
string s = txtqty.Text;
string k = txtproductprice.Text;
int i = Convert.ToInt32(s);
int j = Convert.ToInt32(k);
int l = i * j;
txttotalprice.Text = Convert.ToString(i);
}
but it doesnt show any value in txttotalprice...
|
|
|
|
|
mylogics wrote: protected void txttotalprice_TextChanged(object sender, EventArgs e)
{
string s = txtqty.Text;
string k = txtproductprice.Text;
int i = Convert.ToInt32(s);
int j = Convert.ToInt32(k);
int l = i * j;
txttotalprice.Text = Convert.ToString(i);
}
--instead use
{
double i = double.parse(txtqty.Text);
double j = double.parse(txtproductprice.Text);
double l = i*j;
txttotalprice.Text = l.Tostring();
}
|
|
|
|
|
If you have no idea what the answer is, it's best to stay silent. Your code is not functionally different from his, and both suffer from the same basic problem.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
hiii
still not workin.it just shows nothin in txttotalprice.
|
|
|
|
|
This sort of thing gets posted EVERY day. Imagine if your page actually refreshed EVERY time you typed something ?
This event fires if you force a postback by other means. To do what you want, it needs to be done in javascript,
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Why you don't use javscript for that calculation?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
can u give me some idea hw cud i use javascript for this calculation...
|
|
|
|
|
Here it is.
function Calculate()<br />
{<br />
document.getElementById('<%=txttotalprice.ClientID%>').value=<br />
document.getElementById('<%=txtqty.ClientID%>').value * <br />
document.getElementById('<%=txtproductprice.ClientID%>').value<br />
}
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
hi
you know , i think you`d better not do that like this !!! 
because ontextchanged , sends the information to the server andyour page relodes and takes so much time !
it`s better to do this on client side with java script
something like this :
var quantity = document.getElementById('txtqty').value;
var price = document.getElementById('txtproductprice').value;
document.getElementById('txttotalprice').value = quantity*price;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
